Postgres for
Search and Analytics
ParadeDB is a modern Elasticsearch alternative built on Postgres.
"Get or create" is a very common operation for syncing data in the database, but implementing it correctly may be trickier than you may expect. If you ever had to implement it in a real system with real-life load, you may have overlooked potential race conditions, concurrency issues and even bloat!
PostgreSQL zero-downtime migrations made easy
a fork of sqlite that is “open to contribution”
Subqueries and performance in PostgreSQL
Relational (inner) joins are really common in the world of databases, and one weird thing about them is that it seems like everyone has a different idea of what they are. In this post I’ve aggregated a bunch of different definitions, ways of thinking about them, and ways of implementing them that will hopefully be interesting. They’re not without redundancy, some of them are arguably the same, but I think they’re all interesting perspectives nonetheless.
A truly Open Source MongoDB alternative, built on Postgres
The (composite_value).* expansion to columns was new to me. And useful in a recent query I had to write.
Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.