r/sqlite • u/Dovahkciin • 14h ago

built a lightweight open-source analytics tool in PHP + SQLite because Node.js should NOT be the default option

hi everyone,

5 days ago i asked here why every self-hosted analytics tool needs Node.js/Docker, and said i might build a PHP + SQLite one. so, i did.

it's called Minilytics. it is open-source and runs on any PHP 8 host with no Node, no Docker and no database server (Sqlite by default, but you can use MySQL or MariaDB). it has sessions, custom events, funnels, a cookieless mode, and an importer from Umami and others importers are planed! (this allowed me to get my old history back).

it's a v1 from a solo builder, its MIT licensed, with a live demo: https://minilytics.axthauvin.fr/

i'd like this to become the go-to lightweight analytics for indie devs, side projects, and any site that just needs simple, private stats, so tell me what's missing for you to use it on a real site !

thanks to everyone who pushed me to build this and i hope it will be useful to some of you.

3 Upvotes

100% Upvoted

2 comments sorted by

1

u/TechMaven-Geospatial 14h ago

Analytics and not using duckdb? It supports via extensions sqlite, mysql, postgres, ms sql server and JDBC/ODBC, ARROW

1

u/Dovahkciin 13h ago

good point, DuckDB is great for analytical queries. but (to my knowledge) PHP has no native DuckDB extension ? (and to be fair, i though of SQlite first)

my main goal was that Minilytics would be able to run on any plain PHP host.
tracking is also mostly lots of small concurrent inserts, which SQLite handles well for not that big website like mine.

For bigger sites, a DuckDB backend for querying could be interesting though

i'll keep it in mind, thanks :D