Home Original page

ANN: PySQLite 0.1 released

Michael Owens owensmk at earthlink.net
Thu May 23 11:32:13 EDT 2002 
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 at earthlink.net>

LICENSE:
    BSD

NOTES:
    - Built and tested on Gentoo Linux
More information about the Python-list mailing list