Without Foreign Keys or joins, I don't see how putting all tables in the same domain buys you anything?
Laurence On Jun 4, 12:27 am, enj <enjah...@gmail.com> wrote: > The way Simpledb works you don't want to make each domain a table, you > want to put all related tables in one domain. This way you can do > relational queries on the set of objects. One thing that might help > conceptualize it would be to set a "table" attribute for each item > that contains what the table name would be called. That way you could > quickly get a resultset of all the objects that should be in that > table. One can do any kind of relational operation on the set of > objects in the domain, so sqlalchemy functionality can be mapped to > it. Since transactions aren't supported that functionality wont be > supported, but one can still make useful applications. > > Ian > > On Jun 3, 6:00 pm, Laurence Rowe <laurencer...@gmail.com> wrote: > > > It would be interesting to see if this could be made to work. The > > SimpleDB model is rather different from the relational model, so it > > would only be useful if your application does not use any advanced > > features - no joins etc, each 'domain' might map to one big (albeit > > sparse) table. > > > Laurence > > > On Jun 3, 8:38 pm, enj <enjah...@gmail.com> wrote: > > > > Hello all, > > > > I am new to sqlalchemy and was introduced to it by a project (cjklib) > > > that uses it. I want to migrate this project to Amazon SimpleDB and > > > since it makes extensive use of sqlalchemy I thought the best course > > > of action might be to make a SimpleDB dialect in sqlalchemy which > > > could possibly benefit other projects trying to move to AWS. > > > > The purpose of my post is to see if there is any such effort out there > > > or any other interest in this. Also I was wondering if there is any > > > good docs/tutorials on implementing a Dialect. > > > From my current understanding I plan to implement > > > engine.defaulthttp://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/lib/sqlalchem... > > > which will use the boto library to interface with > > > simpledbhttp://code.google.com/p/boto/ > > > > Any thoughts? > > > > -- > > > Ian Johnson --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---