November 2024
-
26 Nov 2024🐥Be careful with building delete statements using Laravel Query Builder
-
26 Nov 2024🔗Choosing the right Postgres indexes | Blog
-
23 Nov 2024🔗How to do a preload good using Ecto
-
21 Nov 2024🐥How to add relative percentages to MySQL query results
-
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