[Qgis-user] [Qgis-developer] Database relations and nested forms in QGIS: Call for Funding

[Tim Sutton]

Hi

On Wed, Mar 20, 2013 at 9:47 AM, Andreas Neumann <a.neumann at carto.net> wrote:
> 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.
>

Hopefully it also covers implementation of tests too! :-)

Regards

Tim

> 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 at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user



--
Tim Sutton - QGIS Project Steering Committee Member (Release  Manager)
==============================================
Please do not email me off-list with technical
support questions. Using the lists will gain
more exposure for your issues and the knowledge
surrounding your issue will be shared with all.

Visit http://linfiniti.com to find out about:
 * QGIS programming and support services
 * Mapserver and PostGIS based hosting plans
 * FOSS Consulting Services
Skype: timlinux
Irc: timlinux on #qgis at freenode.net
==============================================