From owner-freebsd-ports Thu Mar 14 20:30:22 2002 Delivered-To: freebsd-ports@hub.freebsd.org Received: from freefall.freebsd.org (freefall.FreeBSD.org [216.136.204.21]) by hub.freebsd.org (Postfix) with ESMTP id 907DD37B41C for ; Thu, 14 Mar 2002 20:30:00 -0800 (PST) Received: (from gnats@localhost) by freefall.freebsd.org (8.11.6/8.11.6) id g2F4U0H09961; Thu, 14 Mar 2002 20:30:00 -0800 (PST) (envelope-from gnats) Received: from gurudom.ramax.com (h24-68-240-50.cg.shawcable.net [24.68.240.50]) by hub.freebsd.org (Postfix) with SMTP id 226DC37B400 for ; Thu, 14 Mar 2002 20:25:35 -0800 (PST) Received: (qmail 91984 invoked by uid 1000); 15 Mar 2002 04:25:33 -0000 Message-Id: <20020315042533.91983.qmail@gurudom.ramax.com> Date: 15 Mar 2002 04:25:33 -0000 From: Alex Rodioukov Reply-To: Alex Rodioukov To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/35913: New port: The high perfomance Python adapter for PostgreSQL Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org >Number: 35913 >Category: ports >Synopsis: New port: The high perfomance Python adapter for PostgreSQL >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Thu Mar 14 20:30:00 PST 2002 >Closed-Date: >Last-Modified: >Originator: Alex Rodioukov >Release: FreeBSD 4.5-RELEASE i386 >Organization: ramax.com >Environment: System: FreeBSD netopia.io.sys 4.5-RELEASE FreeBSD 4.5-RELEASE #0: Mon Feb 4 13:21:59 MST 2002 root@bismark.io.sys:/usr/obj/usr/src/sys/NETOPIA i386 >Description: psycopg is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being very small and fast, and stable as a rock. The main advantages of psycopg are that it supports the full Python DBAPI-2.0 and being thread safe at level 2. >How-To-Repeat: >Fix: # This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # py-psycopg # py-psycopg/Makefile # py-psycopg/distinfo # py-psycopg/pkg-descr # py-psycopg/pkg-plist # py-psycopg/pkg-comment # echo c - py-psycopg mkdir -p py-psycopg > /dev/null 2>&1 echo x - py-psycopg/Makefile sed 's/^X//' >py-psycopg/Makefile << 'END-of-py-psycopg/Makefile' X# New ports collection makefile for: py-psycopg X# Date created: 14 March 2002 X# Whom: Alex Rodioukov X# X# $FreeBSD$ X# X XPORTNAME= psycopg XPORTVERSION= 1.0.5 XCATEGORIES= databases python XMASTER_SITES= http://initd.org/pub/software/psycopg/ XPKGNAMEPREFIX= ${PYTHON_PKGNAMEPREFIX} XDISTNAME= psycopg-${PORTVERSION} X XMAINTAINER= simuran@shaw.ca X XRUN_DEPENDS= ${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base XBUILD_DEPENDS= ${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base XLIB_DEPENDS= pq.2:${PORTSDIR}/databases/postgresql7 X XUSE_GMAKE= yes XUSE_PYTHON= yes XGNU_CONFIGURE= yes X XALL_TARGET= sharedmods X XCONFIGURE_ARGS=--with-python=${PYTHON_CMD} \ X --with-postgres-libraries=${LOCALBASE}/lib \ X --with-postgres-includes=${LOCALBASE}/include/pgsql \ X --with-postgres-includes=${LOCALBASE}/include \ X --with-mxdatetime-includes=${DATETIME_INC} X XDATETIME_DEP= ${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py XDATETIME_INC= ${PYTHON_SITELIBDIR}/mx/DateTime/mxDateTime/ X XDOCSDIR= ${PREFIX}/share/doc/py-psycopg XEXAMPLESDIR= ${PREFIX}/share/examples/py-psycopg X XEXAMPLES= binary.py commit.py dictfetch.py dt.py first.py oid.py \ X somehackers.jpg threads.py usercast.py whereareyou.jpg \ X work.py X XDOCS= AUTHORS COPYING CREDITS ChangeLog FAQ NEWS README \ X RELEASE-1.0 SUCCESS TODO X XTEXDOCS= dbapi20programming.tex dbapiext.tex psycopg-guide.tex X Xdo-install: X ${INSTALL_PROGRAM} ${WRKSRC}/psycopgmodule.so \ X ${PYTHON_SITELIBDIR} X X.if !defined(NOPORTDOCS) Xpost-install: X ${MKDIR} ${EXAMPLESDIR} X.for file in ${EXAMPLES} X ${INSTALL_DATA} ${WRKSRC}/doc/examples/${file} ${EXAMPLESDIR} X.endfor X ${MKDIR} ${DOCSDIR} X.for file in ${DOCS} X ${INSTALL_MAN} ${WRKSRC}/${file} ${DOCSDIR} X.endfor X.for file in ${TEXDOCS} X ${INSTALL_MAN} ${WRKSRC}/doc/${file} ${DOCSDIR} X.endfor X.else XPLIST= ${WRKDIR}/PLIST.nodocs Xpre-install: X ${RM} -f ${PLIST} X ${GREP} -E -v '^(@dirrm )?(share/examples/)|(share/doc/)' \ X ${PKGDIR}/pkg-plist > ${PLIST} X.endif X X.include END-of-py-psycopg/Makefile echo x - py-psycopg/distinfo sed 's/^X//' >py-psycopg/distinfo << 'END-of-py-psycopg/distinfo' XMD5 (psycopg-1.0.5.tar.gz) = 35fe1ab56f4e6f3da721dae6d126f5be END-of-py-psycopg/distinfo echo x - py-psycopg/pkg-descr sed 's/^X//' >py-psycopg/pkg-descr << 'END-of-py-psycopg/pkg-descr' Xpsycopg is a PostgreSQL database adapter for the Python programming Xlanguage. It was written from scratch with the aim of being very small and Xfast, and stable as a rock. The main advantages of psycopg are that it Xsupports the full Python DBAPI-2.0 and being thread safe at level 2. X Xpsycopg is different from the other database adapter because it was designed Xfor heavily multi-threaded applications that create and destroy lots of Xcursors and make a conspicuous number of concurrent INSERTs or UPDATEs. XEvery open Python connection keeps a pool of real (UNIX or TCP/IP) Xconnections to the database. Every time a new cursor is created, a new Xconnection does not need to be opened; instead one of the unused connections Xfrom the pool is used. That makes psycopg very fast in typical client-server Xapplications that create a servicing thread every time a client request Xarrives. X XWWW: http://initd.org/software/psycopg X X- Alex Rodioukov END-of-py-psycopg/pkg-descr echo x - py-psycopg/pkg-plist sed 's/^X//' >py-psycopg/pkg-plist << 'END-of-py-psycopg/pkg-plist' X%%PORTDOCS%%share/doc/py-psycopg/AUTHORS X%%PORTDOCS%%share/doc/py-psycopg/COPYING X%%PORTDOCS%%share/doc/py-psycopg/CREDITS X%%PORTDOCS%%share/doc/py-psycopg/ChangeLog X%%PORTDOCS%%share/doc/py-psycopg/FAQ X%%PORTDOCS%%share/doc/py-psycopg/NEWS X%%PORTDOCS%%share/doc/py-psycopg/README X%%PORTDOCS%%share/doc/py-psycopg/RELEASE-1.0 X%%PORTDOCS%%share/doc/py-psycopg/SUCCESS X%%PORTDOCS%%share/doc/py-psycopg/TODO X%%PORTDOCS%%share/doc/py-psycopg/dbapi20programming.tex X%%PORTDOCS%%share/doc/py-psycopg/dbapiext.tex X%%PORTDOCS%%share/doc/py-psycopg/psycopg-guide.tex X%%PORTDOCS%%share/examples/py-psycopg/binary.py X%%PORTDOCS%%share/examples/py-psycopg/commit.py X%%PORTDOCS%%share/examples/py-psycopg/dictfetch.py X%%PORTDOCS%%share/examples/py-psycopg/dt.py X%%PORTDOCS%%share/examples/py-psycopg/first.py X%%PORTDOCS%%share/examples/py-psycopg/oid.py X%%PORTDOCS%%share/examples/py-psycopg/somehackers.jpg X%%PORTDOCS%%share/examples/py-psycopg/threads.py X%%PORTDOCS%%share/examples/py-psycopg/usercast.py X%%PORTDOCS%%share/examples/py-psycopg/whereareyou.jpg X%%PORTDOCS%%share/examples/py-psycopg/work.py Xlib/%%PYTHON_VERSION%%/site-packages/psycopgmodule.so X%%PORTDOCS%%@dirrm share/examples/py-psycopg X%%PORTDOCS%%@dirrm share/doc/py-psycopg END-of-py-psycopg/pkg-plist echo x - py-psycopg/pkg-comment sed 's/^X//' >py-psycopg/pkg-comment << 'END-of-py-psycopg/pkg-comment' XThe high perfomance Python adapter for PostgreSQL END-of-py-psycopg/pkg-comment exit >Release-Note: >Audit-Trail: >Unformatted: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message