With Wappler 6.0 coordinating CouchDB & PouchDB into the Database Manager I started reading up on CouchDB on the server side.
Because of the default compartmentalization of CouchDB databases saving data objects in a nosql structure & the separate db per user there should be for some projects an aggregating mysql or postgresql schema compilation also running.
For instance, a company wants to run data models, analysis and or visualizations using good old sql language queries. CouchDB, from what I read, is not well suited for aggregate querying across multiple user’s databases.
A nice extension in the Wappler Database Manager would be to include after setting up the CouchDB schema an intuitive panel to automate creating and updating both mysql and postgresql databases on the same or a separate remote server. So that these more comprehensive sql relational databases are always immediately synched with updates and changes within all the affected CouchDB database records per user.
That way Wappler Admin panels can be built for office use that can queried with sql language to access all of the nonsql CouchDB schemas.