Raspberry Pi as family computer?

[CptKrf]

Been a long time since I worked with Mysql, but I suspect that the difference comes down to M*DB being considerably more sophisticated DBs than the fairly simple Sqlite, putting cacheing to good use in memory. Could be wrong, but I have tried Pi4's and a 5 with Sqlite MANY times and get only pitiful throughput. At first I assumed it was Perl honking up the speed, being a scripting language, but when I experimented with raw C, I got an improvement but it certainly didn't match what I get on an ordinary PC.

Whatever. I still really like PI's for my projects. I just don't use them if there will be any major data chomping.

Or... Could be that I am a lousy database programmer.

 

[tinfoil-hat]

I'd rather choose a Lenovo ThinkCentre M900 or something alike. you can get them cheap off ebay, you can easily replace the hardware (SSD,HDD,NVMe SSD, low profile PCI, RAM). They are very reliable and have low energy consumption. You got some good IO and very much bang for the bucks

ThinkCentre M900 Tiny for sale | eBay

Get the best deals for ThinkCentre M900 Tiny at eBay.com. We have a great online selection at the lowest prices with Fast & Free shipping on many items!

www.ebay.com

 

[tinfoil-hat]

Also I wouldn't recommend a RPi for Desktop usage since it's storage is an SD Card, which dies very quickly with a lot of read and write.