News for hackers. Stuff that matters.

A comment on SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML.

Re:SQLite-HTML: A SQLite extension for querying, manipulatin... by alexgarcia-xyz on Wednesday August 03, 2022 @04:47PM (#32336490)
Hey, author here, happy to answer questions! A few other recent posts/tools that you may be interested in:

- sqlite-lines discussion from a few days ago: https://news.ycombinator.com/item?id=32288165

- htmlq, Rust CLI for (like jq but for html): https://github.com/mgdm/htmlq

- The Go library that sqlite-html uses for making runtime-loadable SQLite extensions https://github.com/riyaz-ali/sqlite

- sqlean, a ton of other helpful SQLite extensions (in C): https://github.com/nalgeon/sqlean

[ Parent | on HN ]
Re:SQLite-HTML: A SQLite extension for querying, manipulatin... by tbran on Thursday August 04, 2022 @07:57AM (#32341724)
Not an extension, but I wanted to add that sqlite-utils is an incredible Python library for working with SQLite dbs. Great for squashing several lines of SQL into a one-liner.

https://sqlite-utils.datasette.io/en/stable/index.html

[ Parent | on HN ]
Re:SQLite-HTML: A SQLite extension for querying, manipulatin... by lilyball on Wednesday August 03, 2022 @05:09PM (#32336680)
The bottom of the README links to a sqlite-http repo but that's just a 404. Is that a private repo?
[ Parent | on HN ]
Re:SQLite-HTML: A SQLite extension for querying, manipulatin... by alexgarcia-xyz on Wednesday August 03, 2022 @05:11PM (#32336702)
Ah yes, my bad, gonna publish that soon! Will be an extension for things like `select http_get_body('https://google.com')`
[ Parent | on HN ]
Re:SQLite-HTML: A SQLite extension for querying, manipulatin... by dreadlordbone on Wednesday August 03, 2022 @08:02PM (#32337858)
Maybe I'm being dumb, but what's the upside to generating/modifying HTML in SQL as compared to javascript?
[ Parent | on HN ]
Re:SQLite-HTML: A SQLite extension for querying, manipulatin... by alexgarcia-xyz on Wednesday August 03, 2022 @08:39PM (#32338074)
totally not dumb - in general there isn't much upside. Maybe there's a usecase in server-side rendering HTML where you already use SQLite somewhere, or in a CLI tool if you're using sqlite3. But I doubt sqlite-html will be as fast as other tools. The querying functions are much more useful than the generating ones, IMO
[ Parent | on HN ]