qgep/QGEP — Issue #1: Connection to the db
Author: 3nids
Created: 2011-12-15 13:23:21+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...