The normal View/Edit data features of the database manager are not available for CouchDB. In this video I detail the inbuilt admin console of CouchDB (previously undocumented on the forum I believe) accessible from the Resource Manager.
4 Likes
Hi there @Hyperbytes!
Thanks for these brilliant videos… it makes such a difference to be able to see these new features and to have someone explaining them to you!
A question… Couch/PouchDB is only useful to me if it can replicate with my app’s existing MySQL database… will you be doing some videos about how to achieve this?
That would be amazing! 
They will come as soon as the Wappler team have actually implemented it. There is a huge amount to come and even I don’t know exactly what is coming next, I am actually working by intuition at present as the ground i am covering has not actually been covered by the team, i am guessing at this stage!!
Certainly i see Couch/SQL integration as essential and am pretty certain it is coming at some stage
1 Like
Thanks for that update @Hyperbytes!
When I asked @George that question, he replied with this:
But that implies I need to perform all the replication myself with a large number of replicating server actions… plus one database is SQL and one is noSQL and there is a ton to learn about how to map one to the other… and my app is on PHP which could be an issue… so I’m not sure if you could show us a video of how to do what George is suggesting or if it is even a truly sensible way forwards for an app as big as mine…
Then I found this product while cruising around the internet…
I’ve no idea if that is a potential solution or how you would use it with Wappler…
So currently this Couch/Pouch thing feels more like an academic interest unless I can see a way forwards to use it alongside what I already have!
I confess, i am hoping for some sort of automated replication myself but only time will tell, a SC replicate action would be amazing.
Until i get a clear picture of where couch/pouch is going I cant really go much further at this point but once the roadmap is clear i will do whatever i can.
I did post a “would be nice” suggestion for the Database Manager the other day regarding this issue.
So that in the Wappler Database Manager an automated default synch to SQL Relational Databases Models was incorporated with Project setup.
Instead of having to add it manually into flows.
As for PHP servers I can think of several ways to set up synching to postgresql and mysql database tables. But the Database Manager so integrated with Couch would be a logical project setup.
2 Likes
From what I see this CData Sync runs as a 3rd party hosted service requiring running more API resource/s.
They do offer great solutions for multiple data heavy applications.
But, I would rather run a synch service on my own server environment incorporated into its scripts where the CouchDB databases can be aggregated into a slave-master relational db for just my project. Not dependent on another cloud service just to do this synching.
Of course, this can be written without reliance on a new Wappler component, but, incorporated into the App Connect model would be LOGICAL.
1 Like