Thread: front end

Hi all,

I'm new to this list, new to PostgreSQL, and new to UNIX.

I'm writing a front-end in REALbasic (RB) on Mac OS X for psql.  RB
comes with a psql plugin, but I find it unreliable and extremely
slow.  I needs one and a half hour to display 30,000 records of two
fields for instance.

Therefore I want to write my own 'connection code'.  I have achieved
a tcp/ip socket connection with the psql server yet, but I don't know
which characters psql expects next to feed it a password, user name,
and database name.  (Or even before that if you need to perhaps
request a session id or so.)

I spent several hours searching on the psql site, but didn't find the
specs on this.

Anyone?

Thanks,

Marc

"M. Bastin" <marcbastin@mindspring.com> writes:
> Therefore I want to write my own 'connection code'.  I have achieved
> a tcp/ip socket connection with the psql server yet, but I don't know
> which characters psql expects next to feed it a password, user name,
> and database name.  (Or even before that if you need to perhaps
> request a session id or so.)
> I spent several hours searching on the psql site, but didn't find the
> specs on this.

You must have missed
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/protocol.html

However, if REALbasic can link to C code conveniently, it would perhaps
be easier to set up a wrapper around libpq ...

            regards, tom lane