Pure Tcl for postgresql

On Thu, 29 Jan 1998 vale@aero.vmei.acad.bg wrote:
>
> Date: Thu, 29 Jan 1998 14:43:20 +0200 (EET)
> From: vale@aero.vmei.acad.bg
> To: pgsql-questions@postgresql.org
>
> Hi,
>   I've just put pgsql-0.1 in incoming directory. It is Tcl interface entirely
> written in pure Tcl. It is tested and working under Linux and Windows 95 and
> should work under any Unix, Windows NT and Macintosh :-)
>   But it doesn't work with pgaccess (for now) and doesn't support kerberos
> authentication :-(
>   It should support large object inteface but it is not tested because of
> error in postgresql v. 6.2.1. I think this will be fixed.
>     By,
>     V. Iliev
>
On Fri, 30 Jan 1998, Constantin Teodorescu wrote:
>
> Date: Fri, 30 Jan 1998 14:44:55 +0200
> From: Constantin Teodorescu <teo@flex.ro>
> To: vale@aero.vmei.acad.bg
> Subject: Re: PgAccess without libpgtcl.so
>
> vale@aero.vmei.acad.bg wrote:
> >
> > Hi,
> > My name is V.Iliev. I wrote pgsql package - Tcl interface to postgresql
> > written in Tcl. I test it and it is working under Windows 95 and Linux.
>
> It's just what I needed.
>
> > But it doesn't work with pgaccess.
>
> We would make it work !
>
> > I've made some modification to the
> > pgaccess and modified version is working (under W. and L.). pgsql and
> > modified pgaccess v. 0.62 can be reach at
> >   ftp://aero.vmei.acad.bg/pub/dbase/pgsql/pgsql
>
> For the moment I am away from my office and I would take it as soon as I
> would reach there.
>
> > I will be verry glad to hear your opinion.
>
> It's just the portability that I needed. It must be refined, tested and
> promoted along with PostgreSQL and PgAccess.
>
> --
> Constantin Teodorescu
> FLEX Consulting Braila, ROMANIA
>
On Wed, 4 Feb 1998, Constantin Teodorescu wrote:
>
> Date: Wed, 04 Feb 1998 17:13:20 +0200
> From: Constantin Teodorescu <teo@flex.ro>
> To: vale@aero.vmei.acad.bg
> Subject: Re: PgAccess in pure Tcl/Tk
>
> I downloaded the package and I have look a little into pgsql.tcl
>
> I think it's perfect !!!
>
> I didn't have the time to try it but it probably works.
>
> Did you try that version of PgAccess (0.62 modified) under Windows 95 ?
> Did it worked ?
>
> The changes are : package require ... right ?
>
> It would be perfect if PgAccess could run under Windows platform. Most
> people would love this feature. I didn't use Windows anymore.
>
> Keep up the good work and keep me informed if you will release new
> versions.
>
> All the best,
>
> --
> Constantin Teodorescu
> FLEX Consulting Braila, ROMANIA
>
On Wed, 4 Feb 1998, Constantin Teodorescu wrote:
>
> Date: Wed, 04 Feb 1998 19:31:04 +0200
> From: Constantin Teodorescu <teo@flex.ro>
> To: vale@aero.vmei.acad.bg
> Subject: Re:  Pgsql didn't work
>
> I have tried pgsql on a Linux RedHat 5.0 i386  (Tcl/Tk 8.0)
>
> After installing package, started tclsh
>
> % package require pgsql 0.1
> % set dbc [pg_connect somedatabase]
>
> Request was send to backend but it has closed the channel.
>
> I am working on a PostgreSQL 6.2.1
>
> Any suggestion ?
>
> --
> Constantin Teodorescu
> FLEX Consulting Braila, ROMANIA
>
On Thu, 5 Feb 1998 vale@aero.vmei.acad.bg wrote:
>
> Date: Thu, 5 Feb 1998 18:58:03 +0200 (EET)
> From: vale@aero.vmei.acad.bg
> To: Constantin Teodorescu <teo@flex.ro>
> Subject: Re: PgAccess in pure Tcl/Tk
>
> Hello,
>
> I just modify PgAccess 0.76 and it also working under W95 and Linux.
> Modified version is in ftp://aero.vmei.acad.bg/pub/dbase/pgsql/pgsql .
>
> Changes arn't 'package require ...' only. PgAccess (0.62 and 0.76) uses
> reentrance of C version of pgtcl (procedure that is argument to the
> pg_select comand uses pg_select!). This feature of pgtcl is not documented
> and it is consumming a lot of memory.
>
> I'm working on Linux with Tcl/Tk 8.0 and PostgreSQL 6.2.1.
>
> Now for your test with tclsh: pgsql uses default user 'postgres' and
> default authentication 'unauth' if they arn't specified; for postgreSQL
> 6.2.1 'unauth' is not allowed (by default). You must specify -user and
> -authtype for 'ident' authentication and -user, -password and -authtype
> for 'password' authentication.
>
> Bye,
> V. Iliev
>
>
On Thu, 5 Feb 1998, Teodorescu Constantin wrote:
>
> Date: Thu, 5 Feb 1998 21:16:18 +0200 (EET)
> From: Teodorescu Constantin <teo@flex.flex.ro>
> To: vale@aero.vmei.acad.bg
> Subject: Re: PgAccess in pure Tcl/Tk
>
> On Thu, 5 Feb 1998 vale@aero.vmei.acad.bg wrote:
>
> > Hello,
> >
> > I just modify PgAccess 0.76 and it also working under W95 and Linux.
> > Modified version is in ftp://aero.vmei.acad.bg/pub/dbase/pgsql/pgsql .
>
> Thanks.
>
> > Changes arn't 'package require ...' only. PgAccess (0.62 and 0.76) uses
> > reentrance of C version of pgtcl (procedure that is argument to the
> > pg_select comand uses pg_select!). This feature of pgtcl is not documented
> > and it is consumming a lot of memory.
>
> Ok. What about performance. Did you notify some performance decreasing ?
> I think it might be very small or none.
>
> > Now for your test with tclsh: pgsql uses default user 'postgres' and
> > default authentication 'unauth' if they arn't specified; for postgreSQL
> > 6.2.1 'unauth' is not allowed (by default). You must specify -user and
> > -authtype for 'ident' authentication and -user, -password and -authtype
> > for 'password' authentication.
>
> Got it.
> I will try again.
> Thanks a lot for your package. I appreciate it very much.
>
> all the best
>
>
On Fri, 6 Feb 1998 vale@aero.vmei.acad.bg wrote:
>
> Date: Fri, 6 Feb 1998 08:55:46 +0200 (EET)
> From: vale@aero.vmei.acad.bg
> To: Teodorescu Constantin <teo@flex.flex.ro>
> Subject: Re: PgAccess in pure Tcl/Tk
>
>
>
> On Thu, 5 Feb 1998, Teodorescu Constantin wrote:
>
> > Ok. What about performance. Did you notify some performance decreasing ?
> > I think it might be very small or none.
>
> The performance is nearly the same as with 'C' version of pgtcl lib.
>
> Bye,
> V.Iliev
>
>
On Sat, 7 Feb 1998, Constantin Teodorescu wrote:
>
> Date: Sat, 07 Feb 1998 12:35:48 +0200
> From: Constantin Teodorescu <teo@flex.ro>
> To: vale@aero.vmei.acad.bg
> Subject: Re: PgAccess in pure Tcl/Tk
>
> vale@aero.vmei.acad.bg wrote:
> >
> > On Thu, 5 Feb 1998, Teodorescu Constantin wrote:
> >
> > > Ok. What about performance. Did you notify some performance decreasing ?
> > > I think it might be very small or none.
> >
> > The performance is nearly the same as with 'C' version of pgtcl lib.
>
> please send all mails concerning PgAccess also to
> pgsql-interfaces@postgresql.org.
> There are a lot of people that would be happy to hear that PgAccess will
> be available on Windows 95.
>
> --
> Constantin Teodorescu
> FLEX Consulting Braila, ROMANIA
>

Now I'm working on large objects interface for postgresql v. 6.2 and 6.3
and new protocol for v. 6.3.

V.Iliev