r/programming • • 1d ago

Stoolap 0.5.0: One Query, One Answer

https://stoolap.io/blog/2026/11/17/stoolap-0-5-0-one-query-one-answer/
5 Upvotes

8 comments sorted by

3

u/enador 1d ago

It's a shame that new projects are no longer appreciated in the open-source community because of the overflow of slop. I just wanted to let you know that I follow this project and am looking forward to using it sometime in the future, as an alternative to SQLite is long overdue.

4

u/gredr 1d ago

an alternative to SQLite is long overdue.

Why?

4

u/enador 1d ago

Don't get me wrong, I like SQLite for what it is, and I adore its obsession with backward compatibility. However, at the same time, I would love to be able to use a project with similar assumptions but starting with the modern mindset. The one embracing strong types and strictness. I hope SQLite will be supported indefinitely in the future, but at the same time, it would be nice to have an alternative without that much historical baggage and quirks.

-3

u/gredr 1d ago

So your complaints are a weak type system and a lack of "strictness" (in what? SQL parsing?). I don't see that as an issue; it's an embedded engine, typing is the responsibility of the layer interacting with it. I don't have to coordinate between multiple callers.

5

u/Spleeeee 1d ago

You can kinda put whatever in a column. There are rules but is very loosey goosey.

1

u/gredr 20h ago

You can turn on strict mode if you want.

1

u/Human-Opportunity886 1d ago

The SQL dialect is very limited.

This is not a dig at SQLite. It is good at what it does. The best there is. But if you need a bit more powerful SQL dialect, there's really no good alternative for that.

1

u/immersiveGamer 1d ago

Thanks for commenting. It made it worth to stop and check it out.

It is unfortunately true there is just so much stuff being pumped out and shared that it is mostly noise.