2025 December

Store and serve

As we read in the previous article, PostgreSQL is my database of choice. That isn’t just because I prefer Postgres over alternatives like MySQL, but because I once read an article titled “A Poor Man’s API”

That title stuck with me. To me, it captured the idea of an affordable, no-frills solution: using the database itself as a solid foundation for serving data, without all the extra layers and complexity that often come with a traditional backend.

-–

This idea might sound familiar: as Supabase — a well-known data store-and-serve platform — is essentially a curated stack built around PostgREST. In other words, we’re running our own Supabase — just without the platform layer.

The Postgrest implementation im using is available in this repository https://github.com/boudewijn00/theridiid-postgrest