Blog · 3 files
| Name | Tags | Date | Read |
|---|---|---|---|
| October 2026 · 1 posts | |||
| upsert-sql-server-postgresql-sqlite-guide.md Concurrency-safe upserts in SQL Server, PostgreSQL and SQLite How upserts break under concurrency and how to write them safely: UPDLOCK and SERIALIZABLE or MERGE in SQL Server, ON CONFLICT, MERGE and RETURNING in PostgreSQL, native UPSERT in SQLite, and why INSERT OR REPLACE is not one. Databases | #sql #sql-server #postgresql #sqlite | 7 min | |
| August 2026 · 2 posts | |||
| how-this-site-works.md How this site works Why I put my CV inside an IDE and a real SQLite database, and how the SQL console below is kept safe. .NET | #dotnet #sqlite #security | 1 min | |
| sqlite-insert-performance-ios.md Fast and safe bulk inserts in SQLite: transactions, WAL and iOS Why SQLite bulk inserts are slow by default, the three techniques that fix it, what synchronous=OFF and journal_mode=MEMORY really risk, why WAL with synchronous=NORMAL is a safer default, and how it all applies to Core Data, SwiftData and .NET. iOS Databases | #sqlite #ios #dotnet #performance | 8 min | |