[connectsnk]

I understand the criticisms, but in my experience, MongoDB has come a long way. Many of the earlier issues people mention have been addressed. Features like sharding, built-in replication, and flexible schemas have made scaling large datasets much smoother for me. It’s not perfect, but it’s a solid choice.

[beoberha]

I think the amount of people working on large enterprise systems here is a lot smaller than one would think.

Whenever a fly.io post about sqlite ends up in here, there are a scary amount of comments about using sqlite in way more scenarios than it should be.

[connectsnk]

True. I have that feeling many times that the enterprise crowd doesnt visits hacker news.

[dkjaudyeqooe]

Why would they be here? They use Oracle.

But mainly because management hasn't worked out how to cancel their licenses without breaking their budgets.

[dkjaudyeqooe]

"Should be" how?

SQLite is a lean and clean tool, it's very much a candidate for being inserted into all manner of contexts.

What beggars belief is the overly complicated, inefficient, rats nests of trendy software that developers actually string together to get things done, totally unaware of how they are implemented or meant to work.

By comparison using SQLite outside of its "blessed (by who?) use cases" is very practical.

[koakuma-chan]

Why would I use anything other than sqlite?

[margalabargala]

Easy. Sometimes it's more than you need, and there's no reason to use sqlite when you can just write things to a flat text file that you can `grep` against.

[dkjaudyeqooe]

Is this text file static? If not, does all grepping stop when you're updating the file?

[koakuma-chan]

Damn good point! didn't think about that!

[winrid]

Query engine is not as good.

[codr7]

It's still an unstructured blob of JSON, systems built with it are a major pita to maintain.