grist-core VS Trilium Notes

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.

Tried Obsidian for a while, loved a lot about it, but....mmm.

Obsidian out of the box is a bit limited; plugins are great and add tons of features, but then you start hitting issues with plugin maintainers abandoning plugins you rely on, or needing to make a decision between three different plugins that all do the same thing slightly different. Depending on your use case and expectations that may not be a big deal, but I really missed not having what I personally saw as core features not being officially supported.

(Also, FWIW, the sync service is a bit pricy for what it is. I get that it's how they're trying to monetise it, but...I would have preferred another pricing model, even if the total cost was just as high.)

I've personally switched to Trilium Notes which I'm finding nicer. One element I particularly like is that it has first class suport for notes being able to exist at multiple places in a tree simultaneously. I know it's a very personal thing, but for me personally being able to file notes in multiple locations "clicks" in a way that tags didn't.

Trilium Notes: https://github.com/zadam/trilium

A nice writeup on ways to use Trilium (although much of it applies to Obsidian too): https://github.com/zadam/trilium/wiki/Patterns-of-personal-k...

Then you come across Trilium and drop the mic

[0] https://github.com/zadam/trilium

I move between machines a lot and prefer an online tool; I'm self-hosting Trilium Notes https://github.com/zadam/trilium ; this looks a bit cleaner but without syncing (or server-side storage) it misses a bunch of potential use cases.

Try outline or trillium