Re:Monty, Stallman, MySQL, Oracle, and Sun: Open Letter Wars
by bayareaguy on Thursday October 22, 2009 @10:09AM
(#896741)
That's a good idea. This could even be the start of a viable product catagory.
While in many cases it's trivial, I think it would also make sense for NoSQL's to add some kind of way to support common INSERT or COPY FROM .csv file commands. That would make it easy for organizations with existing SQL databases to see if a NoSQL could better solve some of their needs.
Re:Monty, Stallman, MySQL, Oracle, and Sun: Open Letter Wars
by astine on Thursday October 22, 2009 @10:16AM
(#896761)
RDBMs have an edge with many kinds of data. I'm an HSM reporting engine which aggregates logs and filesystem info into a Postgres instance. Because the DB is 'aware' of the structure and relationships of the data, I can add many implicit checks and behaviors that would have to be hand-coded in a hash-key store.
Without interchangeable data you need a unified API, and I am not sure they're willing to collaborate on that.
RDBMSes win because of ANSI SQL, ODBC and ORMs. If it wasn't for backend independent code bases the RDBMSes would have no leg to stand on.