Insights
Practical guides on AI coding agents, LLM costs, websites and custom software: what we built, what it cost and what we would do differently.
Articles tagged Databases
Extensions let PostgreSQL handle case-insensitive text, fuzzy search, UUIDs and spatial queries without application code. What each is for, when it is the wrong tool, and why your host decides what you can install.
A free hosted database that pauses after inactivity is a fair trade for a side project and a risk for anything people depend on. Here is what pausing does, and how long you really have.
A backup is a claim and a restore is the evidence. Here is a routine a small team can keep: where copies live, how often they run, how to rehearse a restore on a scratch database, what to check, and how to record it.
Running your own PostgreSQL is reasonable for a side project and a real commitment for a business. The software is the same; the duties are not.
Supabase can cost nothing hosted, locally or on your own server, but each option asks for something different. Here are the real limits, the self-hosting work, and how PocketBase, Appwrite and Nhost compare.
A database that works on your laptop can be reachable by anyone once the project is public. The Supabase linter flags the tables, policies and keys that let that happen.
A local Supabase reset takes seconds and discards everything that is not in a migration. Here is what a dump does and does not contain, and a routine you can restore.
In Supabase the database is reachable through an API, so row-level security is the access control. Here is what it does, the mistake that exposes a table, and how to test a policy as anon and as a signed-in user.
A second local Supabase project collides on the same ports, and hand-offset ports drift away from your app config. See what the CLI now assigns and what it costs.
A schema change belongs in a file that every environment applies the same way. Here is how Supabase migrations are created, applied, reset and reviewed, and why a change made in Studio is not one yet.
