Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

github.com

Post reply on HN
Print view View original

1–10 of 17 posts

Re: SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML

#3

Post by alexgarcia-xyz »

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

Re: SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML

#4

Post by lilyball »

alexgarcia-xyz wrote: post #3

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 othe…

The bottom of the README links to a sqlite-http repo but that's just a 404. Is that a private repo?

Re: SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML

#5

Post by alexgarcia-xyz »

lilyball wrote: post #4
alexgarcia-xyz wrote: post #3

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 othe…

The bottom of the README links to a sqlite-http repo but that's just a 404. Is that a private repo?

Ah yes, my bad, gonna publish that soon! Will be an extension for things like `select http_get_body('https://google.com')`

Re: SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML

#7

Post by dreadlordbone »

alexgarcia-xyz wrote: post #3

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 othe…

Maybe I'm being dumb, but what's the upside to generating/modifying HTML in SQL as compared to javascript?

Re: SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML

#9

Post by alexgarcia-xyz »

dreadlordbone wrote: post #7
alexgarcia-xyz wrote: post #3

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 othe…

Maybe I'm being dumb, but what's the upside to generating/modifying HTML in SQL as compared to javascript?

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
Post reply on HN