NAME: pysqlite - Extension module for SQLite database.
DESCRIPTION: A Python-DB API Spec v2.0 compliant entension module that connects to SQLite databases.
SQLite is a powerful, embedded relational database in a compact C library. It supports a large subset of SQL92 and transactions. It has a simple C/C++ interface requiring only three functions to perform queries. It has TCL bindings and an ODBC driver. Sources are uncopyrighted and can be used for any purpose. More information can be found at http://www.hwaci.com/sw/sqlite/index.html.
USAGE: import sqlite
conn = sqlite.connect(db="db", mode=077) cursor = conn.cursor() SQL = "select genus, species, family, category, author1, rank " \ + " from calflora order by genus, species limit 10;"
cursor.execute(SQL)
for col in cursor.description(): print "\t %12s - %3s bytes" % (col[0], repr(col[3]))
row = cursor.fetchone()
while row != None: print "%14s, %15s, %19s, %8s, %25s" % tuple(row) row = cursor.fetchone()
SQL = "insert into calflora (family,genus,species) values(%s,%s,%s)" cursor.execute(SQL, ('weedus', 'itchus', 'maximus'))
conn.close()
HOMEPAGE: There is not much there yet at http://pysqlite.sourceforge.net
DOWNLOAD: But you can download it at http://www.sourceforge.net/projects/pysqlite
AUTHOR: Michael Owens owensmk@earthlink.net
LICENSE: BSD
NOTES: - Built and tested on Gentoo Linux
python-announce-list@python.org