Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-06 Thread Jake Anderson
Aaron Stone wrote: > On Tue, 2007-06-05 at 23:03 +1000, Jake Anderson wrote: > >>> Now that I've written all that, I am sure that should happen in the >>> database, in the replication code. It's just not likely to happen any >>> time soon :-\ >>> >>> Aaron >>> >>> >> You mean that it s

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-05 Thread Aaron Stone
On Tue, 2007-06-05 at 23:03 +1000, Jake Anderson wrote: > > Now that I've written all that, I am sure that should happen in the > > database, in the replication code. It's just not likely to happen any > > time soon :-\ > > > > Aaron > > > You mean that it should be taken care of by stored proce

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-05 Thread Aaron Stone
On Tue, Jun 5, 2007, Marc Dirix <[EMAIL PROTECTED]> said: >> >> If we take control of replication, it means that we have to add a >> lot of >> meta-information to the database about where the data is being stored >> and knowing how to re-duplicate that information when one of its >> stores >>

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-05 Thread Marc Dirix
If we take control of replication, it means that we have to add a lot of meta-information to the database about where the data is being stored and knowing how to re-duplicate that information when one of its stores goes down (for example, ensure that each message is duplicated on at least 3

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-05 Thread Jake Anderson
> Now that I've written all that, I am sure that should happen in the > database, in the replication code. It's just not likely to happen any > time soon :-\ > > Aaron > You mean that it should be taken care of by stored procedures and the like? That sounds really quite hard ;-> I'd do it this

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-04 Thread Aaron Stone
On Tue, 2007-06-05 at 00:21 +1000, Jake Anderson wrote: > Aaron Stone wrote: > > This is looking really good! > > > > Rather than pushing the next_uid generator down into the database, > > however, I'd like to see it happen in a function up at the application > > level. This way we can easily hook

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-04 Thread Jake Anderson
Aaron Stone wrote: > This is looking really good! > > Rather than pushing the next_uid generator down into the database, > however, I'd like to see it happen in a function up at the application > level. This way we can easily hook up some cluster coordination code. > For your first pass, the functi

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-04 Thread Aaron Stone
This is looking really good! Rather than pushing the next_uid generator down into the database, however, I'd like to see it happen in a function up at the application level. This way we can easily hook up some cluster coordination code. For your first pass, the function would just do the same thin

Re: [Dbmail-dev] [partial patch] per-box uid

2007-06-03 Thread Paul J Stevens
Looks very interesting James. Keep us posted. Getting rid of the global message uid sequence gets my vote. James Cloos wrote: > This is where I am at in converting to per-mailbox uid values for imap. > > I still need to port the trigger to sqlite and write some equivilent > code for mysql (I p

[Dbmail-dev] [partial patch] per-box uid

2007-06-03 Thread James Cloos
This is where I am at in converting to per-mailbox uid values for imap. I still need to port the trigger to sqlite and write some equivilent code for mysql (I presume compatability with versions of mysql which do not support stored procedures is required?), write a transition schema for each, and