What database are you running Wakapi with?

[muety]

Wakapi supports various different database systems and I'd like to get an idea about what database people are actually using for their self-hosted instances.

This may give an indication about which of them are actually worth the effort of maintaining the support for. Even though we're using an ORM that abstracts from most of the implementation-specific stuff, we still have quite a bit of corner case code for different DBMS. For example, SQL Server is always being a bit of a special snowflake and requires some extra treatment.

[taksh108]

Been using SQLite for convenience and also because I have shell scripts to run on it - I'll often clone the db file to my machine to run calculations of my own, which aren't available on the dashboard.
I have considered making a PR for my requirements, but the contribution guideline mentions no AI code, and I'm not confident enough in Go without it.

[muety]

Feel free to elaborate on the additional functionality you implemented via external scripts. If it's something that we consider to be useful for the majority of users, I might go about implementing it in Wakapi (or we could collaborate to implement it jointly).

[taksh108]

Less of additional functionality—more of "I don't trust it to get the project right"—because Wakatime doesn't, at least for me, because I'm switching between stuff a lot. It's a use case that may be a niche for me; not everyone may be juggling 5 projects at once. But I do. So I have a shell script that goes through the heartbeats table and runs a calculation of minutes spent per day on a project.
If I had the functionality that was talked about in the other discussion—to remap projects based on URL structure and folder name locally and similar wildcards or something like that—I wouldn't need this. I respect your decision to keep it simple, but if you’re open to it, I think easy remaps would be a great addition.
Instead of relying on the dashboard, I just run analytics from the database directly. Only using Wakapi to feed data to database for now.

[muety]

I created a new issue for this, see #823. Don't expect it to be implemented very soon, though - sorry!