Hi folks,
I have some questions as to which databases people are using with grass. I currently use Filemaker for as a database, but could never get it to link to GRASS. I was wondering if this problem has been resolved. Otherwise, I am considering which database software would provide easy of use and still get the data I need ported to my GRASS GISs. I contemplating Postgresql but it isn't all that intuitive. How are MySQL and SQLite Browser?
Kurt
Kurt Springs ha scritto:
I have some questions as to which databases people are using with
grass. I currently use Filemaker for as a database, but could never get
it to link to GRASS. I was wondering if this problem has been
resolved. Otherwise, I am considering which database software would
provide easy of use and still get the data I need ported to my GRASS
GISs. I contemplating Postgresql but it isn't all that intuitive. How
are MySQL and SQLite Browser?
You can use OpenOffice.org as a database browser, which makes things a
lot simpler. Probably you're better off starting with SQLite, and move
to PostgreSQL when you'll need it (and feel more confident about the
system).
All the best.
pc
--
Paolo Cavallini, see: http://www.faunalia.it/pc
I really recommend PostgreSQL/Postgis. It might be a little more complex
to use than Filemaker, but it is easier to use than Oracle or DB2. I
believe it is the most widely supported spatial database in Open Source
GIS, but also increasingly in the commercial world (ESRI 9.3 will support
it through ArcSDE). Also it has a lot more spatial functionality than
MySQL or DB2. Don't know about Oracle Spatial.
As for database administration I recommend the GUI admin tool pgadmin3,
which is very intuitive and cross-platform. It misses the form-part of
Filemaker, but other than that it is really easy to use.
Andreas
Hi folks,
I have some questions as to which databases people are using with
grass. I currently use Filemaker for as a database, but could never
get it to link to GRASS. I was wondering if this problem has been
resolved. Otherwise, I am considering which database software would
provide easy of use and still get the data I need ported to my GRASS
GISs. I contemplating Postgresql but it isn't all that intuitive.
How are MySQL and SQLite Browser?Kurt
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user
--
Andreas Neumann
Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland
Email: a.neumann@carto.net, Web:
* http://www.carto.net/ (Carto and SVG resources)
* http://www.carto.net/neumann/ (personal page)
* http://www.svgopen.org/ (SVG Open Conference)
* http://www.geofoto.ch/ (Georeferenced Photos of Switzerland)
Paolo Cavallini wrote:
Kurt Springs ha scritto:
I have some questions as to which databases people are using with
grass. I currently use Filemaker for as a database, but could never get
it to link to GRASS. I was wondering if this problem has been
resolved. Otherwise, I am considering which database software would
provide easy of use and still get the data I need ported to my GRASS
GISs. I contemplating Postgresql but it isn't all that intuitive. How
are MySQL and SQLite Browser?You can use OpenOffice.org as a database browser, which makes things a
lot simpler. Probably you're better off starting with SQLite, and move
to PostgreSQL when you'll need it (and feel more confident about the
system).
See
http://grass.gdf-hannover.de/wiki/Openoffice.org_with_SQL_Databases
for related tips 'n tricks.
Markus
--
View this message in context: http://www.nabble.com/Database-for-GRASS-tf4954148.html#a14189132
Sent from the Grass - Users mailing list archive at Nabble.com.
There was a discussion some time ago about the possibility of using Filemaker databases with GRASS. The newest version of Filemaker (9) makes a big deal of how it can work with sql databases. See http://www.filemaker.com/support/technologies/sql.html. You use (i.e. buy separately) an ODBC driver to allow Filemaker to access existing SQL databases as external data sources. I did this with some of my GRASS and other databases, using (so far) only the free trial version of the ODBC driver. The connectivity is now limited to MySQL, not Postgres, but this could easily change, I imagine, and may be possible to get around already; I haven't tried. I then created a dummy Filemaker file, which has no real data but is just a front end into that SQL database. it worked fine, although I haven't paid the $29 for the full version of the ODBC driver so I can't tell whether it's fast enough with large databases. With this system, though, I don't think you can create or drop databases, or otherwise administer them, adding or modifying fields, etc. So you still need to install postgres or mysql, configure them, and create the databases. You can populate the database in Filemaker, edit data, create reports, and such, all of which is pretty easy and intuitive. Then GRASS can access the mysql database directly -- not the filemaker database, but the data that Filemaker is accessing as an external data source.
For me, the advantages of using Filemaker as a front end didn't seem that great -- you still have to create & administer the databases, and there are some excellent tools for doing that. I like Aqua Data Studio, whose last version was free for personal use (the current one isn't, and I haven't used it). I've also tried CocoaMySQL, which is also free. Both have reasonably good editing tools. There are a large number of other front ends to postgres or mysql that offer a more intuitive user interface. This is probably more important than whether you use postgres or mysql or sqlite as the back-end database (I guess -- others will know better...). I haven't used OpenOffice.
This isn't exactly what you want -- you're looking for a driver that would allow GRASS to access native Filemaker databases directly, instead of having Filemaker access a sql database. I don't know if this is possible, but am interested in it if it were.
Cheers,
Nick Cahill
----- Original Message -----
From: Kurt Springs <ferret_bard@mac.com>
Date: Wednesday, December 5, 2007 11:33 pm
Subject: [GRASS-user] Database for GRASS
To: grassuser@grass.itc.it
Hi folks,
I have some questions as to which databases people are using with
grass. I currently use Filemaker for as a database, but could neverget it to link to GRASS. I was wondering if this problem has been
resolved. Otherwise, I am considering which database software wouldprovide easy of use and still get the data I need ported to my GRASS
GISs. I contemplating Postgresql but it isn't all that intuitive.
How are MySQL and SQLite Browser?Kurt
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
Kurt,
I'm very pleased with MySQL's performance on both linux (Gentoo) and Mac OS
X; a big bonus for me is that I can use the ODBC connector for MySQL with my
statistics package (Stata) and the JDBC connector for MySQL with
OpenOffice's Base. Further, Perl's MySQL interface is very solid and lets me
script lots of GRASS commands and data extraction.
If you take the time to set up and learn a little MySQL, I think it's a
great database engine.
I haven't used FileMaker for years, though it was a godsend during the Mac
System 7.x and Mac OS 8.x days. Now, though, I can't see paying for the ODBC
connector when MySQL's versions work quite nicely.
Jesse
----- Original Message -----
From: Kurt Springs <ferret_bard@mac.com>
Date: Wednesday, December 5, 2007 11:33 pm
Subject: [GRASS-user] Database for GRASS
To: grassuser@grass.itc.itHi folks,
I have some questions as to which databases people are using with
grass. I currently use Filemaker for as a database, but could neverget it to link to GRASS. I was wondering if this problem has been
resolved. Otherwise, I am considering which database software wouldprovide easy of use and still get the data I need ported to my GRASS
GISs. I contemplating Postgresql but it isn't all that intuitive.
How are MySQL and SQLite Browser?Kurt
This e-mail message (including any attachments) is for the sole use of
the intended recipient(s) and may contain confidential and privileged
information. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this message (including any attachments) is strictly
prohibited.
If you have received this message in error, please contact
the sender by reply e-mail message and destroy all copies of the
original message (including attachments).
On Thursday 06 December 2007 07:33:44 am Hamner, Jesse Harrison wrote:
Kurt,
I'm very pleased with MySQL's performance on both linux (Gentoo) and Mac OS
X; a big bonus for me is that I can use the ODBC connector for MySQL with
my statistics package (Stata) and the JDBC connector for MySQL with
OpenOffice's Base. Further, Perl's MySQL interface is very solid and lets
me script lots of GRASS commands and data extraction.If you take the time to set up and learn a little MySQL, I think it's a
great database engine.I haven't used FileMaker for years, though it was a godsend during the Mac
System 7.x and Mac OS 8.x days. Now, though, I can't see paying for the
ODBC connector when MySQL's versions work quite nicely.Jesse
> ----- Original Message -----
> From: Kurt Springs <ferret_bard@mac.com>
> Date: Wednesday, December 5, 2007 11:33 pm
> Subject: [GRASS-user] Database for GRASS
> To: grassuser@grass.itc.it
>
>> Hi folks,
>>
>> I have some questions as to which databases people are using with
>> grass. I currently use Filemaker for as a database, but could never
>>
>> get it to link to GRASS. I was wondering if this problem has been
>> resolved. Otherwise, I am considering which database software would
>>
>> provide easy of use and still get the data I need ported to my GRASS
>>
>> GISs. I contemplating Postgresql but it isn't all that intuitive.
>> How are MySQL and SQLite Browser?
>>
>> Kurt
Some of my observations over the years.
1. MySQL is simple to setup, easy to administer, and relatively fast.
2. PostgreSQL is a *little* harder to setup
that said... I was disapointed with the way MySQL deals with poorly formatted
queries: i.e. inserting characters into a numeric column silently inserts a 0
(!)... This was back in version 4.3 - so maybe they have changed this.
I am more concerned with data integrity, and PostGreSQL seems like the best
for me. Also -- it supports several procedural languages: R, Python, PL/SQL,
Perl... Also the very excellent PostGIS functions.
I use PgAdmin III when I need a GUI. I think that this application is
cross-platform.
R has a native connector for PostGreSQL as well.
Cheers,
Dylan
I think the key to access FileMaker DBs from GRASS is that the FileMaker ODBC connector is for OSX's iODBC, not UnixODBC.
GRASS 6.2 does not have a configure option to build with iODBC, tho it can be hacked.
GRASS 6.3 does have an iODBC configure option. It's the same --with-odbc-* options, it just tries iodbc if it can't find unixodbc.
On Dec 6, 2007, at 9:25 AM, Nick Cahill wrote:
There was a discussion some time ago about the possibility of using Filemaker databases with GRASS. The newest version of Filemaker (9) makes a big deal of how it can work with sql databases. See
...
----- Original Message -----
From: Kurt Springs <ferret_bard@mac.com>
Date: Wednesday, December 5, 2007 11:33 pm
Subject: [GRASS-user] Database for GRASS
To: grassuser@grass.itc.itHi folks,
I have some questions as to which databases people are using with
grass. I currently use Filemaker for as a database, but could neverget it to link to GRASS. I was wondering if this problem has been
resolved. Otherwise, I am considering which database software wouldprovide easy of use and still get the data I need ported to my GRASS
GISs. I contemplating Postgresql but it isn't all that intuitive.
How are MySQL and SQLite Browser?Kurt
_______________________________________________
-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/
Earth: "Mostly harmless"
- revised entry in the HitchHiker's Guide to the Galaxy
I've used PostgreSQL and SQLite. Both worked fine but I've never done
any database intensive stuff so I can't tell if there is any speed or
performance difference between the two.
What I found *very good* about SQLite is that the database is stored
in a file. No need to setup servers like postgresql or MySQL. And
there is no configuration necessary! It's as simple as naming the
database file with db.connect and you are set! And, if you ever need a
frontend to the SQLite database, just use SQLite Browser or
openoffice.org-base.
Daniel
On Dec 6, 2007 3:33 AM, Kurt Springs <ferret_bard@mac.com> wrote:
Hi folks,
I have some questions as to which databases people are using with
grass. I currently use Filemaker for as a database, but could never
get it to link to GRASS. I was wondering if this problem has been
resolved. Otherwise, I am considering which database software would
provide easy of use and still get the data I need ported to my GRASS
GISs. I contemplating Postgresql but it isn't all that intuitive.
How are MySQL and SQLite Browser?Kurt
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user