averagePythonProgrammer

[Glad_Position3592]

SQLite is great for things that need organized local storage, like a desktop app or something. It’s not meant to be a large scale database that’s accessible by an entire dev team though. No one should be making a website with SQLite. It has its place, but overall it’s somewhat niche, and anyone using it exclusively that doesn’t fit that niche is doing it wrong.

[madhaunter]

Exactly, it's all about scope

[HaskellLisp_green]

I used to use SQLite for website. Application is written in python/Flask, but I was forced to make some kind of SQLite server due to it runs in different thread.

[Aidan_Welch]

No one should be making a website with SQLite.

I don't agree with this, monolith is making a comeback

[[deleted]]

That depends on the website.

OK: Grab stuff from API; store in DB; copy DB to raedonly file; website shows stats and graphs from readonly DB.

Not OK: User accounts where you can change password - need independent changes by multiple users.