louis's Blog

louis's Avatar Image
Software developer #Go #CommonLisp #JS #SQL. #LispWorks user. Soft spots for #Emacs #SmallWeb. Recently becoming #OpenBSD enthusiast.

Other hobbies: #Running #FireFighter #StarTrek
← All posts

I find it increasingly difficult to self-host a #PostgreSQL database and have full confidence that it runs in a fully optimized way. There are so many settings, many targeting the underlying VM/hardware. Often I don’t even have enough information about the VM/hardware to know what the most optimal settings are.

PostgreSQL devs are adding tons of new features and settings with every release.

There should be a lightweight “auto” mode where PG figures out the most appropriate settings with only a few hints.

But PG is now an enterprise RDBMS primarily targeting Oracle customers. Simplicity is not a quality they expect and I understand that.

I think it is time to explore the #SQLite route as an alternative. There is https://rqlite.io a fault-tolerant distributed SQLite server with an HTTP API written in Go, with automatic S3 backup and restore.

To like or reply, open original post on Emacs.ch