Hi, > On 01 Oct 2015, at 20:22, Gino Pacitti <[email protected]> wrote: > > Has anyone any thoughts on NoSQL and WO integrations and usage?
as well chiming in as "depends on what you are thinking of" :-) With the recent better support of JSON / JSONB in Postgres 9.4 we decided that this gives a nice middle-ground between relational databases and "Document-style" storage. In our case we created a JSONB prototype which maps between java.lang.String and jsonb columns (still very postgresql-specialized, needs to be cleaned up before it can be integrated in wonder). On the WO-side we then use the boon-library to parse between java.lang.String and actual NSDictionary/NSArray instances. As we're handling mostly small documents this works out quite fast and the workflow can be smoothed further by modifying the wonder templates. This effectively allows us to properly store NSDictionaries as entity properties and work with them even outside the WO context (as the serialized ERXMutableDictionary strings are hard to handle/debug otherwise; also they are not very space-efficient for small dictionaries). We haven't investigated advanced queries yet as that would probably require some more advanced SQL generation magic, but if your WO application mainly needs to handle schema-less documents attached to entities (and possibly doing some deeper querying outside of EO), this is a quick-and-easy way to enable this for your application. Greetings Dennis -- ----------------------------------------------------- Dennis Bliefernicht • Backend Development T +49 40 357 3001 62 [email protected] XYRALITY GmbH • Friedensallee 290 • 22763 Hamburg www.xyrality.com <http://www.xyrality.com/> Registergericht: Hamburg HRB 115332 Geschäftsführer: Sven Ossenbrüggen -----------------------------------------------------
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
