kidgodzilla/implausible-vue

A toy analytics app in Vue 3, using sql.js-httpvfs

Servers.do Analytics (Vue 3)

A simple analytics implementation that collects and serves data from a static CDN, using web workers, WASM, range requests, and some other fun tricks.

This frontend for Servers.do Analytics is written in Vue 3.

This project makes use of sql.js-httpvfs and sqlite3 for the database.

A static sqlite database is updated on an interval, and is directly accessed by the Vue app, using sql.js-httpvfs. No backend server is required to query data, only to update it.

This allows you to do some interesting things, like set up a snowplow collector on a CDN, and run a batch job to update the sqlite3 database -- effectively and end-to-end serverless solution (depending on your ETL solution).

Because the entire database is available for the public to view, sensitive columns can be encrypted (optional) using the AES-SIV algorithm, to allow users with a private key to their own website to view the data, unencrypted.

A compact "seed" is used to generate the encryption and decryption key on the collection server, to allow stateless embedding of the collection script.

Demo

https://analytics.servers.do/?host=analytics.servers.do&range=30

Ready-to-use Distributable

The following repo contains a bundled version of the frontend and backend that is the simplest to set up and self-host:

https://github.com/kidGodzilla/sqlite-analytics

---

Notes to self

These may not be as useful to other people as the original author.

Todos

• Add dark mode
• Display "current visitors" in the last 1 hour
• Add deterministic encryption to the public database
• Clean data in visits table older than ~32 days
• Previous month view
• Custom date ranges
• Clickable charts
• 12-month view
• Composite indexes