4 ms·
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
by alexgarcia-xyz 4y ago
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 https://news.ycombinator.com/item?id=32288165
- htmlq, Rust CLI for (like jq but for html): https://github.com/mgdm/htmlq https://github.com/mgdm/htmlq
- The Go library that sqlite-html uses for making runtime-loadable SQLite extensions https://github.com/riyaz-ali/sqlite https://github.com/riyaz-ali/sqlite
- sqlean, a ton of other helpful SQLite extensions (in C): https://github.com/nalgeon/sqlean https://github.com/nalgeon/sqlean
- tbran 4y agoNot 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 https://sqlite-utils.datasette.io/en/stable/index.html
- lilyball 4y agoThe bottom of the README links to a sqlite-http repo but that's just a 404. Is that a private repo?
- alexgarcia-xyz 4y agoAh yes, my bad, gonna publish that soon! Will be an extension for things like `select http_get_body('https://google.com https://google.com')`
- dreadlordbone 4y agoMaybe I'm being dumb, but what's the upside to generating/modifying HTML in SQL as compared to javascript?
- alexgarcia-xyz 4y agototally 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