The Logic Decode blog

Every article, one place

Tutorials, deep-dives, and the trends that actually matter — filter by topic below.

Browse the full archive of 192 articles →

All Python Web Dev AI & ML DevOps CS News

GPT-6 Astra: The AGI Claim vs What the Benchmarks Say

OpenAI shipped GPT-6 Astra and declared the AGI era. Its own scorecard splits in half. What the numbers actually mean if you ship agents.

Sep 4, 20268 min

Web Dev

Pagination, filtering and sorting

The intParam helper that stops a negative limit from becoming SQLite's 'no limit at all', plus how Linkstash filters with LIKE and sorts newest first.

Sep 4, 20266 min

Web Dev

User accounts and password hashing done right

Why registerUser inserts first and catches the UNIQUE violation instead of checking first, and why verifyUser hashes a dummy password on every failed login.

Sep 4, 20267 min

News

GitLab's 2017 Database Deletion: Five Backups, None Worked

An engineer ran rm -rf on GitLab's primary database in 2017. Every recovery path failed. What that outage still teaches about testing your backups.

Sep 3, 202611 min

Web Dev

Authentication: sessions vs JWT

How Linkstash's opaque session tokens actually work end to end, and the real tradeoff against JWTs: revocability versus a database lookup on every request.

Sep 3, 20266 min

Web Dev

Validating input before it ruins your day

Use Zod's safeParse to reject bad input at the boundary before it reaches your database, with the exact credentials and newLink schemas from Linkstash.

Sep 3, 20266 min

Web Dev

Connecting a database

Wire better-sqlite3 into Express, understand prepared statements as the fix for SQL injection, and why WAL mode is meaningless on an in-memory database.

Sep 2, 20268 min

Web Dev

Error handling and the async trap

How Express 5's four-argument error middleware works, why route order matters for the 404 catch-all, and the async trap Express 4 developers had to work around.

Sep 2, 20266 min

Web Dev

Middleware: the chain every request walks

What middleware actually is in Express, how the (req, res, next) signature works, and the exact bug you get when a middleware forgets to call next.

Sep 1, 20266 min