I am a new user of QGIS. I was surprised how easy it is to visualize data from a SQL database in QGIS. Now I wonder if it is possible that changes in the database can be passed on directly to QGIS. Even better would be the reverse way. Where can I find information about this?

At the moment I use MariaDB 10 and QGIS 2.18.13

  • Do you mean you want to edit your database within QGIS? Please give more details on the database you use and QGIS version... – YoLecomte Oct 28 '17 at 16:28
  • Frank - absolutely. Any data value change made at the SQL/Database level requires only a slight pan of the map to see the changes. Any schema changes to the table can be applied by only refreshing the layer using the ChangeDataSources plugin... we live by this! – DPSSpatial Oct 28 '17 at 16:37
  • DPSSpatial - That sounds good! I will try it. – Frank Simonis Oct 28 '17 at 17:00
  • At the moment I use MariaDB 10 and QGIS 2.18.13 – Frank Simonis Oct 28 '17 at 17:03
  • @FrankSimonis we use both PostGIS and MS SQL Server – DPSSpatial Oct 28 '17 at 17:50

Yes, data changes can be passed on both ways. If you have e.g. a PostGIS data source added to the canvas, changes in the data table will be shown on the map e.g. if you refresh the connection or pan the layer in QGIS.

Vice versa, if you edit features using the main toolbar, edits will be saved to the database.

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.