Gemini (Google) has a good-enough-for-personal-projects free tier. Openrouter has free models (I'm assuming the training data is valuable enough to keep this going for a while)
There's a company (http://turso.tech) that can host sqlite as a service. One of the features allows a replica local sqlite file to be used for reads and the writes still go to the primary on their edge network.
Been using it (without the local feature) for a couple of months on a project and I will do it again for future products without a second thought.
Grist was one of the first tools we looked at but it wasn't the desktop-first app my team was hoping for. Self-hosting a service felt like a little too much upkeep, on top of all the other systems we own. I recall the data was also not git diff-able.
consider not storing running_balance (or at least expect it to be written to a LOT). Based on the above description that's going to be a hot table with a write/update of 1 per second per row (of active customers).
If you are thinking sql, that running balance could be calculated from a VERY tall and skinny table of time_spent per session (which would be calculated in the application) or an append only table of (billing_account_id, timestamp) where you write a new row every second.
I should have mentioned: thankfully, there are no long-running sessions in this design. The longest session I could imagine would be 1 hour, but... they will average 1 minute.
Designing such system for long-running sessions would be a lot more complex, esp if we consider that the price might not be constant during the entire duration of the session.
Nice suggestion! In the same spirit, Gartic Phone[1] is also a great team bonding game that needs no audio. It plays like a telephone game, but with drawings and (written) guessing. The way the initial message is transformed during all the drawing-guessing rounds is always hilarious.
Love TrackerControl from FDroid. You can fine tune access/block of each app based on classification of network destination (analytics, tracking, necessary, ..)
I use mermaid and flowchart in github readmes using an extension for chrome. The basic idea is that the libraries are part of the extension, and the markdown calls out what kind of diagram it is.
