CintaNotes Developer wrote:Midas wrote:Testing v1.0P2:
[...]
Hi Midas, glad to see you
Thanks for taking a look.
As for "Old database not automatically detected" - the detection code is not run if the .db file is already present (even empty). Your first run created it, so no wonder.
49% size increase - yeah that's killing me. Full text search is expensive. I'm thinking about switching from UTF-16 to UTF-8 in the database. The database size will shrink significantly. But for East Asia languages, the DB size will grow.
The other option would be to use some kind of compression, but it is complicated.
Hi Alex, glad to be around as CintaNotes turns 1.0.
I got that about the database detection, but shot that remark from the top of my head -- kind of a subliminal feature request...
My guess is that for most of us UTF-8 will be OK -- maybe keep a UTF-16 version for East Asian Users? On compression, with SQlite departing from the human readable database format, it won't be too radical a step.
For an alternative approach, may I quote again the case of wikidPad, where a choice is given to use individual text files for notes (called Gadfly), a SQlite index for the same notes or keep the notes and index in the SQlite database, all options having their individual pros and cons.
All in all, thanks yet again for this excellent info gathering tool.