| sqlite supports replication via the "cp" command ;)
On Jul 12, 2006, at 6:31 PM, Jonathan Ellis wrote: On 7/12/06, Steve Zatz <[EMAIL PROTECTED]> wrote: > What is the difference between what you are trying to do and replication?
> Replication should really be handled at a lower level than SA. Most modern
> DBs have a replication solution available.
The data is in sqlite, which I don't believe has replication
capability, and the changes are relatively few so while I agree with
your general point, it has been possible to do this via SA. It just
seems like there should be a more efficient solution than what I am
currently doing.
I'll bet it would be pretty easy to port the trigger-based replication from postgresql 7.4 contrib/dbmirror. It's just perl and sql. (It's not shipped with 8.1 anymore, presumably because Slony is better. Not sure if it's in 8.0 or not.)
But, it sounds like doing it with SA is also be pretty easy, so you have good options either way. :)
--
Jonathan Ellis
http://spyced.blogspot.com
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo _______________________________________________ Sqlalchemy-users mailing list |
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
