Firefly III VS Fava

Not SQL, but check out the contents of the database folder. For example:

https://github.com/firefly-iii/firefly-iii/blob/main/databas...

- https://github.com/firefly-iii/firefly-iii/

Has anyone tried https://github.com/firefly-iii/firefly-iii? It seems to be under active development but it always makes me nervous when the vast majority of updates come from one person. (What happens to the project when that person isn’t working on it anymore?)

Any HN users out there with experience with Firefly III (https://github.com/firefly-iii/firefly-iii)? Sounds interesting.

Why don't you just contribute to https://github.com/firefly-iii/firefly-iii

Firefly III - self-hosted budget website

I’ve been using beancount for almost 1.5 years now, and other than having to explicitly open accounts I love it! I use the fava UI to have all the nice modern visuals: https://beancount.github.io/fava/

I used Beancount + Fava for a web UI for years. It stores everything in plaintext files, but the downside is you either have to manually enter everything or probably write a script to import csv/qfx from your bank(s).

I suggest you take a look at fava. I don't think its data entry is good for you but the data visualization is pretty great.

And the following are interfaces of Beancount: Fava, a well-known UI

If you’re tech savvy, you could try beancount + fava web interface. https://beancount.github.io/fava/

I use Beancount myself (heavily supported by custom scripts). Plain text accounting options are not very user-friendly out of the box in my opinion. Beancount has a self-hosted web app called Fava that's good if you want a GUI. I believe there is something similar for ledger.