Horton

Thread

  1. Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

    Billy G. Allie <bill.allie@mug.org> — 2000-10-05T03:47:42Z

    Announce: First public release of PgSQL Version 1.0
===================================================

PgSQL v1.0 has been released.  This is the first public release of PgSQL.
It is available at http://sourceforge.net/projects/pgsql.

PgSQL is a package of two (2) modules that provide a Python DB-API 2.0
compliant interface to PostgreSQL databases.  The first module, libpq,
exports the PostgreSQL C API to Python.  This module is written in C and
can be compiled into Python or can be dynamically loaded on demand.  The
second module, PgSQL, provides the DB-API 2.0 compliant interface and
support for various PostgreSQL data types, such as INT8, NUMERIC, MONEY,
BOOL, ARRAYS, etc.  This module is written in Python and works with
PostgreSQL 6.5.2 or later and Python 1.5.2 or later.

PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all
SQL constructs, including sub-selects, transactions, and user-defined types
and functions. It is the most advanced open-source database available
anywhere More information about PostgreSQL can be found at the PostgreSQL
home page at http://www.postgresql.org.

Python is an interpreted, interactive, object-oriented programming lang-
uage.  It combines remarkable power with very clear syntax.  It has
modules, classes, exceptions, very high level dynamic data types, and
dynamic typing.  There are interfaces to many system calls and libraries,
as well as to various windowing systems (X11, Motif, Tk, Mac, MFC).  New
builtin modules are easily written in C or C++.  Python is also usable as
an extension language for applications that need a programmable interface. 
Python is copyrighted but freely usable and distributable, even for
commercial use.  More information about Python can be found on the Python
home page at http://www.python.org.

-- 
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    |

  2. Re: [INTERFACES] Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

    Peter Eisentraut <peter_e@gmx.net> — 2000-10-09T16:27:21Z

    Billy G. Allie writes:

> PgSQL v1.0 has been released.  This is the first public release of PgSQL.
> It is available at http://sourceforge.net/projects/pgsql.

Sounds interesting, but isn't "pgsql" an extremely unfortunate choice of
name, given that it's already used as an abbreviation for "PostgreSQL"?

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

  3. Re: Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

    Bruce Momjian <pgman@candle.pha.pa.us> — 2000-10-09T23:17:35Z

    I need to know how this is different than our current python interface,
PyGreSQL.

-- Start of PGP signed section.
> Announce: First public release of PgSQL Version 1.0
> ===================================================
> 
> PgSQL v1.0 has been released.  This is the first public release of PgSQL.
> It is available at http://sourceforge.net/projects/pgsql.
> 
> PgSQL is a package of two (2) modules that provide a Python DB-API 2.0
> compliant interface to PostgreSQL databases.  The first module, libpq,
> exports the PostgreSQL C API to Python.  This module is written in C and
> can be compiled into Python or can be dynamically loaded on demand.  The
> second module, PgSQL, provides the DB-API 2.0 compliant interface and
> support for various PostgreSQL data types, such as INT8, NUMERIC, MONEY,
> BOOL, ARRAYS, etc.  This module is written in Python and works with
> PostgreSQL 6.5.2 or later and Python 1.5.2 or later.
> 
> PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all
> SQL constructs, including sub-selects, transactions, and user-defined types
> and functions. It is the most advanced open-source database available
> anywhere More information about PostgreSQL can be found at the PostgreSQL
> home page at http://www.postgresql.org.
> 
> Python is an interpreted, interactive, object-oriented programming lang-
> uage.  It combines remarkable power with very clear syntax.  It has
> modules, classes, exceptions, very high level dynamic data types, and
> dynamic typing.  There are interfaces to many system calls and libraries,
> as well as to various windowing systems (X11, Motif, Tk, Mac, MFC).  New
> builtin modules are easily written in C or C++.  Python is also usable as
> an extension language for applications that need a programmable interface. 
> Python is copyrighted but freely usable and distributable, even for
> commercial use.  More information about Python can be found on the Python
> home page at http://www.python.org.
> 
> -- 
> ____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
> |  /|      | 7436 Hartwell     | Compuserve: 76337,2061
> |-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
> |/  |LLIE  | (313) 582-1540    | 
> 
> 
-- End of PGP section.


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

  4. Re: Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

    Vince Vielhaber <vev@michvhf.com> — 2000-10-09T23:29:33Z

    On Mon, 9 Oct 2000, Bruce Momjian wrote:

> I need to know how this is different than our current python interface,
> PyGreSQL.

Is this a product of pgsql.com?

Vince.

> 
> -- Start of PGP signed section.
> > Announce: First public release of PgSQL Version 1.0
> > ===================================================
> > 
> > PgSQL v1.0 has been released.  This is the first public release of PgSQL.
> > It is available at http://sourceforge.net/projects/pgsql.
> > 
> > PgSQL is a package of two (2) modules that provide a Python DB-API 2.0
> > compliant interface to PostgreSQL databases.  The first module, libpq,
> > exports the PostgreSQL C API to Python.  This module is written in C and
> > can be compiled into Python or can be dynamically loaded on demand.  The
> > second module, PgSQL, provides the DB-API 2.0 compliant interface and
> > support for various PostgreSQL data types, such as INT8, NUMERIC, MONEY,
> > BOOL, ARRAYS, etc.  This module is written in Python and works with
> > PostgreSQL 6.5.2 or later and Python 1.5.2 or later.
> > 
> > PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all
> > SQL constructs, including sub-selects, transactions, and user-defined types
> > and functions. It is the most advanced open-source database available
> > anywhere More information about PostgreSQL can be found at the PostgreSQL
> > home page at http://www.postgresql.org.
> > 
> > Python is an interpreted, interactive, object-oriented programming lang-
> > uage.  It combines remarkable power with very clear syntax.  It has
> > modules, classes, exceptions, very high level dynamic data types, and
> > dynamic typing.  There are interfaces to many system calls and libraries,
> > as well as to various windowing systems (X11, Motif, Tk, Mac, MFC).  New
> > builtin modules are easily written in C or C++.  Python is also usable as
> > an extension language for applications that need a programmable interface. 
> > Python is copyrighted but freely usable and distributable, even for
> > commercial use.  More information about Python can be found on the Python
> > home page at http://www.python.org.
> > 
> > -- 
> > ____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
> > |  /|      | 7436 Hartwell     | Compuserve: 76337,2061
> > |-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
> > |/  |LLIE  | (313) 582-1540    | 
> > 
> > 
> -- End of PGP section.
> 
> 
> 

-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================

  5. Re: Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

    Jeff MacDonald <jeff@pgsql.com> — 2000-10-10T11:58:05Z

    Nope, neigher PyGreSQL nor ""PGSQL"" are products of
Pgsql.com (aka PostgreSQL Inc)On Mon, 9 Oct 2000, Vince Vielhaber wrote:

> On Mon, 9 Oct 2000, Bruce Momjian wrote:
> 
> > I need to know how this is different than our current python interface,
> > PyGreSQL.
> 
> Is this a product of pgsql.com?
> 
> Vince.
> 

Jeff MacDonald,

-----------------------------------------------------
PostgreSQL Inc		| Hub.Org Networking Services
jeff@pgsql.com		| jeff@hub.org
www.pgsql.com		| www.hub.org
1-902-542-0713		| 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick  : bignose

  6. Re: Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

    Vince Vielhaber <vev@michvhf.com> — 2000-10-10T13:47:33Z

    On Tue, 10 Oct 2000, Jeff MacDonald wrote:

> Nope, neigher PyGreSQL nor ""PGSQL"" are products of
> Pgsql.com (aka PostgreSQL Inc)On Mon, 9 Oct 2000, Vince Vielhaber wrote:

I knew PyGreSQL wasn't but PgSQL appeared a bit misleading.  Thanks
for clearing that up.   I guess on the website I should call it
PgSQL - NA 

Vince.


> 
> > On Mon, 9 Oct 2000, Bruce Momjian wrote:
> > 
> > > I need to know how this is different than our current python interface,
> > > PyGreSQL.
> > 
> > Is this a product of pgsql.com?
> > 
> > Vince.
> > 
> 
> Jeff MacDonald,
> 
> -----------------------------------------------------
> PostgreSQL Inc		| Hub.Org Networking Services
> jeff@pgsql.com		| jeff@hub.org
> www.pgsql.com		| www.hub.org
> 1-902-542-0713		| 1-902-542-3657
> -----------------------------------------------------
> Facsimile : 1 902 542 5386
> IRC Nick  : bignose
> 
> 

-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================

  7. Re: [INTERFACES] Re: Announcing PgSQL - a Python DB-API 2.0 compliant interface to PostgreSQL

    Peter Eisentraut <peter_e@gmx.net> — 2000-10-10T15:54:07Z

    Bruce Momjian writes:

> I need to know how this is different than our current python interface,
> PyGreSQL.

> > PgSQL is a package of two (2) modules that provide a Python DB-API 2.0
> > compliant interface to PostgreSQL databases.

DB-API is the standard database interface for Python.  Kind of like
DBD/DBI for Perl.

The existing one is hand-crafted, kind of like the Pg Perl module.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/