[karencarits]

I have tried quite many such apps and keep returning to Tiddlywiki (https://tiddlywiki.com/). It is not perfect, and the lack of hierarchy can be both a blessing and a curse. It uses flat-files which can impact performance and be more cumbersome than a database. Also, the integration with external files is a bit clumsy.

However, the main strength is customizability. Various data is best presented in various ways, and separating data/content and presentation/template/layout while keeping them tightly integrated is incredibly powerful.

Cudos for thinking long-term with SQLite, avoiding lock-in is crucial for these kinds of apps!

[diego_moita]

Tiddlywiki[1] + Syncthing[2] + Wireguard[3] = "Cloud? Why?"

[1] https://tiddlywiki.com/

[2] https://syncthing.net/

[3] https://www.wireguard.com/

[enbugger]

How is it different to Obsidian?

[karencarits]

* Tiddlywiki has existed for many years (first version came 20 years ago, the rewritten version left beta 10 years ago), and longevity and backward compatibility are key values for the developers

* A single-file Tiddlywiki is a single file that only requires a web browser to be used (e.g., you can email it to someone and they can just open it)

* Tiddlywiki is extremely customizable, much more than obsidian. It's almost hard to describe, but you can make very interesting things with just basic knowledge about html and css.

To cite myself:

> the problem with TiddlyWiki is that it's hard to describe since its so flexible. I have a few local tiddlywikis that I use for catalogues and note taking/knowledge base. The note taking was inspired by another HN comment [3] that introduced Drift [4,5], which includes features such as tabs for backlinks, keywords, and freelinks. But you may also find the Projectify edition [6] interesting or one cloning Roam Research [7].

[3] https://news.ycombinator.com/item?id=25305527

[4] Source: https://github.com/bmann/drift-tiddlywiki-template/tree/mast...

[5] Demo: https://ramirosalas.com/

[6] https://thaddeusjiang.github.io/Projectify/

[7] https://rr-tw5.github.io/

[jodrellblank]

Joe Armstrong of Erlang fame was a big fan of tiddlywiki, and he met up with the creator to give a talk together about tiddlywiki: https://youtube.com/watch?v=Uv1UfLPK7_Q

“Joe Armstrong & Jeremy Ruston - Intertwingling the Tiddlywiki with Erlang | Code Mesh LDN 18”

[dalmo3]

The tiddlywiki site is a tiddlywiki document. That alone tells you the difference.

[scubbo]

That one is optimized to be a web site and the other is optimized to be a personal note-taking platform? ;P

[kvark]

A markdown document (e.g. from Obsidian) can be hosted as easily.

[karencarits]

Yes, but the tiddlywiki file is the entire wiki. You've perhaps tried the dataview plugin for obsidian? Tiddlywiki is built on a similar idea, but much more flexible and powerful. However, tiddlywiki doesn't support in-text definition of fields (as far as I know)

[Groxx]

It's a single-file self-hosting wiki.

Rather different from a closed-source desktop file editor.