How to Properly Backup a SQLite Database?
SQLite is a great database for many applications. Here's how to properly back up a SQLite database.
I'm a fullstack engineer who writes about building software. This is where I work through ideas in public — what I'm learning, what broke, what turned out simpler than expected.
Latest articles
Inspire Me - Episode 1: A 16-Year-Old in Burundi Taught Himself C++ on a 2008 Computer
A 16-year-old in Burundi taught himself C++ on a 2008 computer with 2GB RAM. He placed top 20 in Google Code-in globally. Here is his story.
Teach Yourself Touch-Typing
I dreamed about touch-typing for years. Then I tried, and failed every time. Here's what finally worked in a month.
Latest snippets
The SQLite PRAGMAs I set on every production database, split by when to apply them, with measured benchmark data.