Daily edition · PostgreSQL
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
5 articles · 2 sources ·
Top topics: PostgreSQL · Python · Django
Every table needs a way to tell its rows apart, and auto-incrementing surrogate keys have been the go-to solution since practically the dawn of time. They're simple. They're fast. And perhaps most importantly, they're…
Prevent your migration from starving behind long-running queries.
The load finished without complaint, with row counts matching the fixture file and every foreign key resolving, but then the application inserts a row of its own, and Postgres refuses it: ERROR: duplicate key value…
The Request Becomes a Transaction# A transactional API has two halves: a network edge and a transactional operation. Keep the first at that edge; give the second to PostgreSQL, where its authority already lives — and…
Django and PostgreSQL can handle fuzzy name matching with Soundex, Daitch-Mokotoff, Levenshtein distance, and trigram similarity, each suited to different kinds of misspellings and phonetic variation. The article shows…
