pysqlite - Extension module for SQLite databases.
A Python-DB API 2.0 compliant extension module that connects to
SQLite is a powerful, embedded relational database in a compact C
library. It supports a large subset of SQL92, multiple tables and indices,
transactions, and triggers. 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>.
conn = sqlite.connect("db")
cursor = conn.cursor()
SQL = """ select category, family, genus, species
from calflora order by genus, species limit 10"""
for col in cursor.description:
print "\t %12s - %3s bytes" % (col, repr(col))
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, ('itchus', 'ivious', 'posionious'))
Linux(source) and Windows (binary) downloads are available at
Gerhard Häring <haering_postgresql(a)gmx.de>
Michael Owens <mike(a)mikesclutter.com>
William Trenker <wtrenker(a)shaw.ca>
The following are changes and enhancements since the last release:
- Two new project members whose work has made this release.
- General code cleanup.
- Lots of bugfixes.
- Support for SQL NULL.
- Changed parameter quoting style from 'format' to nicer 'pyformat' style.
- Much better DB-API 2.0 compliance.
- Much improved documentation.
- A 'smart' result set class that allows the columns in a row to be accessed
by name (either dictionary-like or attribute-like) additional to list-like
- Reworked examples using the new features. One additional example for
mass-importing data from an XML file.
- Unicode support.
- SQLite is typeless. We added a possibility to overcome this limitation.
The types int, float, str and unicode are supported by default, but you
can add user-defined types.
- User-defined SQL functions and aggregates can be programmed in Python (!)
and registered to the connection.
- Better error handling and error messages.
- An extensive test suite.
- A homepage with preliminary documentation
- A users' mailing list.
- win32 binaries
A quick note to announce a new release of the SalStat statistics package,
written in Python and wxPython. The home page is http://salstat.sunsite.dk,
and downloads are available from http://salstat.sunsite.dk/download.html in
tar.gz and zip format.
SalStat is a small application for the scientific analysis of data and is
especially suited to sciences such as psychology.
This release is a consolidation and contains a few minor bug fixes and some
Alan James Salmoni
Twisted is an event-based framework for internet applications, written
in Python and licensed under the LGPL. For more information, visit:
or join the list at:
What's New since 0.17.4
0.18.0 is a major release, cleaning up many of the main APIs in
twisted.internet and moving us much closer to a 0.99.x series leading up
to Twisted 1.0.
- The networking core of Twisted - twisted.internet - was totally
refactored, cleaned up, documented and improved, using explicit
interfaces. The API is now much improved, and mostly stable. The main
change was to create an explicit reactor object, using which you can
schedule events, connect or listen on TCP/UDP/SSL ports, run methods in
a thread pool, and so on. The tools that come with Twisted have been
extended to allow choosing the reactor at runtime. Currently supported
are select(), poll(), GTK+, Qt, Win32 event API, and Java thread based
reactors, with wxPython and Tkinter support integrating with whichever
reactor is chosen.
- Perspective Broker, Twisted's remote object protocol, now supports
returning the equivalent of exceptions for failed remote method calls.
Additionally, resource limiting was added to the implementation.
- Applications can now be persisted to XML, using marmalade, a XML
pickle equivalent. This allows you to edit low level application
settings using a text editor.
- Added a sample IRC bot - it listens on a channel and logs it to a file.
- Improvements to twisted.mail - the SMTP server now has basic support
- Improvements to t-im, Twisted's instant messaging client.
- LDAP was moved out into a separate package:
- Many bug fixes, feature enhancements and additional documentatiom.
What is Twisted?
Twisted is an event-based framework for internet applications. It
includes a web server, a telnet server, a chat server, a news server, a
generic client and server for remote object access, and APIs for
creating new protocols and services. Twisted supports integration of the
Tk, GTK+, Qt or wxPython event loop with its main event loop. The Win32
event loop is also supported, as is basic support for running servers on
top of Jython.
Twisted currently supports the following protocols, all implemented in
pure python, most of them as both servers and clients:
- AOL's instant messaging TOC
- OSCAR, used by AOL-IM as well as ICQ (client only)
- Echo, discard, chargen and friends
- Twisted Perspective Broker
For more information, visit http://www.twistedmatrix.com, or join the
list at http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python