toddclausen wrote:For example, a table in one of my databases takes up 80 MB as a dat file, export that to XML and it becomes 400 MB. Search time also goes up, sometimes more than proportionally to size. Most all of the markup languages are used with text stored in a container such as MySQL or SQLlite...
Wow, now that's what I call heavy duty! I'm not sure if it is the purpose of a simple notetaking app like CN to store such massive data structure, but to each his/her own, like I said before.
(I would rather have all that data in a proper spreadsheet, possibily linked to a note in CN, if it was my choice)
To me the advantages of keeping data in freely human readable text are quite evident: data resillience & longevity, escape from application lock-in, and so on. To illustrate this, let me say that in my library I have both some three centuries old documents still perfectly readable and some ten year old Quatro Pro datasets no one can decode (mind you, I'm not saying that it can't be done...).
But mostly I agree with you and CN Developer that SQLite is a good choice, for the performance and functionality it provides -- I just wish that, in a perfect world, it could be made optional, like it is in wikidPad 1.x... and like you yourself sugested regarding other functionalities in the "Feature Request" thread.