It's not an excuse not to have a schema. Document based storage starts becoming useful when the sort of queries you want to make are less structured; if you want to be able to account for extensible, searchable metadata, it's probably better to use something like mongo which is designed for it, rather than shoehorning it into a key-value table in your RDBMS.
mark On Wed, Jan 27, 2010 at 12:20 PM, Cameron Barrie <[email protected]> wrote: > Yup. > I'd love to hear from people about there thoughts on all forms of persistent > storage. > I've always had the thought that Document based storage lacked the integrity > of a RDBMS mainly with foreign keys etc(yes I do use foreign key constraints > in my rails projects). > However I think I'm just uninformed. > > Please please inform me, because I'm very interested in this whole topic. > > Cam > > > On 27/01/2010, at 12:15 PM, Jonathan Clarke wrote: > >> Anyone want to branch this conversation out to Couch / Mongo DB? >> >> Jonathan >> >> 2010/1/27 David Lee <[email protected]>: >>> My take: When you're choosing a database, do you want one that was built >>> carefully and has been stable and consistent since its inception, or do you >>> want one where not silently hosing all your data is a recent feature? And as >>> Lachie said, even subselects are recent in MySQL. >>> >>> This is hardly an objective analysis, but PostgreSQL reminds me of BSD; >>> MySQL reminds me of PHP ... >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Ruby or Rails Oceania" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/rails-oceania?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby or Rails Oceania" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/rails-oceania?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rails-oceania?hl=en. > > -- A UNIX signature isn't a return address, it's the ASCII equivalent of a black velvet clown painting. It's a rectangle of carets surrounding a quote from a literary giant of weeniedom like Heinlein or Dr. Who. -- Chris Maeda -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en.
