<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Sounds like excellent advice, Carlo, and just what i needed to know to move forward on this -thanks very much!<div><br></div><div>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.:</div><div><br></div><div><div>computer:~ walt$ /Applications/sqlitegeo-macosx-universal-1.0a/SQLiteGeo ; exit;dyld: Library not loaded: ./libSQLite.1.0a.dylib</div><div> Referenced from: /Applications/sqlitegeo-macosx-universal-1.0a/SQLiteGeo</div><div> Reason: image not found</div><div>Trace/BPT trap: 5</div><div>logout</div><div><br></div><div>…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 :)</div><div><br></div><div>*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"? </div><div>(/me likes to share data across several computers via DropBox -only possible single portable files- but that's just me, i always thought :)</div><div><br></div><div>/w</div><div><br></div><div><br></div></div><div><br><div><div>On Mar 14, 2012, at 3:01 PM, <a href="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</a> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Message: 2<br>Date: Wed, 14 Mar 2012 10:40:23 +0100<br>From: "Carlo A. Bertelli (Charta s.r.l.)" <<a href="mailto:bertelli@charta.acme.com">bertelli@charta.acme.com</a>><br>Subject: Re: [Qgis-user] QGIS farm application<br>To:<span class="Apple-converted-space"> </span><a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>Message-ID:<br><span class="Apple-tab-span" style="white-space: pre; "> </span><<a href="mailto:CALc8-VLoObqQTm=EAf6VT2g=EsPpnCE0pA2T2P5iGturkkvLsA@mail.gmail.com">CALc8-VLoObqQTm=EAf6VT2g=EsPpnCE0pA2T2P5iGturkkvLsA@mail.gmail.com</a>><br>Content-Type: text/plain; charset=windows-1252<br><br>Hello Walt,<br>this issue is somehow more general, even if farming is a special case.<br>You are indeed asking two questions:<br>1. is a geodabase worth using in my daily work?<br>2. is a dbms (server) what I need?<br>I think it's definitely useful to deal with a database that merges<br>geographic objects and other types of management data. QGis offers two<br>options at least, Spatialite, which is a single file database (for all<br>your data management needs) and PostGis wich is a traditional DBMS<br>with very powerful spatial extensions.<br>The choice between the two options depends on your needs of<br>collaboration. If you are alone and you keep your data on your pc,<br>than getting rid of database administration is a good choice, and I<br>would suggest Spatialite (by the way, using Spatialite/SQLite is<br>advisable for OpenOffice too), otherwise PostgreSQL+PostGIS could help<br>you sharing data without making "working copies" (which are undoubtly<br>going to become a mess in a few months).<br>Admittably both need some learning of SQL basics, but there is not too<br>much to study; as Alessandro Furieri (the author of Spatialite, a<br>spatial extension to SQLite): "Spatial Is Not Special"<br>(<a href="http://www.gaia-gis.it/gaia-sins/">http://www.gaia-gis.it/gaia-sins/</a>).<br>My two eurocents...<br>c<br></blockquote></div><br></div></body></html>