qgep/QGEP — Issue #2: Connection to the db
Author: 3nids
Created: 2011-12-15 13:31:07+00:00
State: open

I think that one of the first step should be to agree on the way we use the db. I will try to resume the ones we discussed and write down pros and cons.

1. We use editing mode as it is right now.
*+ keep usual way of editing
*- we cannot use object that are not in the db yet, and therefore we cannot create objects in a chain

2. We save the element in the db as soon as they are created
*+ can create objects in chain
*- not usual way of editing in qgis
*- no undo redo

3. We create the uuid in qgis
*+ we can create objects in chain
*+ we can use undo redo
*+ we keep editing mode style, i.e. start and stop editing

4. We use negative ids of qgis
*+ the same as for choice 3
*- we need to create rules for insertion by using the correct ids and doing the insertion in a special order to avoid the break of foreign keys.

In all of the four cases, it should not be a problem to use something else than Postgres. It might be useful for a small town with a single user to use qgis with SQLite, as there is no special setup...