Support for sqlite backend

[luaneko]

Hi! Thanks for making this great analytics app.

It would be great to see an SQLite database backend in addition to MySQL and PostgreSQL. SQLite is suitable for light workloads or when installing a database server isn't necessarily feasible.

From what I've observed, umami uses Prisma 2 for database connection which natively supports SQLite already. It would be a matter of simply adding a Prisma schema for it, modifying a few raw queries and distributing another Docker image.

[mikecao]

Yes, it would be possible, just not a high priority right now. I would welcome a PR from anyone who wants to tackle it.

[Maxime-J]

I have a working implementation, with appropriate date/time handling, following the same logic and structure as currently.
A matter of days before a PR :)

[leirock]

I notice that @philippdormann's modded version of umami supports a local SQLite database. But seems no PR was created?

[philippdormann]

hi @leirock
yes, it does support SQLite and worked last time I checked.

I stopped working on this due to time constraints and the (for my use case too high to justify) memory usage of umami.
afaik there were some major changes in v1.17.0 in terms of Prisma/ Next.js version bumps. Those dependency bumps might require some changes for sqlite to work 🤷‍♂️

see #680 (comment) for the PR 😉

note: I might get around to a proper PR for sqlite support with the current version. recently got some more time :)

[leirock]

hi @philippdormann
Thanks very much for your reply. It's good news to hear that you got some more time recently. Cheers! 😂

[Maxime-J]

Hello!
I'd like to work on that if wanted.
Find it weird to have a working sqlite support without touching lib/queries.js

[calumk]

I know this is revisited every now and again, but +1 for sqlite support.
Would be wonderful for self-hosting more easily.

[alphaleadership]

any update

[voidborn-one]

SQLite would be great for small scale self-hosted websites to minimize the footprints