Thread: 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. Thanks-you Ashley
> 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