I do so often too, especially in data-heavy wikis. The TW5-SQL_Playground certainly is designed this way. In an important way, that is the whole point of it. If you open Order/110, you will see that the entire tiddler looks like this:
title: Order/110
tags: Order
caption: Order/110
type: text/vnd.tiddlywiki
id: 110
order-date: 20231119120000000
customer-id: 46
order-number: 542487
total-amount: 1360.00
order-number is left over from the original import from a separate source; at some point I will probably either remove these, or replace the other ids in this tiddler with these original numbers. And there is some significant denormalization here, some for efficient filters, some just left-over from experiments. Regardless, this tiddler consists of plain data, nothing more.
If you look at the other tiddlers related to this one they are all the same: simple lists of data. (Well, except for Venezuela which is a virtual tiddler.)
So yes, I could clearly export my data; in fact, I generated it externally from the SQL scripts for a sample database; I could convert it into whatever formats I wanted for Obsidian and the like.
But that is not the same as exporting my wiki. Raw lists of data do not display things like this:
If you want to explain that we could easily do something similar with raw data in Obsidian, well, … I’d have to see it to believe it. I don’t think their underlying models are flexible enough to support this. I would love to be proven wrong.
Note the context. I’m not looking for this. It would be great if the ability existed, if I could take my TiddlyWiki, run it through some automated conversion process, and have an equivalent version running on a different platform. And then later, if I changed my mind, I could take my updated version from that platform, run it through a reversed conversion and be back on TiddlyWiki, with my recent changes included. But I’m not looking for it, because I don’t think there are any platforms out there remotely near the power and flexibility of TiddlyWiki.
What @tomzheng is concerned about, I would guess, is the notion of vendor lock-in. If you have information in TwiXXer and want to port it to Mastodon, Facebook, or BlueSky, it’s extremely difficult or impossible. Those platforms are similar to one another in various ways, but TwiXXer and Facebook really don’t want it to be easy for you to move. The concern is that TiddlyWiki similarly locks you in.
He’s right that it does, but for an entirely different reason. There’s not some large corporation trying to hoard your data. But there’s no competing platform that you could move to with any sophisticated TW instance. The only solution I know to @tomzheng ‘s dilemma would be to create an interoperable format for only a very small subset of TW’s features. I’m not interested in that, myself.
