I don't have any real experience using NoteSelf but I do know a bit about databases. You can have variable length columns in MySQL, each column has a type which determines the allowed content and some types have limits on the size but text columns can have variable lengths.
SQL is optimised around having a known number of columns with a known type in each column which isn't a good match for tiddlywiki because tiddlers can have any number of custom fields they would all be stored as a single text blob anyway. But it should be possible to host your own CouchDB server on a raspberry pi or whatever hardware you have available so I don't think that there is a reason to use MySQL, if I understand correctly you could set up a CouchDB server on your local network and it would sync with remote changes or you could just use it on your local network. I know very little about docker and the few times I tried to use it I gave up and just installed everything manually. I am often wrong about the relative levels of expertise needed for things like this but I think that if you are comfortable setting up a raspberry pi setting up the CouchDB server shouldn't be much of a stretch, there are instructions here https://andyfelong.com/2017/09/couchdb-2-1-on-raspberry-pi-raspbian-stretch/ -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/54a0dfe5-184e-4aab-b8bd-b75e60b96952%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
