CouchDB and PouchDB Questions and Limitations

I have been working on converting my existing project to using CouchDB and PouchDB for offline use in the field. I’ve created a new project for this but I have a few questions on the issues and limitations I am running into.

I am getting constant Replication errors and global failure errors where I have to delete the local PouchDB and clear the cache of the site so it starts working again. Will this become more stable over time that it can be usable? Not really a solution to try and clear that out on a phone.

In this particular instance, I am updating a list of values coming from multiple input fields that is inside of a repeat. I have attempted to do a bulk update via PouchDB in a repeat but not being able to select the values inside of a repeat from inside the flow editor causes stoppage right there. I then attempted to replicate what I already had working through a normal MariaDB backend in another project and do a server connect instead, this of course would not work offline but I attempted anyways to see if it would work. I can likely do a single update at a time but in this particular example I am doing a drag/drag sorting so I would need to get all values of the index to update the order which I cannot pull on the user end through a flow via a button click.

I get the following errors and new submissions no longer work

and this from inside Wappler itself.

What would be the best method to sync an API to CouchDB? I know previously we could not do Server side management after it was first released but I was able to get that working now, somewhat, as I got thousands of records added in through the API.

I would have thousands of records for one table and tens or even hundreds of thousands of records for another table coming from an API that would need to by synced to CouchDB then to PouchDB. Would then need submissions from PouchDB to CouchDB then back to the API.

Pagination Generator will not work with a PouchDB View.

I was able to make it work creating it manually but would be nice to make it easier.
Little odd, seems unfinished here?

image
image
image
image
image
image

Finally, offline image submission. Would that be possible with the current PouchDB implementation? I obviously would not want someone submitting 30 images 20 times a day to then sync to everyone else’s devices.

On 6.3.2 Beta Channel

Thanks for any assistance

Seems like something is wrong with the pouchdb database, maybe try to isolate the problem and post for more info at the pouchdb support:

Hey @JonR, you’re asking some good questions that I would love to see answers to as well. I wonder if it would help if you separated each bug or question into separate posts? I think it would be easier to digest and respond to.