All good, take as much time as you need on the IMAP flags stuff. We'll make
sure we do it right.
As you've undoubtedly noticed if you follow the commit logs, over the last
couple of weeks I've written "ctdldump" and "ctdlload" utilities that can
be used to dump a Citadel database into a flat file and then load it back
on another system. This can be the first step towards a transition period
between databases, of course, since we can build compatible dump/load utilities
for each database that share a common export format.
To make things easier: the export format is not intended to be backwards
compatible. As with its predecessor, we expect the dumping and loading systems
to be running the same version of Citadel Server.
Uncensored is still running on 32-bit i386. One of the first things I want
to do is use these utilities to finally get my own system onto 64-bit. I
tried
it a few months ago with ctdlmigrate and it did *not* go well. Aside from
taking many hours to run, the resulting system was unstable and had data
missing.
I guess all that conversion back and forth to XML on running servers just
wasn't a great idea, which is why ctdlmigrate is being discontinued.
Sqlite is pretty cool, and I'd be interested in hearing your schema idea.
I am somewhat turned off by the idea of having a schema layer and not really
using it. I wonder if it's possible to access Sqlite's B-Tree back end
directly?
