Hacker News new | ask | show | jobs
by chmike 3651 days ago
SQLite is Ok, but write access must be synchronized. I used it for my Flask (Python) application and was forced to switch to PostgreSQL because of synchronization problems. I would prefer sticking with SQLite which was simpler to manage.

The author doesn't say a word about synchronization when writing to SQLite.

1 comments

It's intended for desktop, single-user use from the command line. In such cases, you're not going to have much of an issue with write contention.
Then SQLite is obviously a better solution than MySQL and PostgreSQL.