Posts tagged with "database"

December 2024

• 🔗 Don't Do This in PostgreSQL 21 Dec 2024
• 🔗 Easy totals and subtotals in Postgres with rollup and cube 18 Dec 2024
• 🔗 Optimizing SQLite for servers 17 Dec 2024
• 🔗 Modelling `through` relationships with Ash 9 Dec 2024
• 🔗 UUID, ORM and Strange Deadlocks 7 Dec 2024
• 🔗 Introduction to Ecto.Multi 6 Dec 2024
• 🔗 Historized Attributes: Systematic Table Design 3 Dec 2024

November 2024

• 🐥 Dynamic order by using Phoenix Ecto 27 Nov 2024
• 🐥 Be careful with building delete statements using Laravel Query Builder 26 Nov 2024
• 🔗 Choosing the right Postgres indexes | Blog 26 Nov 2024
• 🔗 How to do a preload good using Ecto 23 Nov 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