November 2024
-
20 Nov 2024🔗How to Implement a Global Transaction for All Routes in Laravel
-
18 Nov 2024🐥The Hidden Dangers of Sorting and Pagination in MySQL: Handling Nullable Columns
-
3 Nov 2024🔗Prevent Destructive Commands From Running in Laravel
October 2024
-
29 Oct 2024🔗Search is not magic with PostgreSQL
-
26 Oct 2024🔗IEx "any" Helper
-
21 Oct 2024🔗Optimizing Postgres table layout for maximum efficiency
-
14 Oct 2024🐥TIL: Deleting duplicate rows in a database
-
14 Oct 2024🔗Proposal to make MariaDB the default MySQL variant in Ubuntu 25.04
-
13 Oct 2024🔗PostgreSQL: Full text search with the "websearch" syntax
-
11 Oct 2024🐥Backing up a PostgreSQL database
-
11 Oct 2024🔗PostgreSQL and UUID as primary key
-
8 Oct 2024🔗Stop using SERIAL in Postgres
-
5 Oct 2024🔗Building RAG with Postgres
-
3 Oct 2024🔗Tree hierarchies in Laravel
September 2024
-
29 Sep 2024🔗MySQL ORDER BY with nulls first or last (at bottom or top)
-
27 Sep 2024🔗PostgreSQL 17 Released!
-
22 Sep 2024🐥A subtlety of Ecto.Query.preload
-
19 Sep 2024🔗SQLite is not a toy database
-
6 Sep 2024🔗Add an use a JSONB field in Phoenix and Ecto
August 2024
-
25 Aug 2024🔗Postgres as a search engine
-
8 Aug 2024🐥Creating a copy of a database in PostgreSQL
-
8 Aug 2024🔗Add columns with custom types in Laravel Migrations
-
7 Aug 2024🐥Installing psql version 16 on Ubuntu