[eduction]

HN… for the love of god… please please stop trying to make SQLite be something it isn’t. Leave this poor project alone.

It’s a great tool if you want to give a local app its own database. If you need concurrent writes and full ACID guarantees of an industrial strength database, use an industrial strength database.

Yes, other databases will require you to read more manual pages and configure a service. Higher up front cost. Not “lightweight.” But given enough operating time there is a certain unarguable lightness to using the right tool for the job.

[yomismoaqui]

Just by its testing and its number of installations (real world testing) you could consider SQLite being more "industrial strength" than any other DB on the market.

- https://sqlite.org/testing.html

- https://sqlite.org/mostdeployed.html

EDIT: added links

[eduction]

Exactly. There is no reason to complain about it. It is successful. People who find it lacking can use something else, there are many options.

[Cyberdog]

I don’t understand why a local app database shouldn’t still have the same basic functionality and data guarantees as the full-sized ones.

[LtWorf]

You can just run postgresql locally like akonadi does if that's what you need

[mort96]

Like you want me to ship postgres with my app? I mean sure I could, but that seems very over complicated when sqlite works just fine except for some unfortunate defaults

[LtWorf]

Make up your mind :D

[mort96]

I have: SQLite is great, it does everything I need, it would've been even better if it had better defaults or this edition system. In lieu of that, I will just keep setting these 4 pragmas and add strict to my tables.