Re: [GENERAL] Admin / client tools for Win32?

Hi Mat,

On Tue, 28 Dec 1999, Matthew Brown wrote:

> I have a web hosting client who wants SQL support, and is very used
> to using MSAccess with MS SQL Server with all the integration they have.

read: incompatibility in means of cross platform environments.

> Can anyone point me to good GUI Win32 tools for manipulating Postgres?
> Mostly what would be needed are database diagramming tools, etc.,
> but admin tools would be great, too.

You might try using the ODBC Driver kit for Postgres.
It performs well and it does the trick connecting a WIN32
Application to a Postgres Server.

One pitfall still exists: If you don´t define your
Primary keys well, MS-Access97 will cast out queries
like:
select blah from blub where
field1=... and field2=... and field3=... and fieldn or
field1=... and ... or
field1=...

Imagine what this does to your Postgres Server.
Here in our environment the postmaster inflates up to
40 Megs of Mem-Usage and drains all CPU even if
opening a table just for viewing.

SQL7.0 instead seems to optimize these
ridiculous queries quite well.

If you want the best cross platform utility you
might try pgaccess (it runs under TCL/TK) and
should run on WIN32 Clients as well.

> Did I hear a sideways recommendation of dbKit?

Never heard of it. What is it?

t++

--
This mail had been created using Linux. It is therefore free of all
Microsoft(tm) OS based virii, conforms with almost any widely recognized
open standards and is best read with *any* mailclient using fixed fonts.
Spam is processed at the modest price of $500 only at this site.