sqlite | justin.vc

Embedded SQL in Hugo with sqlime

Another short(-ish) post. I found a neat tutorial/example page at: https://sqlime.org/examples.html. It shows an embedded sqlite database, using web assembly and javascript to run interactive SQL examples without needing to hit a third-party hosted script (assuming you’re hosting it yourself). Note The SQL may give an error if it hasn’t loaded all the way - try refreshing in that case. This lets you do something like: SELECT rank() over w as "...