Thread: Clarification

Clarification

From
ashley
Date:
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.

Thanks-you

Ashley


Re: Clarification

From
Alain Toussaint
Date:
> 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


Re: Clarification

From
KuroiNeko
Date:
> 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


Re: Clarification

From
Alain Toussaint
Date:
>  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


Re: Clarification

From
KuroiNeko
Date:
> 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


Re: Clarification

From
Alain Toussaint
Date:
> > 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


RE: Clarification

From
Roger Wernersson
Date:
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

Re: Clarification

From
Tom Lane
Date:
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