Sounds like excellent advice, Carlo, and just what i needed to know to move forward on this -thanks very much!
Spatialite is a new one on me -tho i'm a fan of SQLite and have always wished that this were the native format of OO Base (so one doesn't have to diddle with ODBC drivers etc*), so i have downloaded it and am working on the install now (ran into a little snag, i.e.: computer:~ walt$ /Applications/sqlitegeo-macosx-universal-1.0a/SQLiteGeo ; exit;dyld: Library not loaded: ./libSQLite.1.0a.dylib Referenced from: /Applications/sqlitegeo-macosx-universal-1.0a/SQLiteGeo Reason: image not found Trace/BPT trap: 5 logout …but i expect to get this sorted and be cooking with gas soon (tho i am quite inept at this unix-y stuff, i am actually quite comfortable with SQL :) *PS: This may be off-topic for list (if so, feel free to email me), but i do wonder why you say "using Spatialite/SQLite is advisable for OpenOffice too"? (/me likes to share data across several computers via DropBox -only possible single portable files- but that's just me, i always thought :) /w On Mar 14, 2012, at 3:01 PM, [email protected] wrote: > Message: 2 > Date: Wed, 14 Mar 2012 10:40:23 +0100 > From: "Carlo A. Bertelli (Charta s.r.l.)" <[email protected]> > Subject: Re: [Qgis-user] QGIS farm application > To: [email protected] > Message-ID: > <CALc8-VLoObqQTm=EAf6VT2g=esppnce0pa2t2p5igturkkv...@mail.gmail.com> > Content-Type: text/plain; charset=windows-1252 > > Hello Walt, > this issue is somehow more general, even if farming is a special case. > You are indeed asking two questions: > 1. is a geodabase worth using in my daily work? > 2. is a dbms (server) what I need? > I think it's definitely useful to deal with a database that merges > geographic objects and other types of management data. QGis offers two > options at least, Spatialite, which is a single file database (for all > your data management needs) and PostGis wich is a traditional DBMS > with very powerful spatial extensions. > The choice between the two options depends on your needs of > collaboration. If you are alone and you keep your data on your pc, > than getting rid of database administration is a good choice, and I > would suggest Spatialite (by the way, using Spatialite/SQLite is > advisable for OpenOffice too), otherwise PostgreSQL+PostGIS could help > you sharing data without making "working copies" (which are undoubtly > going to become a mess in a few months). > Admittably both need some learning of SQL basics, but there is not too > much to study; as Alessandro Furieri (the author of Spatialite, a > spatial extension to SQLite): "Spatial Is Not Special" > (http://www.gaia-gis.it/gaia-sins/). > My two eurocents... > c
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
