Clarification

As I've recieved some "interesting" emails to clarify:

I wish to run postgresql on a Linux (Slackware) server over a LAN.

The client must reside on Apple MacIntosh (12 of them)

I am not familair with any client that will allow this. I have no
problem with Linux or mac, I have very limited experience with
postgresql, though I am told mysql has no problem I am just considering
options beyond filemaker on a mac server.

ok,here goes,i tried to check if MacOS supported something like ODBC but
since i'm on a text only system and debian's lynx doesn't support
javascript (i have next to no disk space and Xfree would take too long...like
3 days or so...to compile anyway),i couldn't search apple's knowledge
base.

that said,PostgreSQL do support connection over the network and is quite
easy to compile (i tried both 6.5.X release as well as 7.0 on various
debian and slackware system),the only thing remaining to know is if
there's PostgreSQL ODBC-like drivers for MacOS and/or applications able to
work with PostgreSQL.

i'd be very interrested to know the details since after i bough my next
system,i will be in the market for an IMac-DV (which hopefully will run
OSX),there's some rather good special in our local newspaper (an IMac-DV
450 bundled with a Harman Kardon sound system going for less than $1000
USD).

Alain

the only thing remaining to know is if
there's PostgreSQL ODBC-like drivers for MacOS and/or applications able
to
work with PostgreSQL.

Not actually necessary. After all, make client part do what it's supposed
to- get user input and display server responses. Browser on Macs and
HTTP/CGI + PGSQL on the server will do in most cases.

(an IMac-DV
450 bundled with a Harman Kardon sound system going for less than $1000
USD).

Harman-Kardon? Wow! Provided that good H/K speakers cost at least $ 1K,
I'm just wondering, why so cheap? :)

--

Sniper's rifle is an extension of his eye. He kills with his injurious vision.

JM

Not actually necessary. After all, make client part do what it's supposed
to- get user input and display server responses. Browser on Macs and
HTTP/CGI + PGSQL on the server will do in most cases.

that too is an option but it would hurt me to have to insert 20K record or
something like that with a web browser.

(an IMac-DV
450 bundled with a Harman Kardon sound system going for less than $1000
USD).

Harman-Kardon? Wow! Provided that good H/K speakers cost at least $ 1K,
I'm just wondering, why so cheap? :)

maybe because it is/was a deal between Apple and HK to bundle some nice
sounding speakers with their computer and Apple got a Very good price due
to volume.

Alain

that too is an option but it would hurt me to have to insert 20K record
or
something like that with a web browser.

Hmmmm.... How ODBC driver is supposed to help with that? Upload a CSV or
FF file and run bulk insert with COPY.

maybe because it is/was a deal between Apple and HK to bundle some nice
sounding speakers with their computer and Apple got a Very good price due
to volume.

If bundled actually means built-in, then the only thing from H/K there is
the name :)

--

Sniper's rifle is an extension of his eye. He kills with his injurious vision.

JM

that too is an option but it would hurt me to have to insert 20K record
or
something like that with a web browser.

Hmmmm.... How ODBC driver is supposed to help with that? Upload a CSV or
FF file and run bulk insert with COPY.

with ODBC:

user load the database client app (spreadsheet,small database like access
or filemaker) and dump his content on the fat server.

without ODBC:

user hand off the csv file to the DBA.

maybe because it is/was a deal between Apple and HK to bundle some nice
sounding speakers with their computer and Apple got a Very good price due
to volume.

If bundled actually means built-in, then the only thing from H/K there is
the name :)

no idea at the moment,i don't think it's built in (there's no place to put
the speakers in the IMac) but i'll confirm that tomorrow.

Alain

You could of course try Java and JDBC as Java runs everywhere. Then you
could run your application on Mac, Windows and Linux as you see fit.

/Roger

-----Original Message-----
From: Alain Toussaint [mailto:nailed@videotron.ca]
Sent: den 6 december 2000 08:10
To: KuroiNeko
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Clarification

that too is an option but it would hurt me to have to insert 20K

record

or
something like that with a web browser.

Hmmmm.... How ODBC driver is supposed to help with that? Upload a CSV

or

FF file and run bulk insert with COPY.

with ODBC:

user load the database client app (spreadsheet,small database like access
or filemaker) and dump his content on the fat server.

without ODBC:

user hand off the csv file to the DBA.

maybe because it is/was a deal between Apple and HK to bundle some nice
sounding speakers with their computer and Apple got a Very good price

due

to volume.

If bundled actually means built-in, then the only thing from H/K there

is

the name :)

no idea at the moment,i don't think it's built in (there's no place to put
the speakers in the IMac) but i'll confirm that tomorrow.

Alain

ashley <ashley@SITCAS.com.au> writes:

I wish to run postgresql on a Linux (Slackware) server over a LAN.
The client must reside on Apple MacIntosh (12 of them)

What are you planning to write the client in?

If you haven't decided yet, one possibility is Tcl. It runs fine on
Macs. I'm not sure whether our libpgtcl interface would port easily
to Mac --- libpgtcl itself probably would, but it depends on libpq
which uses Unix-isms like select(). (Has anyone tried that?) However,
somewhere out there is a Tcl Postgres client library written entirely
in Tcl, and it would surely drop in and run on a Mac. I don't have a
URL at hand for that library, but I know it exists --- try checking our
mail list archives from a year or two back to see what you can turn up.

regards, tom lane