I might be overlooking something, but SimpleDB supports having multiple
attributes/columns with the same name, essentially allowing you to have
lists, however when both inserting and retrieving data it looks like
openBD is overwriting all existing attributes :S . Is there some
different type of syntax I should be using? Or is the SimpleDB
integration itself unfinished?
If it's unfinished, could I suggest the following changes:
* AmazonSimpledbSetStruct should accept a structure with array's
inside (where the array is split up in separate attributes)
* AmazonSimpledbGetAttributes would retrieve a structure with array's
as well if an attribute is encountered multiple times
* For the SQL INSERT statement there would be two options:
o "INSERT ADD INTO" or "INSERT NOREPLACE INTO" could be used to
specify that we actually want to do a update whilst adding
attributes, rather than replacing them
o We could loosen the sql and allow ["",""] array notation in sql
as per UnQL
<http://www.unqlspec.org/display/UnQL/Example+Queries+and+Usage>, which
would thus do the same as the previously described
AmazonSimpledbSetStruct function (Still not allow adding new
attributes with the same name to an existing item (although I
personally don't mind)).
Either way, although I still fervently hope this is already possible, I
am looking forward to your opinion@the above if it's not yet.
Greetings,
David Mulder
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
