[sqlalchemy] Re: Creating a Dialect for Amazon SimpleDB

2009-06-04 Thread az
sorry to tune in late, but how different is AmazonDB from googleDB? googleDB seems like a plain non-relational DB like berkeleyDB/btrieve kind of thing. to map a relational and non-relational schemas in same way u need higher level of abstraction - sqlalchemy is only about sql. so i had an

[sqlalchemy] Re: Creating a Dialect for Amazon SimpleDB

2009-06-03 Thread Laurence Rowe
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

[sqlalchemy] Re: Creating a Dialect for Amazon SimpleDB

2009-06-03 Thread enj
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