· 4 min · PostgreSQL, Python, Tools

cygnet: A small but fierce ORM

Cygnet is a PostgreSQL ORM for async Python that refuses to hide the SQL.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: enable_indexscan and enable_bitmapscan

Diagnose index scan performance problems by temporarily disabling index scans or bitmap scans and measuring what the planner chooses instead.

0 comments

· 4 min · Python, Tools

poveglia: Quarantine Your Imports

Quarantine user uploads before they reach your system.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: enable_async_append

Async append lets the planner fan out queries across remote shards in parallel instead of one at a time, but it's a diagnostic switch, not a tuning knob.

0 comments

· 4 min · Django, Python, Tools

django-pgware: The Undo Is the Hard Part

Three PostgreSQL utilities merge into one package: advisory locks (now async), query-log silencing without race conditions, and session-scoped GUC control.

0 comments

· 3 min · PostgreSQL, Python, Tools

waxsql: Wax Fruit for Your Query Planner

Generate valid SQL that looks real, nourishes nothing, and never spoils.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: effective_io_concurrency

`effective_io_concurrency` has changed what it means twice—from a harmonic-series spindle count to a direct request depth to a real async I/O control.

0 comments

· 3 min

skygrad: A Place and a Time, Rendered as Sky

Render the sky at any place and moment as a PNG gradient, with zero dependencies and pixel-perfect determinism.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: effective_cache_size

effective_cache_size doesn't allocate memory, reserve RAM, or control runtime behavior—it merely whispers a number to the query planner to make it smarter…

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: dynamic_shared_memory_type

Parallel queries in PostgreSQL need shared memory sized at runtime, not startup.

0 comments