I really like FeatherWiki as a lighter alternative to TiddlyWiki, it has fewer features but all the important ones are there.

I also need to mention thât the fossil scm has an integrated wiki, stores everything in a sqlite database (it’s made by the same people) and is also very lightweight