08-26, 10:00–10:30 (Europe/Rome), Room Onice
QGIS and PostGIS are now renown as one of the best combination to setup a GIS application.
The support of PostGreSQL and PostGIS in QGIS have grown very mature and offers great features to deal with your database stored geographic data. It allows to create powerful business application easily without any advanced programming language skills, only plain SQL and a well configured QGIS.
This presentation will showcase some of the interesting features you should be aware of in order to build the perfect GIS user application. I'll explain how to:
- Properly configure relations between layers/tables,
- Enable transactions (and whether or not you should do it),
- Communicate from PostGreSQL to QGIS using notifications,
- Deal with triggers using data dependencies,
- Store your QGIS project and style information in a PostGIS database,
- Output your processing result directly to your database,
- Manage your database directly from the browser.
These will be some of the key features that will be demonstrated along with a given use case.
I started as a C++/Python Developer in industry 15 years ago. I then become specialized in greographical applications development.
I joined Oslandia 4 years ago in order to contribute to GIS free software.
I contribute on regular basis to QGIS (mostly in PostGIS and Oracle providers, forms, and in the rendering engine more recently). I had the chance to become core committer quite recently.
I'm a strong open source advocate, and do my best to improve the GIS free software ecosystem.
I like also to share experiences or technical knowledge with people through talks or workshop.
Twitter account : @CabiecesJ
LinkedIn account : https://www.linkedin.com/in/julien-cabieces-9b55363b/