3 ms·
With C# (Entity Framework) I've tried and failed using sqlite in a production scenario because of concurrency issues... Recently I stumbled over a potential fi
by sandreas 5y ago
With C# (Entity Framework) I've tried and failed using sqlite in a production scenario because of concurrency issues...
Recently I stumbled over a potential fix[1], which I will try in my next project.
[1] https://ja.nsommer.dk/articles/thread-safe-async-sqlite3-entity-framework-6.html https://ja.nsommer.dk/articles/thread-safe-async-sqlite3-ent...
- barryhennessy 5y agoOuch, that sounds like a nasty bug. But if I understand correctly it's more the driver/ORM's problem than sqlite's? One to look out/test for early if I go in this direction though. Thanks for the heads up!
- sandreas 5y ago> But if I understand correctly it's more the driver/ORM's problem than sqlite's? I think so. sqlite is pretty reliable in my opinion and I never hat these issues anywhere else, but this bug made me switch my DMBS for a small side project from sqlite to postgres. > One to look out/test for early if I go in this direction though. You're welcome!