·4 min readDatabases
PostgreSQL tips I wish I knew earlier
Practical PostgreSQL tips and patterns that have saved me time in real projects, from indexing to JSON queries to connection management.
Databases
5 posts
·4 min readDatabases
Why I use Meilisearch instead of Elasticsearch
What makes Meilisearch a better fit for most projects than Elasticsearch, and why simpler search does not mean worse search.
·3 min readDatabases
SQLite: the most underrated database
Why SQLite deserves more respect as a production database, and the use cases where it outperforms client-server databases.
·9 min readDatabasesWeb Dev
Choosing a database for a small SaaS
SQLite, PostgreSQL, or a managed database? Here is how I think about the decision for small, indie SaaS projects.
·7 min readDatabases
How database indexes actually work
B-trees, query plans, and why adding an index does not always make things faster.