Postgres Pro
Downloads
Home   >   mailing lists

Thread: Is there an opensource Mac OSX equivalent to pgAdmin or pgAccess?

Is there an opensource Mac OSX equivalent to pgAdmin or pgAccess?

From
Philip Neukom
Date:
Is there an opensource Mac equivalent to pgAdmin or pgAccess?

I have looked for a few days and don't seem to find anything.  Perhaps it
means doing a compile myself for pgAdmin or pgAccess since they do have Unix
source code.

Thanks in advance
Philip

Re: Is there an opensource Mac OSX equivalent to

From
"Josh Berkus"
Date:
Phillip,

> Is there an opensource Mac equivalent to pgAdmin or pgAccess?

Not Open Source.  Heavy Lifters, Inc. publishes pgMac, which is free
 for non-commercial use:
http://www.pgmac.com
... however, you gotta pay for commercial use.  And I don't think you
 get the source code.  It's a good product, though.

> I have looked for a few days and don't seem to find anything.
>   Perhaps it
> means doing a compile myself for pgAdmin or pgAccess since they do
>  have Unix
> source code.

pgAdmin is Windows-only.  Believe me, I've tried, but it depends on MS
 ODBC and the VB/COM widget set.  pgAccess has, as of 7.2, fallen so
 far behind PostgreSQL development as to be unusable; I'd love to see
 someone re-start this project, but I don't do Tcl.

For more limited but somewhat graphical Postgres access, have you
 considered phpPgAdmin?  It gives you web browser access to the
 database tables, and runs easily on Apache/PHP/Postgres/OSX.1

-Josh Berkus

Re(2): Is there an opensource Mac OSX equivalent to pgAdmin or pgAccess?

From
Philip Neukom
Date:
Josh, thank you for your quick reply.

>> Is there an opensource Mac equivalent to pgAdmin or pgAccess?
>
> Not Open Source.  Heavy Lifters, Inc. publishes pgMac, which is free
> for non-commercial use:
> http://www.pgmac.com
> ... however, you gotta pay for commercial use.  And I don't think you
> get the source code.  It's a good product, though.

I will try this today. Thanks

> For more limited but somewhat graphical Postgres access, have you
> considered phpPgAdmin?  It gives you web browser access to the
> database tables, and runs easily on Apache/PHP/Postgres/OSX.1

This might be interesting but I would need to figure out what PHP is and if
it in the default install of OSX.1.  I know that Apache is there.  Marc L.'s
postgres 7.1.3 install works well too.  Would that entail compiling
phpPgAdmin for OSX?

Thanks again
Philip

Re: Re(2): Is there an opensource Mac OSX equivalent

From
"Josh Berkus"
Date:
Philip,

> This might be interesting but I would need to figure out what PHP is
>  and if
> it in the default install of OSX.1.  I know that Apache is there.
>   Marc L.'s
> postgres 7.1.3 install works well too.  Would that entail compiling
> phpPgAdmin for OSX?

PHP is a Web Scripting language.  You install it with Apache.  I don't
 know what the default OSX Server install comes with.

If you have to install it yourself, be careful; PHP by default connects
 only with MySQL and needs to be compiled for Postgres support.  See
 http://techdocs.postgresql.org/  for some help.

Once PHP/Apache/Postgres is set up, phpPgAdmin is easy ... you just
 copy it to a folder under your Web Root, and it works.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco