[Qgis-user] Re: QGIS Farm application

[Walter Ludwick]

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, qgis-user-request at lists.osgeo.org wrote:

> Message: 2
> Date: Wed, 14 Mar 2012 10:40:23 +0100
> From: "Carlo A. Bertelli (Charta s.r.l.)" <bertelli at charta.acme.com>
> Subject: Re: [Qgis-user] QGIS farm application
> To: qgis-user at lists.osgeo.org
> Message-ID:
> 	<CALc8-VLoObqQTm=EAf6VT2g=EsPpnCE0pA2T2P5iGturkkvLsA at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120314/55f5c9b9/attachment.html>