Thank you very much Jonathan for your very intuitive analogy! Basically I just want to put "people", "journal" and "tag" tables(each will potentially be very large) into different DBs, if I write that logic, how can I integrate it with SQLAlchemy? Could you give me a rough idea here? Or point some reference. I suppose such feature is relatively commonly needed among SQLite users isn't it?
On Friday, August 14, 2015 at 3:48:40 PM UTC-7, Jonathan Vanasco wrote: > > > > On Friday, August 14, 2015 at 5:16:48 PM UTC-4, Jinghui Niu wrote: >> >> >> If I still want to use SQLite, and I still need to do vertical partition, >> what can I do? Am I out of luck? >> > > You can, but not with a two-phase commit. > > Two-phase commit basically works like this: > > - round 1, everyone locks-state and votes "COMMIT!" or "NOOOO!" > - round 2, if commit in round 1 was unanimous, it commits. otherwise > everyone is told to roll back. > > Since SQLlite doesn't support that, you'd need to write that logic in at > the application level. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.