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 -~----------~----~----~----~------~----~------~--~---
