A while ago I made a syncer that used sqlite and from that I wouldn't suggest a relational database, SQL seems like it would be almost perfect for storing tiddlers but I immediately ran into problems with the database schema because aside from text, title, tags, created, type and modified you have on way of knowing what fields are going to be used so everything else just gets thrown into an otherfields column and you lose the desirable features of a relational database.
I found pouchdb to work much better because you can have arbitrary structures in the documents and implement the tiddlywiki filters pretty exactly in calls to allDocs and as a document store it can store single file wikis without any trouble at all. I have been considering skipping pouchdb and just using leveldb directly on the back-end but I don't know if the performance improvements are worth the extra hassle. Also in pouchdb you just make a new database for each wiki and never run into problems of scale except in the most extreme cases. I have had pouchdb databases that were close to a gig without any real performance hit, I think that wikis anywhere near that size are going to be rare. I have looked into other nosql databases and none of them look like they would be any better than pouchdb or using leveldb with some basic namespaced storage setup. also in my experience database maintenance is much easier in pouchdb and leveldb than in MySQL/MariaDB. You don't have the same problems of having database files taking up 100gigs when you only have 4 gigs of data that changes often. I am sure that problem can be solved by having an experienced database maintenance person, but I think that with one of the nosql databases you could skip that completely. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/c17d001b-1967-421b-abb4-743869a44bfc%40googlegroups.com.
