I want to provide the online editing facility from postgres database. but it seems if I use Live database it slows down all the function of qgis as its pulls data from online server for every operation such as pan, zoom , open attributes table etc.

Is it advisable to to make a copy of data(tables) in local machine say a memory layer, edit it and then upload the changes back to server ?


QGIS comes with "offline editing" functionality in core. This downloads the data to a local spatialite database, so you can work on an offline copy and the delay caused by network roundtrips is gone. This is not a memory layer but if I understand correctly, that's just an example and not mandatory.

To enable offline editing, you have to check the offline editing plugin in the plugin manager and then use the Plugins > Offline editing menu to make a local copy and after the session to synchronize it back to the server.

  • Thanks Matthias that was good to know we have this great feature inbuilt in QGIS . I will give it a try lets hope it works with my custom plug-in. – Abhijit Gujar Oct 19 '16 at 6:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.