4 ms·
Are you using SQLite in production too? I'm curious about your domain - is it a web application or something else?
by joshmarlow 5y ago
Are you using SQLite in production too? I'm curious about your domain - is it a web application or something else?
- bob1029 5y agoWe do use it in production. Have been for years. We use it as part of the back-end of a business workflow automation system. Handles 100-1000 concurrent users without any issues.
- joshmarlow 5y agoThanks for the details. I would be afraid to use SQLite over Postgres as SQLite is much more... flexible with it's database constraints (or at least, this used to be the case). Not knocking your engineering choices - if you've been running it in prod for years, then it's working for you - just interested. Do you lean into DB constraints much or do you do more application level checking/enforcement?
- scns 5y agoNot parent but mentioning nuget suggest parent is on dotnet, ie C/F# ergo semi-/typesafe. Parsing (not validating) at the edges should take care of it.
- bob1029 5y ago> Parsing (not validating) at the edges should take care of it. Precisely. We use a tiny ORM on top of Dapper to make sure everything goes in and out of columns as expected.
- mekster 5y agoHow is isolation important to use SQLite? Edge does not provide safety to every database modifications like manually editing data and you're screwed already.
- bob1029 5y agoWe never allow for manual edits of live SQLite databases. Everything happens through code. If someone wants to play around with a SQLite database from production, we just copy the file and hand it to them. That's kinda the whole point IMO.