Welcome • User Guide
ToS • Privacy • Canary
Donate • Bugs • License

©2024 Poal.co

955

(post is archived)

[–] [deleted] • 3 pts

most cases

Is the writer's target audience hobbyists? SQLite is a terrible choice for anything larger than personal/small projects, imo.

[–] • 2 pts

Yeah, I think his target audience is non-commercial users. SQLite wouldn't work in a production environment unless what you're deploying is compartmentalized per user.

[–] • 1 pt

I use SQLite when I don't need an enterprise solution. 1) the SQL syntax isn't ANSI, 2) it isn't adequate over a network, 3) forget concurrent access. I'm not disparaging SQLite, only pointing out it has a limited use case. That use case is a single user on a local machine using local storage.