[Qgis-developer] Database relations and nested forms in QGIS: Call for Funding
Hi all, The Swiss QGIS user community is increasingly building application modules around QGIS. Most of these modules require database relations - not only 1:1, but also 1:n and n:m relations. Currently, only 1:1 relations are supported (with some limitations) in QGIS through the table joins. Since many upcoming QGIS applications will require also 1:n and n:m relations we want to make database relations a core feature in QGIS. Matthias Kuhn from Switzerland already started work on this and will continue to work on it. Some swiss communities started funding this and other efforts in QGIS - now we are looking for some additional funding and are also approaching the international QGIS community for financial support. Matthias and Denis Rouzaud (both from Switzerland) already worked on the following forms and database improvements: * drag and drop forms designer - allows to easily re-order form widgets and group them in tabs and groups * combining forms and tables into a single window (dual view) * Allow to step through all records and forms one by one * Filters/Selections apply on both forms and table * database relations manager allows to set foreign key database relations (regardless of the provider - you can join f.e. a Postgis-table with a SQL-server table) The next steps would be the nested forms where one can embed one child form in another master form and the records are filled into the child form automatically based on the relation defined in the relations manager. We are looking for funding of CHF 13'000, approx. 10'500 € or 13'700 US$ to complete this work for the nested forms. If you have an interest in database relations and more complex forms please consider to support this important QGIS feature that will in the future allow to build more complex tools and applications with QGIS and databases. If you are interested, please contact me and I can forward you the more detailed specification of what we plan with the nested forms. Thank you, Andreas ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Database relations and nested forms in QGIS: Call for Funding
Hi again, I wanted to add that the proposal also includes managing relations (adding/removing relations) by picking one or more feature geometries in the map or one or more records in a related table, once the relations are defined in the relation manager and the widgets are defined accordingly. Thanks, Andreas Am 20.03.2013 08:32, schrieb Andreas Neumann: Hi all, The Swiss QGIS user community is increasingly building application modules around QGIS. Most of these modules require database relations - not only 1:1, but also 1:n and n:m relations. Currently, only 1:1 relations are supported (with some limitations) in QGIS through the table joins. Since many upcoming QGIS applications will require also 1:n and n:m relations we want to make database relations a core feature in QGIS. Matthias Kuhn from Switzerland already started work on this and will continue to work on it. Some swiss communities started funding this and other efforts in QGIS - now we are looking for some additional funding and are also approaching the international QGIS community for financial support. Matthias and Denis Rouzaud (both from Switzerland) already worked on the following forms and database improvements: * drag and drop forms designer - allows to easily re-order form widgets and group them in tabs and groups * combining forms and tables into a single window (dual view) * Allow to step through all records and forms one by one * Filters/Selections apply on both forms and table * database relations manager allows to set foreign key database relations (regardless of the provider - you can join f.e. a Postgis-table with a SQL-server table) The next steps would be the nested forms where one can embed one child form in another master form and the records are filled into the child form automatically based on the relation defined in the relations manager. We are looking for funding of CHF 13'000, approx. 10'500 € or 13'700 US$ to complete this work for the nested forms. If you have an interest in database relations and more complex forms please consider to support this important QGIS feature that will in the future allow to build more complex tools and applications with QGIS and databases. If you are interested, please contact me and I can forward you the more detailed specification of what we plan with the nested forms. Thank you, Andreas ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Database relations and nested forms in QGIS: Call for Funding
Hi Andreas, what is the target version for this? I sent you a private email fior fundings. Régis -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Database-relations-and-nested-forms-in-QGIS-Call-for-Funding-tp5041580p5041607.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Database relations and nested forms in QGIS: Call for Funding
Hi Régis, Given the current release schedule this won't make it into 2.0, but would go into 2.1 then. Previous work made by Matthias is either already in master (the drag and drop attribute designer), or pull requests hanging (the dual view attribute/forms work). The relations manager is almost finished I heard, but is not of much use without the nested forms - so probably will be postponed to version 2.1 Andreas Am 20.03.2013 10:03, schrieb Régis Haubourg: Hi Andreas, what is the target version for this? I sent you a private email fior fundings. Régis -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Database-relations-and-nested-forms-in-QGIS-Call-for-Funding-tp5041580p5041607.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Database relations and nested forms in QGIS: Call for Funding
That sounds good to me, I'm reviewing current blockers, and we already have some work with current features for 2.0. 2.1 seems good. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Database-relations-and-nested-forms-in-QGIS-Call-for-Funding-tp5041580p5041670.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer