I’m sure they’re answering a question that almost nobody is asking, but Rustproof Labs did some benchmarks of Postgresql running on Raspberry Pi.
I don’t think I’d recommend that anyone run a relational database on a Pi, especially using SD as storage. But having said that, a lot of businesses with modest reporting needs could actually use a Pi as a database server.
Heck, for Assign It To Us, a Pi running Postgresql is more than enough for the data volume we need for our internal reporting (although I’d definitely want to use something other than an SD card for storage).
Practically speaking though, a lot of small businesses could probably get away with an inexpensive NUC for their business intelligence/data warehousing needs.
Other articles by this author:
- Get To Know Extrata, Episode 2: Database Writeback
- Quick Hit: Craig Kerstiens’s Postgresql Hidden Gems
- Set up your own Business Intelligence/Data Warehousing/Reporting solution on the cheap
- Luna – WYSIWYG Data Processing
- Easy Database Version Control (a.k.a. migrations) with Flyway