News for hackers. Stuff that matters.

A comment on SQLite is all you need for durable workflows. Parent comment

Re:SQLite is all you need for durable workflows by chaps on Friday May 29, 2026 @03:40PM (#48328204)
The moment my JSON has any sort of depth and I need to write a parser for it and potentially account for unspecified behavior. JSON's nice when it's nice, but it's terrible when it's terrible. It's 100x easier to write SQL than writing jq and... dear god if I have to use grep -A or -B, I'm doing something wrong. Constraints are actually a good thing!

The underlying database isn't the most important thing. Just use SQL. Its namespacing (eg, through CTEs) is good and you're more likely to have colleagues who know SQL compared to jq.

[ Parent | on HN ]
Re:SQLite is all you need for durable workflows by sofixa on Saturday May 30, 2026 @03:28AM (#48333621)
> It's 100x easier to write SQL than writing jq and... dear god if I have to use grep -A or -B, I'm doing something wrong. Constraints are actually a good thing!

As an occasional consumer of JSON/CSV, that's why I really like DuckDB, it's just SQL for such file formats. And it manages to be super fast at it too.

[ Parent | on HN ]