After considering a few options, I'm trying to give my 15-20 QGIS 2.2 users the ability to concurrently view/edit one or two basic point PostGIS layers, largest one has just 16,000 records. I've installed PostgreSQL 9.1 / PostGIS 2.0 and basic testing seems to work ok but haven't unleashed it to the masses yet.
We'll typically only have 2-3 editors at a time, but possibly 15 viewers. Edits will all be in QGIS, viewers will be QGIS and ArcGIS (but we don't have SDE).
As I said, these are just basic point files, and edits will just be adding/deleting points and some table edits. I am not worried about editing the same features at the same time.
Can the combination provide dependable multi-user editing for two basic point files?
Answer
Since you're not worried about simultaneous edits on features, I'd say that in theory you have nothing to worry about. The main danger w/ QGIS is that simultaneous editors can stomp on each other's edits without noticing ("last edit wins").
For data under active editing with multiple users you might want to at least keep track of history, which you can do w/o changing anything about QGIS, just adding some triggers and a history table to your active tables.
http://postgis.net/workshops/postgis-intro/history_tracking.html
That way if you ever want to revert changes you'll have a place to go that's easier to access than the database backups and point-in-time recovery.
No comments:
Post a Comment