Tag: sql
Reading your own writes with WAIT FOR LSN in Postgres 19
PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.
Predrag Gruevski - Trustfall, Cargo Semver Checks, and the Future of Query-Based Tools
Predrag Gruevski explores Trustfall, a revolutionary query tool that turns anything into queryable data, and cargo-semver-checks for Rust semantic versioning.
Spooky Database Relations
A discussion of the least-on-brand thing to ever happen on Halloween: The Halloween problem, a database querying issue with a long legacy.
Recipes from Python SQLite docs
Practical SQLite recipes for Python: execute statements, batch operations, transactions, row factories, and context managers with sqlite3.
Pick random values from an array in SQL(ite)
Emulate Python's random.choice in SQLite using JSON arrays and the random() function. Populate tables with realistic test data efficiently.
Instead Of MAX Use LAST_VALUE For Time-Based Data
Why MAX returns the wrong number for end-of-period values in time-series SQLite data, and how LAST_VALUE with a window frame gives correct results.
Stop abstracting early
Selecionar Um Intervalo de Linhas em MySQL
Utilizar MySQL é muito simples. Neste tutorial ensino a selecionar apenas um intervalo de linhas em MySQL.