actual VS grist-core

There is some experimental work being done with SimpleFIN integration[1] for US banks but I can't comment on how well that works.

Personally, I add each transaction manually. It allows me to stay on top my budget.

[1] https://github.com/actualbudget/actual/issues/2272

If you know how to self host, or have someone to teach you, you should check out Actual, https://actualbudget.org

Please upvote the feature request: https://github.com/actualbudget/actual/issues/2042

ActualBudget

But several months ago I went back to check out Actual budget which was a sort of YNAB-clone whose author decided to release as open source. If you are comfortable with a bit of command line work, you can install it easily enough running as a hosted service in the free tier of a provider. I'm running in fly.io (docs for that are here). It was a bit fiddly trying to get set up for the first time, but the docs are detailed, and since I got it working it's been flawless and easy.

The repo is pretty active too, wonder if there’s a follow up blog post about the transition. https://github.com/actualbudget/actual

and poke around. If the words battery correct horse staple mean something to you, you might have an advantage.

The heart of the software you'll be working with: https://github.com/gristlabs/grist-core/

Because the single-system paradigm doesn't work any more. However, modern replacements do exist, Airtable is one of the first; it's basically the notion of a "spreadsheet with more structure", and then building forms and such on top of that. I've recently been playing with Grist and like it, although it is rough around the edges.

https://www.getgrist.com

i want exactly the opposite - something that does not try to be a spreadsheet, but gives me a grid view of a database table, with concurrent edits a la google sheets, and lets me access the same data from my webapp backend.

i have been searching for this for literally years, all the time maintaining an app as a google sheets script, because much as i would prefer something self-hosted and customisable, that collaborative grid view is the ideal user interface from my users' point of view. so far nothing has fit the bill - basetool (https://github.com/basetool-io/basetool) might have but it's discontinued and underdocumented, and i'm not really a web developer so i don't feel up to the challenge of getting it running and integrated into an app.

grist actually came really close from a ui perspective, but it was too focused on being a spreadsheet and doing computation in the frontend. i filed an issue that explains my use case in more detail: https://github.com/gristlabs/grist-core/issues/422

Founder of Grist here (https://www.getgrist.com/):

- focus on small teams and individuals

- open source (with community contributing!)

- can be run self-managed

- portable data (lossless export in SQLite format)

- full of great features (granular access rules, formulas with python, conditional formatting, webhooks, etc etc)

If it's little-known, it's because we spend too much time building, not enough time selling.

The exact LLM used in the experiment mentioned in this post was upstage-llama-2-70b-instruct-v2.ggmlv3.q2_K. Grist was configured to use it via llama-cpp-python and https://github.com/gristlabs/grist-core#ai-formula-assistant...

https://github.com/gristlabs/grist-core/

Check out Grist in the ‘Access with sane backend’ space. SQLite, open source and fantastic UX https://www.getgrist.com/ and https://github.com/gristlabs/grist-core

I use and love both Datasette and Grist - they’re complementary.