Postgres SSL Modes Explained: disable, allow, prefer, require, verify-ca, verify-full
What each sslmode value actually guarantees, why "prefer" is a weaker promise than it sounds, and how to pick one for a real connection.
the blog
Practical write-ups on how SQL and these two databases actually work — written alongside building QuerySQL.
What each sslmode value actually guarantees, why "prefer" is a weaker promise than it sounds, and how to pick one for a real connection.
SQLite's hidden rowid, when an INTEGER PRIMARY KEY becomes an alias for it, and what changes with WITHOUT ROWID tables.
What a transaction actually buys you, the ACID guarantees behind it, and why staging edits before committing is safer than editing live.
Entities, normalization without the jargon, choosing keys, and the foreign-key decisions that are hardest to undo later.
INNER, LEFT, RIGHT, FULL, and CROSS JOIN, worked through with a two-table example until each one clicks.
Where a single file beats a server, where concurrency and scale flip that answer, and how to tell which side of the line your project is on.