2 ms·

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 synchronizat

by chmike 10y 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.

talideon 10y ago
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.
- chmike 10y ago
  Then SQLite is obviously a better solution than MySQL and PostgreSQL.