[GRASS-user] Navicat PostGRESQL and MYSQL

GRASS GRASS user
,
1

Hi folks,

I was wondering if anyone has any experience using the Navicat versions of PostGRESQL and MYSQL with GRASS (or qgis). Navicat provides a gui front end for PostgreSQL and MYSQL. I was hoping one of these might be easier to use than the opensource text versions. Does anyone know of any opensource versions that have a gui interface, or has anyone had any success at linking Filemaker data bases to GRASS or qgis.

Kurt Springs

2

Kurt Springs napisał(a):

Hi folks,

I was wondering if anyone has any experience using the Navicat versions of PostGRESQL and MYSQL with GRASS (or qgis). Navicat provides a gui front end for PostgreSQL and MYSQL. I was hoping one of these might be easier to use than the opensource text versions. Does anyone know of any opensource versions that have a gui interface, or has anyone had any success at linking Filemaker data bases to GRASS or qgis.

Kurt Springs

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

well navicat is commercial gui frontend for open source servers (there are several more!). Both mysql and pgsql has its own open source gui fronts ends (pgadmin3 for pgsql and my sql admin and query bulder for mySQL). For windows wersion the guis are integrated with servers in one isntalation pockets for linux are as spareate packages (to compile or to install from repositories)

To use databses gui with grass is out of disscution. It base on preferences of user. Generaly with gui it is easier to manage whole database, but text interface (db.select and db.execute) are neccesary to integrate sql commad into grass script
Jarek Jasiewicz

3

Hi Kurt,

did you try pgadminIII as a PostgreSQL GUI? I find it very intuitive. It is more an administrator tool and not so much for data editing: http://www.pgadmin.org/

works on Linux, MacOSX and Linux.

Andreas

Kurt Springs wrote:

Hi folks,

I was wondering if anyone has any experience using the Navicat versions of PostGRESQL and MYSQL with GRASS (or qgis). Navicat provides a gui front end for PostgreSQL and MYSQL. I was hoping one of these might be easier to use than the opensource text versions. Does anyone know of any opensource versions that have a gui interface, or has anyone had any success at linking Filemaker data bases to GRASS or qgis.

Kurt Springs

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

--
----------------------------------------------
Andreas Neumann
Institute of Cartography
ETH Zurich
Wolfgang-Paulistrasse 15
CH-8093 Zurich, Switzerland

Phone: ++41-44-633 3031, Fax: ++41-44-633 1153
e-mail: neumann@karto.baug.ethz.ch
www: http://www.carto.net/neumann/
SVG.Open: http://www.svgopen.org/
Carto.net: http://www.carto.net/

4

Hi Kurt,
for postgresql, you could use pgadmin [1] or pgaccess. There's also another programme called knoda, which is able to work with different formats like mysql, sqlite and postgresql. I only have little experience in using pgaccess, but I had the impression that these kind of applicatons can really ease tabular work.

[1] http://www.pgadmin.org/download/macosx.php

Regards,
Wolfgang

Kurt Springs schrieb:

Hi folks,

I was wondering if anyone has any experience using the Navicat versions of PostGRESQL and MYSQL with GRASS (or qgis). Navicat provides a gui front end for PostgreSQL and MYSQL. I was hoping one of these might be easier to use than the opensource text versions. Does anyone know of any opensource versions that have a gui interface, or has anyone had any success at linking Filemaker data bases to GRASS or qgis.

Kurt Springs

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

--

  *Wolfgang Qual

* *Referat für Gesundheit und Umwelt*
Umweltschutz
Umweltvorsorge
RGU-UW 11

Bayerstraße 28a
80335 München

Telefon +49 - 89 - 233 - 4 77 17
Telefax +49 - 89 - 233 - 4 77 05

http://www.muenchen.de/umweltatlas
uw11.rgu@muenchen.de
Bitte beachten Sie die Hinweise zur elektronischen
Kommunikation mit der Landeshauptstadt München:
http://www.muenchen.de/ekomm

5

Thanks everyone who answered. Because of its reputed power in GIS I would opt for PostGRESQL with PostGIS and an pgadmin front end. However I have had trouble in the past trying to install PostGRESQL and could never get it quite right. I use a Mac with OS X, and it requires me to open two accounts on the operating system, and even following written directions to the letter, it never came out useable and all I ended up doing is taking up space on my hard drive to no useful purpose. Has anyone else had a similar experience and found away around these problems? I wish I could describe what was said, but it was some years ago. After that experience I had been reluctant to try again.

Is MYSQL any easier to install? Also, has anyone had success with SQL Lite Browser?

Thanks for the advice.

Kurt

6

OSX, eh? Have you tried my Postgres + PostGIS package? If you had problems with that, I can help you get it going. (And I'd just like to know, if there is something I need to fix.)

There is only one required new user for the system - an unprivileged user much like www and postfix, needed to run Postgres - and that is created during installation. (But you may need to delete previously created postgres users first or you may have problems, as I discovered recently.)

On Feb 24, 2007, at 4:34 PM, Kurt Springs wrote:

Thanks everyone who answered. Because of its reputed power in GIS I would opt for PostGRESQL with PostGIS and an pgadmin front end. However I have had trouble in the past trying to install PostGRESQL and could never get it quite right. I use a Mac with OS X, and it requires me to open two accounts on the operating system, and even following written directions to the letter, it never came out useable and all I ended up doing is taking up space on my hard drive to no useful purpose. Has anyone else had a similar experience and found away around these problems? I wish I could describe what was said, but it was some years ago. After that experience I had been reluctant to try again.

-----
William Kyngesburye <kyngchaos@kyngchaos.com>
http://www.kyngchaos.com/

First Pogril: Why is life like sticking your head in a bucket filled with hyena offal?
Second Pogril: I don't know. Why IS life like sticking your head in a bucket filled with hyena offal?
First Pogril: I don't know either. Wretched, isn't it?

-HitchHiker's Guide to the Galaxy

7

Hi Kurt,

Yes, PostgreSQL/Postgis is definitely more powerful and tested for geographic data than MySQL and SQLite. Also PGAdminIII is a good piece of software. There is an installer for PgadminIII for OSX which runs withouth problem.

I did a PostgreSQL/Postgis install on OSX (compiled from source) several times, following the instructions here: http://www.faqs.org/docs/ppbook/x486.htm - although this is written for version 7 of Postgresql, the procedure is still the same. Here is also an installation tutorial: http://www.postgresql.org/docs/8.2/interactive/install-short.html It requires the Unix development tools (which you can install from the Apple Developers CD) and some Unix knowhow, but other than that its a step by step thing. I didn't have problems with it.

After installing, be sure to allow network access from other computers by following the instructions here: http://www.postgresql.org/docs/8.2/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS (postgresql.conf)

and here (pg_hba.conf):

http://www.postgresql.org/docs/8.2/interactive/client-authentication.html

Hope this helps,
Andreas

Kurt Springs wrote:

Thanks everyone who answered. Because of its reputed power in GIS I would opt for PostGRESQL with PostGIS and an pgadmin front end. However I have had trouble in the past trying to install PostGRESQL and could never get it quite right. I use a Mac with OS X, and it requires me to open two accounts on the operating system, and even following written directions to the letter, it never came out useable and all I ended up doing is taking up space on my hard drive to no useful purpose. Has anyone else had a similar experience and found away around these problems? I wish I could describe what was said, but it was some years ago. After that experience I had been reluctant to try again.

Is MYSQL any easier to install? Also, has anyone had success with SQL Lite Browser?

Thanks for the advice.

Kurt

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

--
----------------------------------------------
Andreas Neumann
Institute of Cartography
ETH Zurich
Wolfgang-Paulistrasse 15
CH-8093 Zurich, Switzerland

Phone: ++41-44-633 3031, Fax: ++41-44-633 1153
e-mail: neumann@karto.baug.ethz.ch
www: http://www.carto.net/neumann/
SVG.Open: http://www.svgopen.org/
Carto.net: http://www.carto.net/