SQL Server on a Raspberry Pi.

Discussions relating to Jiwa 7 plugin development, and the Jiwa 7 API.

SQL Server on a Raspberry Pi.

Postby pricerc » Tue Aug 03, 2021 6:01 pm

In case you missed it.

Azure SQL Edge can be installed on Linux machines running on ARM64 CPUs. https://docs.microsoft.com/en-us/azure/ ... deployment

This means that you can run SQL Server on a Raspberry Pi.

2021-08-03 18_57_26-Jiwa 7 2021 - VMware Workstation.png
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 518
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 21

Re: SQL Server on a Raspberry Pi.

Postby Mike.Sheen » Tue Aug 03, 2021 6:05 pm

pricerc wrote:In case you missed it.

Azure SQL Edge can be installed on Linux machines running on ARM64 CPUs. https://docs.microsoft.com/en-us/azure/ ... deployment

This means that you can run SQL Server on a Raspberry Pi.

2021-08-03 18_57_26-Jiwa 7 2021 - VMware Workstation.png


For crying out loud don't tell everyone! As it is our customers often cheap out when selecting hardware for their on-premise SQL Servers!

I do NOT want to encounter Jiwa running on one of these in the wild!
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807

Re: SQL Server on a Raspberry Pi.

Postby pricerc » Tue Aug 03, 2021 6:20 pm

Mike.Sheen wrote:
pricerc wrote:In case you missed it.

Azure SQL Edge can be installed on Linux machines running on ARM64 CPUs. https://docs.microsoft.com/en-us/azure/ ... deployment

This means that you can run SQL Server on a Raspberry Pi.

2021-08-03 18_57_26-Jiwa 7 2021 - VMware Workstation.png


For crying out loud don't tell everyone! As it is our customers often cheap out when selecting hardware for their on-premise SQL Servers!

I do NOT want to encounter Jiwa running on one of these in the wild!


my bad :twisted:

It would not have occurred to me, except that I got a Pi for 'home' use a few weeks back, and I'm just getting my head around it.

I obviously knew about SQL on Linux from a previous discussion, so I decided to Google SQL on ARM64. I was slightly surprised to find that such a thing exists. It's clearly aimed at IoT devices, but I'm nonetheless impressed that it works.

And yes, I was able to fire up Jiwa using it.... But I'm not using the SD Card, I have an external SSD running SCSI over USB - the performance is 'acceptable'. I've seen worse on customer sites :P

But *no* I would not recommend any 'server' that doesn't actually have at least a couple of SATA ports so you can mirror your data.
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 518
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 21

Re: SQL Server on a Raspberry Pi.

Postby Scott.Pearce » Wed Aug 04, 2021 4:07 pm

lol
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 765
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 230

Re: SQL Server on a Raspberry Pi.

Postby pricerc » Wed Aug 04, 2021 4:51 pm

I thought the folk that frequent this forum would find it entertaining :P

Jokes aside, the Pi can run Ubuntu Linux, and my one has 8GB of RAM and 4 cores running at 1.5GHz. So its performance is better than you might expect.

If it wasn't for the fact that the "starter kit" version that I have only has USB for a disk connection, it would be more interesting. That said... there's a different version of the Pi (the 'compute module') that has an IO board with a PCIe slot, so you can actually add a proper storage controller to it, as long as it has Linux drivers. Only problem is you have to fabricate your own case.

For a really budget, entry-level 'SQL server', you'd still be way better off with a good quality off-lease workstation-class PC with some new good quality SSDs.
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 518
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 21


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 0 guests