Discussion
Loading...

Post

Log in
  • About
  • Code of conduct
  • Privacy
  • Users
  • Instances
  • About Bonfire
Ivan Enderlin 馃
Ivan Enderlin 馃
@hywan@floss.social  路  activity timestamp 2 months ago

Hosting SQLite databases on Github Pages, https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/.

SQLite is compiled to Wasm. The database is statically hosted on a server. A custom layer extracts _ranges_ of this database so that it can be fetched via HTTP. It allows to run SQLite client-side with a static read-only database.
Bonus: it is extended to query the DOM with SQL, this time with read and write mode.

#SQLite #sql #http #static

Hosting SQLite databases on Github Pages - (or IPFS or any static file hoster) - phiresky's blog

I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a
  • Copy link
  • Flag this post
  • Block

bonfire.cafe

A space for Bonfire maintainers and contributors to communicate

bonfire.cafe: About 路 Code of conduct 路 Privacy 路 Users 路 Instances
Bonfire social 路 1.0.1-alpha.40 no JS en
Automatic federation enabled
Log in
  • Explore
  • About
  • Members
  • Code of Conduct