postgres

5 articles · newest first

Flat illustration of a person holding a coral frame over three highlighted rows in a tall stack of table rows

SQL window functions explained: running totals, rank and LAG in Postgres

GROUP BY collapses your rows and you lose the detail. A window function keeps every row and adds the total, the rank or the previous value beside it. Eight runnable PostgreSQL examples, including the tie trap that makes running totals jump.

Aliteq Team · Oct 16 · 11 min

Flat illustration of a person holding the end of a film strip that unrolls from a giant database cylinder, with one coral frame on the strip

Software

Change data capture (CDC) in Postgres: replication slots, Debezium and the WAL risk

CDC turns every insert, update and delete into an event another system can read. The best method reads Postgres's own log, and its one sharp edge is a forgotten replication slot that quietly fills your disk. Here is how it works, what Debezium and Supabase do with it, and when you do not need any of it.

Aliteq Team · Oct 16 · 10 min

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

Software

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

Hand-drawn editorial illustration of a uniformed doorkeeper holding up a hand mirror at an arched violet door; the mirror shows him holding a mirror, repeating into an endless tunnel, while a coral padlock hangs on the door, on a near-black background

Build

"infinite recursion detected in policy" in Supabase? Your admin check is asking itself

Your Lovable or Bolt app got an admin check, and now every read of that table fails with error 42P17. The policy is reading the table it protects, so Postgres stops the loop. The fix Supabase documents keeps RLS on and takes one small function. Plus the three quick fixes that hand your data to anyone.

Aliteq Team · Oct 12 · 8 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