Technology
SQLite vs PostgreSQL: Which One in Production?
I compare the performance, concurrency, backup, and resource consumption differences of SQLite and PostgreSQL in production environments based on my field.
#sqlite
4 posts found.
Life
MVCC Misconceptions: The Indie Hacker's Database Choice Dilemma
I analyze the practical implications of MVCC, performance trade-offs, and real-world scenarios when choosing a database for indie hackers.
Technology
SQLite and Concurrency: The Lockout Experienced at islistesi.com
A first-hand account of the SQLite concurrency and lockout problems I faced in the islistesi.com project, with the solution steps and lessons learned.
Tutorials
Securely Deploying an SQLite Database to a Docker Container with
A guide to securely deploying an SQLite database to a Docker container using GitHub Actions.