-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/30/2011 12:24 PM, Max Vlasov wrote: > so CouchDB will be a server solution
My (year old) experience with CouchDB has been that it is a poor database, especially in what they consider "large" amounts of data. I was working with a dataset of 10 million documents that was originally in Postgres and then played with using SQLite (denormalizing) to turn into 2GB of JSON. CouchDB required 22GB of disk space (pre-compaction) and took just over an hour to import. A different JSON database server product used 4GB and 6 minutes and I never bothered optimising for it. Perhaps more shocking is that the other product would usually answer unindexed queries faster than CouchDB did with indices, mostly helped by this database fitting entirely in memory. But there is one thing that CouchDB does very well and that is multi-master replication (disk space consumption issues aside). Unlike most other databases where there is an instance in charge that all write operations must work against, CouchDB lets you write to any instance and those changes will be correctly bidirectionally replicated to others. (Behind the scenes it does something somewhat similar to what DVCS do.) This lets you have a convenient 'offline' mode locally since you don't need to talk to "the server" for operations, nor do you need an authoritative server. The builtin admin interface for CouchDB (Futon) is very nice too. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk40Y98ACgkQmOOfHg372QTviACfQtvYw+wW9KPaL9b6KT3TaSrI cO0An04Bfpp/an10BRzFQEYwGcQzistU =v6I+ -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
