We're currently evaluating DBMS that are able to handle offline replicas (as in, replicas are allowed to stay offline for long amounts of time). CouchDB would be a prime candidate, however there are lots of drawbacks for our usecase. Some of these features we could add ourselves in some code wrapper around the DB, however some are show stoppers:
- No built-in DB-wide encryption (could be added on file level)
- No per document security (could be simulated by using multiple databases per solution)
- No built-in editor role (could be done programmatically)
- No simple queries, every lookup has to be done using map/reduce (very tough, either adds lots of development time on framework side or for each solution)
Now here is the question: Do you know of any DBMS that would add one or more of these features? Maybe there are some commercial solutions out there, possibly wrappers around CouchDB?