2012-09-23 17:00:03.023116+02 by Dan Lyke 3 comments
Sauce Labs: Goodbye CouchDB. Turns out using not-a-database for your database causes problems.
I think there's even a deeper issue here: If you think that not having a schema and structure to your data is a good idea, you probably don't really understand how to structure your data.
[ related topics: Interactive Drama Databases ]
comments in ascending chronological order (reverse):
#Comment Re: made: 2012-09-24 01:29:09.526147+02 by: meuon
Nice article, realistic assessment/use of MySQL.
#Comment Re: made: 2012-09-25 05:07:48.90235+02 by: ebwolf
I've been dealing with not-a-database concepts in OpenStreetMap. Ostensibly, OSM uses PostgreSQL on the backend. But the meat of the data is tied up in arbitrary key- value pairs. The result is my code has to deal with two levels of impedance mismatch. Python does a good job of softening the blow of the set-orientation mismatch. But I'm stuck doing a lot of searching in code that I would have expressed in SQL if the key-value pairs were actual fields.
NoSQL appears to work well in environments where you want the crowd to rapidly construct data schemata. But once the schemata are firmed up, commit them to SQL! Ironically, OSM does this nightly when it exports the data to PostGIS in order to render tiles.
#Comment Re: made: 2012-09-25 17:01:23.051781+02 by: Dan Lyke
Yeah, arbitrary key-value pairs is a clear indication that someone doesn't really understand their data yet. There's a time and a place, but structure really can help...
We will not edit your comments. However, we may delete your comments, or cause them to be hidden behind another link, if we feel they detract from the conversation. Commercial plugs are fine, if they are relevant to the conversation, and if you don't try to pretend to be a consumer. Annoying endorsements will be deleted if you're lucky, if you're not a whole bunch of people smarter and more articulate than you will ridicule you, and we will leave such ridicule in place.
Flutterby™ is a trademark claimed by
Dan Lyke for the web publications at www.flutterby.com and www.flutterby.net.