Proven and powerful database
PostgreSQL is the most advanced open source object-relational database system. We choose it for its power, speed and maturity.
We store all our data in a SQL database. We had the choice between MySQL and PostgreSQL. We went with the latter, why? Important reason is that there is a great binary driver for PostgreSQL and only a text driver for MySQL. And we found PostgreSQL to be more complete and more robust.
As the performance of both databases is very similar it was an easy choice.
Why not CouchDB, Riak, or ... ?
In our opinion a SQL database is powerful and fast enough to handle the load of 99.9% of all websites.
And did we mention that triggers and cascading updates are very nice?
And that having uniqueness and foreign key constraints really helps keeping our data clean and tidy?
And that having SQL helped us write less code?
A NoSQL database will become interesting when we handle huge amounts of data. Till then the current crop of SQL databases will do the job just fine.
Maybe we will make a Riak version of Zotonic at some time, maybe, just maybe.
Comments
Brandon
Posted 1 year ago.
I certainly agree that Postgres is adequate for the majority of sites. However, it seems to me that people who are attracted to using Erlang for their CMS, and therefore likely to discover Zotonic, are much more likely to be in that group for whom Postgres may not be adequate. (Or they at least are trying to prepare for the possibility of finding themselves in that group!) That may be why you are getting that question so often... ;)
Marc Worrell
Posted 1 year ago.
We are working on Elastic Zotonic which will be distributed.
Jack
Posted 9 months, 17 days ago.
Can you elaborate a bit on your architecture for Elastic Zotonic?