Jiwa

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.

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 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

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

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.

lol

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

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.