We have a web application built on RoR, its using postgresql, now we have to integrate mobile application with it, the mobile application have to be able to manage offline mode, so we need to sync information between web app and mobile app.
The question is, if I have the data stored on postgresql and I need to use couchdb and pouchdb for offline syncing, what can I do??
Thanks!!
Simple Replication with the Admin InterfaceStart CouchDB and open your browser to http://127.0.0.1:5984/_utils/ . On the righthand side, you will see a list of things to visit in Futon. Click on “Replication.” Futon will show you an interface to start replication.
Steps to Connect R & PostgreSQL using RPostgreSQLStep 1: Install the RPostgreSQL Package. Step 2: Enter your PostgreSQL Credentials. Step 3: Establish R & PostgreSQL Connection using RPostgreSQL. Step 4: Run and Test Queries using RPostgreSQL.
Switching between databases is another way of saying you are closing one connection and opening another. When you need to change between databases, you'll use the “connect” command, which is conveniently shortened to \c, followed by the database name.
Can you make sure that you write only on CouchDb and PostgreSQL is only used for reading data? In that case you can use the _changes feed of CouchDb to replicate all the data back to your PostgreSQL database for readonly-access.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With