How To Build a JavaScript SQLite Web Dashboard

Spread the love

How To Build a JavaScript SQLite Web Dashboard

So, static pages web servers cannot have a database, can they? Thanks to Alon Zakai, it’s now possible to emulate a server-side SQL database with JavaScript.

YES you do not dream. It may not be the only one development on the subject, but he’s the only one who successfully developed a working solution along with a ready to use demo. SQLite compilation by JavaScript relies on WebAssembly.

WebAssembly is a portable, size- and load-time-efficient format suitable for compilation to the web.

For a small project like this one, you still need an awful LOT of tools, though. I didn’t realize it until I started to write this blog. These 3 days spent on research, testing, implementing and coding passed in the blink of an eye. The writing of these HowTo pages on the other hand, took me 2 weeks!

This solution lies in 2 parts: the scraping and database building part, and the web dashboard part.