We are currently evaluating DBMSs that can process offline replicas (like, replicas are allowed to stay offline for a long time). CouchDB would be a prime candidate, however there are many drawbacks to our usecase. We could add some of these functions to some kind of code wrapper around the database, but some of them are test plugs:
- No built-in DB-based encryption (can be added at the file level)
- No document security (can be modeled using multiple databases for each solution)
- There is no built-in editor role (can be performed programmatically)
- There are no simple queries, each search should be performed using map / reduce (very hard, or it adds a lot of development time on the side of the frame or for each solution).
Now the question is: did you know about any DBMS that would add one or more of these functions? Maybe there are some commercial solutions, perhaps wrappers around CouchDB?
source share