database

4 articles · newest first

Editorial illustration of a traveler with a backpack at a fork in a path, a lavender elephant on the left branch and a coral dolphin on the right

Postgres vs MySQL for a new project: pick Postgres unless one of these is true

Both are free and mature. For a new app in 2026, the docs tilt toward Postgres: a permissive licence, indexed jsonb, a free vector extension and hosts on every budget. Here is what each project's own documentation says, what I could not verify, and the cases where MySQL still wins.

Aliteq Team · Oct 16 · 9 min

Photo of a small matte black server box with two glowing coral lights sitting on a desk above an open drawer of blank folders

Software

SQLite in production: when one file is enough, and how to back it up

SQLite is a whole database in one file, and its own docs say it fits most websites. The catch is one writer at a time and a backup plan you have to build. Here is when it is enough, what WAL mode changes, and where D1 and Turso fit.

Aliteq Team · Oct 16 · 11 min

Flat vector illustration of a puzzled developer holding a laptop and looking up at a giant coral pause button sitting on a frozen database cylinder, on a saturated indigo-violet background

Build

Supabase project paused? Every free tier limit, and what Pro really costs in 2026

Your vibe-coded app went quiet for a week and now it won't load. Here is every Supabase Free limit, the exact thing that breaks when you cross each one, and the real monthly bill once you upgrade.

Aliteq Team · Oct 16 · 9 min

Flat illustration of a person pointing at one coral tab on the edge of a giant open book

Software

Postgres query slow? When to add an index, and when it makes things worse

An index speeds up reads and taxes every write. Here is when it pays, how to order the columns, and how to read EXPLAIN, using the PostgreSQL docs and our own price table, where five indexes take up more room than the data.

Aliteq Team · Oct 9 · 9 min