October 2024
-
🔗Search is not magic with PostgreSQL
-
🔗IEx "any" Helper
-
🔗Optimizing Postgres table layout for maximum efficiency
-
🐥TIL: Deleting duplicate rows in a database
-
🔗Proposal to make MariaDB the default MySQL variant in Ubuntu 25.04
-
🔗PostgreSQL: Full text search with the "websearch" syntax
-
🐥Backing up a PostgreSQL database
-
🔗PostgreSQL and UUID as primary key
-
🔗Stop using SERIAL in Postgres
-
🔗Building RAG with Postgres
-
🔗Tree hierarchies in Laravel
September 2024
-
🔗MySQL ORDER BY with nulls first or last (at bottom or top)
-
🔗PostgreSQL 17 Released!
-
🐥A subtlety of Ecto.Query.preload
-
🔗SQLite is not a toy database
-
🔗Add an use a JSONB field in Phoenix and Ecto
August 2024
-
🔗Postgres as a search engine
-
🐥Creating a copy of a database in PostgreSQL
-
🔗Add columns with custom types in Laravel Migrations
-
🐥Installing psql version 16 on Ubuntu
July 2024
-
🔗Fine Tuning Full Text Search with PostgreSQL 12
-
🔗Just Use Postgres for Everything
-
🔗Postgres is Enough