Postgres Pro
Downloads
Home   >   mailing lists

Thread: PGAccess Question

PGAccess Question

From
Richard Reyes
Date:
Can I run PGAccess in windows or is it using the libpqtcl library in linux.

Reason I'm asking is because the way pgaccess is set up It basically stores
everything in the database making pg access a quick an easy client/server setup.
 I believe that storing Forms and other objects in Access isn't that straight
forward including VBA forms.

Richard Reyes
llestat@ibm.net

Re: [INTERFACES] PGAccess Question

From
Tom Lane
Date:
Richard Reyes <llestat@ibm.net> writes:
> Can I run PGAccess in windows or is it using the libpqtcl library in linux.

PGAccess depends on the libpgtcl library.

The 6.4 version of libpq can be compiled for Win32.  So (in theory)
it ought to be pretty easy to build libpgtcl for Windows as well.
I don't have the tools or interest to do that, but perhaps someone
on the list can prepare Windows executables for libpq and libpgtcl,
and we could make them available for download from postgresql.org.

There is also a pure-Tcl client-side library available at the PGAccess
site, IIRC.  It's somewhat slower than libpgtcl/libpq but should run
almost anywhere.  I don't know how closely it duplicates the
functionality of libpgtcl ... close enough for PGAccess, presumably.

            regards, tom lane

Re: [INTERFACES] PGAccess Question

From
Sebastian Meyer
Date:
On Tue, 10 Nov 1998, Tom Lane wrote:

> Richard Reyes <llestat@ibm.net> writes:
> > Can I run PGAccess in windows or is it using the libpqtcl library in linux.
>
> PGAccess depends on the libpgtcl library.
> [...]
> There is also a pure-Tcl client-side library available at the PGAccess
> site, IIRC.  It's somewhat slower than libpgtcl/libpq but should run
> almost anywhere.  I don't know how closely it duplicates the
> functionality of libpgtcl ... close enough for PGAccess, presumably.

We use this "pure-Tcl client-side library" (pgsql.tcl, availiable on
Constantin's ftp site ftp://ftp.flex.ro/pub/pgaccess) to run Postgres apps
unmodified on Unix and Macs and really love it!

The only drawbacks are the missing support for large objects and for
crypted authentication. If you don't need these features (or feel you
could improve pgsql.tcl here) you might go this way.

sebastian
--
    __o     Sebastian Meyer   Tel: (0421)218-7702 | "Everything should be
  _ \<,_    meyer@mevis.de    http://www.mevis.de | made as simple as possible,
 (_)/ (_)   MeVis an der Universitaet Bremen      | but not simpler."
~~~~~~~~~~~ Universitaetsallee 29, D-28359 Bremen | - Albert Einstein