# PostgreSQL back end solution for quality assurance and data archive | QField - Efficient field work built for QGIS

**URL:** <https://community.qfield.org/t/postgresql-back-end-solution-for-quality-assurance-and-data-archive-qfield-efficient-field-work-built-for-qgis/1909>\
**Category:** Blog discussions\
**Created:** [11 September 2026 18:27 UTC](https://community.qfield.org/t/postgresql-back-end-solution-for-quality-assurance-and-data-archive-qfield-efficient-field-work-built-for-qgis/1909 "2026-09-11T18:27:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mbernasocchi](https://dub1.discourse-cdn.com/flex018/user_avatar/community.qfield.org/mbernasocchi/32/19_2.png) [@mbernasocchi](https://community.qfield.org/u/mbernasocchi)\
**Post date:** [11 September 2026 18:27 UTC](https://community.qfield.org/t/postgresql-back-end-solution-for-quality-assurance-and-data-archive-qfield-efficient-field-work-built-for-qgis/1909/1 "2026-09-11T18:27:20Z")

</div>

**_Did you know that the possibilities to make a full QGIS back end solution for quality assurance and archiving in PostgreSQL are immense? SQL has it’s well known limitations, but with a little bit creativity you can make quite nice solutions just using triggers and rules. In this post I’ll explain&nbsp;what we did lately based on a project with a customer. He needed to assure the consistency&nbsp;of data but still give his employees the possibility of a fast feeding of the data collected on the field to the database.&nbsp;Another request was to keep every status of the data with the information about the changes (archiving)._** It’s always the question, where to put the logical part of the solution. QGIS is quite powerful with constraints, but the undeniable advantage of a back end solution is, that you can use any front end - no matter what configuration you have on QGIS or what Feature Manipulation Engine (FME) you use - without influencing the guarantee of data validity.

* * *
This is a companion discussion topic for the original entry at [https://qfield.org/pr-preview/pr-88/blog/2018/01/08/postgresql-back-end-solution-for-quality-assurance-and-data-archive/](https://qfield.org/pr-preview/pr-88/blog/2018/01/08/postgresql-back-end-solution-for-quality-assurance-and-data-archive/)