Posts tagged with "database"

November 2024

• 🐥 How to add relative percentages to MySQL query results 21 Nov 2024
• 🔗 How to Implement a Global Transaction for All Routes in Laravel 20 Nov 2024
• 🐥 The Hidden Dangers of Sorting and Pagination in MySQL: Handling Nullable Columns 18 Nov 2024
• 🔗 Prevent Destructive Commands From Running in Laravel 3 Nov 2024

October 2024

• 🔗 Search is not magic with PostgreSQL 29 Oct 2024
• 🔗 IEx "any" Helper 26 Oct 2024
• 🔗 Optimizing Postgres table layout for maximum efficiency 21 Oct 2024
• 🐥 TIL: Deleting duplicate rows in a database 14 Oct 2024
• 🔗 Proposal to make MariaDB the default MySQL variant in Ubuntu 25.04 14 Oct 2024
• 🔗 PostgreSQL: Full text search with the "websearch" syntax 13 Oct 2024
• 🐥 Backing up a PostgreSQL database 11 Oct 2024
• 🔗 PostgreSQL and UUID as primary key 11 Oct 2024
• 🔗 Stop using SERIAL in Postgres 8 Oct 2024
• 🔗 Building RAG with Postgres 5 Oct 2024
• 🔗 Tree hierarchies in Laravel 3 Oct 2024

September 2024

• 🔗 MySQL ORDER BY with nulls first or last (at bottom or top) 29 Sep 2024
• 🔗 PostgreSQL 17 Released! 27 Sep 2024
• 🐥 A subtlety of Ecto.Query.preload 22 Sep 2024
• 🔗 SQLite is not a toy database 19 Sep 2024
• 🔗 Add an use a JSONB field in Phoenix and Ecto 6 Sep 2024

August 2024

• 🔗 Postgres as a search engine 25 Aug 2024
• 🐥 Creating a copy of a database in PostgreSQL 8 Aug 2024
• 🔗 Add columns with custom types in Laravel Migrations 8 Aug 2024
• 🐥 Installing psql version 16 on Ubuntu 7 Aug 2024

July 2024

• 🔗 Fine Tuning Full Text Search with PostgreSQL 12 25 Jul 2024