Overall Satisfaction with CouchDB
There are multiple legacy applications which use SQL databases as a backend for services which are invoked from POS systems. We managed to migrate these applications to CouchDB which provided a faster response.
- Faster retrieval is the main key. When the data is denormalized in required format, the response time for queries without id columns are really fast in CouchDB.
- Replacing Oracle views to bucket structure provides great readability and flexibility to the data.
- Writing multiple views supporting the needs that will perform the action in an equal amount of time makes CouchDB the favourite database for query-like micro services.
- Views need to be more easier for creation.
- Documentation is the key for the development with multiple languages which this lacks.
- As a result of using CouchDB as backend for services, we need not worry about failures that often.
- The response time is the key for the user. Faster response helps serve customers better and reduce the call timings.
- Couchbase Server
Developing spring boot apps with Couchbase using Spring Data JPA really solves complexity of programming.