On 12 Oct 2010, at 2:27 AM, Darren Duncan wrote:
Some people would say that "NoSQL" is a contrast with relational databases but I would say that in fact these things are orthogonal. You can in fact use the relational model of data over both an ACID database as over a "NoSQL" database, just as you can use a key-value store over both as well.
We (a large UK media organisation) use both SQL and NoSQL on our platform, and deploy each where it is most appropriate to do so.
We endure extremely high loads from time to time from thundering herds, and to do this on a realistic budget, the NoSQL options give us the performance required. To insulate ourselves from unstable nosql interfaces, we defined a very simple HTTP based restful API to our nosql database, giving us the option to swap out our nosql database at a future date should we need to.
For years, SQL has been sold as a magic hammer to solve all database problems, but as the size of the data exceeded the practical size of a machine, and as internet audiences grew faster than the capacity of individual servers, the need became apparent for more specific database types that performed a far simpler job, far faster.
Regards, Graham -- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
