What is ceODBC?
ceODBC is a Python extension module that enables access to databases using the
ODBC API and conforms to the Python database API 2.0 specifications with a few
exceptions. I have tested this on Windows against SQL Server, Access
and Oracle. On Linux I have tested this against PostgreSQL.
Where do I get it?
I recently had the need for accessing SQL Server and Access databases
and checked out the available options. The odbc module that comes with
the win32 extensions worked reasonably well but it had a number of
deficiencies and it was clear from the documentation that no further
work was intended. I then checked out mxODBC. It is a great module but
for my purposes the cost was too great to warrant purchasing it. I
decided to see how much effort writing my own module would take and
discovered that, with a copy of cx_Oracle as a starting point, the
effort was minimal. With the hope that this module might prove useful
to others as it already has to me, I am making this release. Any and
all feedback welcome.
I'm pleased to announce the 0.7.8 release of SQLObject.
What is SQLObject
SQLObject is an object-relational mapper. Your database tables are described
as classes, and rows are instances of those classes. SQLObject is meant to be
easy to use and quick to get started with.
SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite, and
Firebird. It also has newly added support for Sybase, MSSQL and MaxDB (also
known as SAPDB).
Where is SQLObject
News and changes:
News since 0.7.7
* Replaced calls to style.dbColumnToPythonAttr() in joins.py by name/dbName
lookup in case the user named columns differently using dbName.
* Minor correction in the tests: we fully support EnumCol in Postgres.
* MySQLConnection now recognizes Enum, Double and Time columns when drawing the
database scheme from DB.
* Minor fix in FirebirdConnection.fromDatabase.
* Fixed a bug with default field values for columns for firebird connection.
* Prevent a deadlock in declarative.threadSafeMethod() by not reacquiring
the class lock.
* Fixed a bug in col.createSQL().
* Fixed a bug in converting date/time for years < 1000 (time.strptime()
requires exactly 4 digits for %Y, hence a year < 1000 must be 0-padded).
* Changed string quoting style for PostgreSQL and MySQL from \' to ''.
For a more complete list, please see the news:
Oleg Broytmann http://phd.pp.ru/ phd(a)phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
itools is a Python library, it groups a number of packages into a single
meta-package for easier development and deployment:
itools.catalog itools.i18n itools.tmx
itools.cms itools.ical itools.uri
itools.csv itools.odf itools.vfs
itools.datatypes itools.pdf itools.web
itools.gettext itools.rest itools.workflow
itools.handlers itools.rss itools.xhtml
itools.html itools.schemas itools.xliff
itools.http itools.stl itools.xml
For the first time in a looong time we have tested itools on Windows.
Now itools installs and the unit tests pass.
As a side effect the "vfs.move" method (from "itools.vfs") now is
cross-platform (and faster).
There is a new, and simple, handler for Gzip files (in "itools.handlers").
The document type declaration (DOCTYPE) is correctly parsed now, by
both "itools.xml" and "itools.html". And an small bug has been fixed
in the (X)HTML sanitizer.
The CMS ("itools.cms") has a couple of enhancements. Now emails are
sent asynchronously; if sending an email fails, it will be tried again
The forum posts are now HTML instead of plain text. The HTML editor
is used to edit the posts, and the HTML is sanitized to avoid security
There are also several fixes: in the tracker, the calendar, and when
cut&paste a document in the same folder.
- Nicolas Deram worked on the tracker;
- David Hughes helped testing itools on Windows;
- J. David Ibáñez worked on itools.cms, itools.xml and the unit tests;
- Sylvain Taverne worked on the forum and fixed several bugs;
J. David Ibáñez
Itaapy <http://www.itaapy.com> Tel +33 (0)1 42 23 67 45
9 rue Darwin, 75018 Paris Fax +33 (0)1 53 28 27 88
What is PyQwt ( http://pyqwt.sourceforge.net ) ?
- it is a set of Python bindings for the Qwt C++ class library which
extends the Qt framework with widgets for scientific and engineering
applications. It provides a widget to plot 2-dimensional data and
various widgets to display and control bounded or unbounded floating
- it requires and extends PyQt, a set of Python bindings for Qt.
- it supports the use of PyQt, Qt, Qwt, and optionally NumPy or SciPy
in a GUI Python application or in an interactive Python session.
- it runs on POSIX, Mac OS X and Windows platforms (practically any
platform supported by Qt and Python).
- it plots fast: displaying data with 100,000 points takes about 0.1 s
(PyQwt with Qt-3 is faster than with Qt-4).
- it is licensed under the GPL with an exception to allow dynamic linking
with non-free releases of Qt and PyQt.
The most important new features of PyQwt-5.0.1 are:
- support for Qt-4.3, SIP-4.7, and PyQt-4.3
- support for the N-D array interface specification
( http://numpy.scipy.org/array_interface.shtml ).
- the iqt module also supports an interactive Python session without the
help of the GNU readline module.
- PyQwt is now part of the PyQt-Py2.5-gpl-4.3 binary installer for Windows
( http://www.riverbankcomputing.com/Downloads/PyQt4/GPL/ )
The most important bug fix in PyQwt-5.0.1 is:
- removal of a huge memory leak in the conversion from an array to a QImage.
1. Python-2.5, or -2.4.
3. PyQt-4.3, or PyQt-4.2.
3 SIP-4.7, or SIP-4.6.
4. Qt-3.3, or Qt-3.2.
5. Qt-4.3, or Qt-4.2.
6. Recent versions of NumPy, numarray, and/or Numeric.
Enjoy -- Gerard Vermeulen
This is a python module to help in delivery of mail to multiple
mailboxes, similar to procmail and the Perl module Mail::Sort. There is
necessarily some overlap with the email package bundled with Python but
this one is optimized for fast matching on headers and fast delivery,
and treats the body of the mail as just a string, i. e. there is no
specific MIME support. This is a free package, please see the file
available via pydoc.
New in release 20070718: documentation really is available :)
A realistic example of a delivery script using the module is included.
This line is completely ham.
After several days of work, I'm glad to announce the release of PyMTP
0.0.1! PyMTP provides a Python API for access MTP devices, such as
Creative MP3 players, some iRiver MP3 players, and so on.
PyMTP 0.1 is available at http://nick125.com/smedia/pymtp/pymtp-0.0.1.tar.gz
PyMTP requires for installation:
* Python 2.5 -or- ctypes manually installed
* Libmtp (PyMTP was developed around 0.1.5, but, some previous versions
To install PyMTP, run python setup.py install as root.
Note: I haven't tested PyMTP on Win32, due to the lack of having a Win32
machine available. Theoretically, it should work, providing that libusb,
libmtp, ctypes, and Python is installed.
Please send any feedback about PyMTP, include bug reports, feature
requests, and so on to me at nick(a)nick125.com
I have reserved an area at the Schoolhouse Pub for 9:30pm, so if people want
to meetup after the talks, we can disperse there. (Just look for area
reserved for Python Ireland).
More details on the wiki.
See you all there!
On 7/17/07, Vicky Lee <whykay(a)gmail.com> wrote:
> Hi All!
> All the places have been taken. For all those who still want to come, keep
> an eye out on the wiki, just in case if anyone decided that they cannot make
> It's at: http://wiki.python.ie/moin.cgi/PythonMeetup/August2007
> See you all there!
> /// Vicky
> On 7/16/07, Vicky Lee < whykay(a)gmail.com> wrote:
> > well, we are not using meetup.com and MickT tried to kick off using
> > upcoming.org. But did not take off. So the wiki will have to do.
> > On 7/16/07, Tim Kersten <irlkersten(a)gmail.com> wrote:
> > >
> > >
> > > On 7/16/07, Maciej Blizinski <maciej.blizinski(a)gmail.com> wrote:
> > > ...
> > > > On 7/16/07, Tim Kersten < irlkersten(a)gmail.com > wrote:
> > > > > The NDA won't have any effect on "our" talks though, right?
> > > >
> > > > I don't know if it's necessary to sign the NDA at all to participate
> > > > in the talk. Look at this:
> > > >
> > > > http://tinyurl.com/3ymvp8
> > > >
> > > > NDA declined and he's in.
> > > >
> > >
> > > Lol, nice. :-) I'll assume that either way is fine. It would be
> > > ridiculas if we couldn't talk about the talks ( i.e. unit testing).
> > >
> > > --~--~---------~--~----~------------~-------~--~----~
> > > You received this message because you are subscribed to the Google
> > > Groups "Python Ireland" group.
> > > To post to this group, send email to pythonireland(a)googlegroups.com
> > > To unsubscribe from this group, send email to pythonireland-unsubscribe(a)googlegroups.com
> > >
> > > For more options, visit this group at http://groups.google.ie/group/pythonireland?hl=en
> > >
> > > -~----------~----~----~----~------~----~------~--~---
> > >
> > >
> > --
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~
> > ~~ http://irishbornchinese.com ~~
> > ~~ http://www.python.ie ~~
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~ http://irishbornchinese.com ~~
> ~~ http://www.python.ie ~~
~~ http://irishbornchinese.com ~~
~~ http://www.python.ie ~~
Find a new release of python-ldap:
python-ldap provides an object-oriented API to access LDAP directory
servers from Python programs. It mainly wraps the OpenLDAP 2.x libs for
that purpose. Additionally it contains modules for other LDAP-related
stuff (e.g. processing LDIF, LDAPURLs and LDAPv3 schema).
Released 2.3.1 2007-07-25
Changes since 2.3.0:
* Support for setuptools (building .egg, thanks to Torsten)
* Support for matched values control (RFC 3876, thanks to Andreas)
* Fixed ldif (see SF#1709111, thanks to Dmitry)
SUP now separated by $ (method __str__() of classes
AttributeType, ObjectClass and DITStructureRule, thanks to Stefan)
* Added constant MOD_INCREMENT to support
modify+increment extension (see RFC 4525, thanks to Andreas)
With the recent establishment of the wiki page on python.org for those who
offer training services for the Python language, we now have 23 listed, worldwide.
Many of the trainers are individuals or small companies, and it can be hard to
get the attention of the big IT houses. While skill credentials and a
portfolio of past training gigs are important, perhaps one of the best
promoters is when someone has actually experienced one of your classes. They
gain insight into your speaking style, how you relate to the students and your
ability to explain complex technical subjects in an approachable way. No
class syllabus can convey that. The Python community has a valuable resource
that can give you the next best thing. Screencasting!
Screencasting is a multimedia creation that focuses on the instructor's
desktop, with voiceover guidance. It can be in the format of an online
slideshow, a guided sourcecode walkthrough or a follow-along interactive
session. They can be as long or short as you wish and they have opportunities
for branding, by using custom wallpaper behind your talks desktop and musical
Screencasts can be hosted on www.showmedo.com or, if done with a large font,
video.google.com. They can also be embedded in your website while hosted
elsewhere, as shown at:
You can learn more about the details with a talk series I put together:
Casting Your Knowledge, With Style
But perhaps you're really busy on current projects and short on time. Consider
arranging an audio interview about an upcoming seminar you're offering and
making it available as a podcast. Ron Stephens of Python 411 makes available
an excellent collection of podcasts and may be interested in hosting yours.
Unlike face-to-face presentation opportunities, screencasts/podcasts have the
additional benefit that they promote your training offerings while you're busy
on other gigs. It's almost like cloning yourself and having more time for
promotion. It's all about leverage.
Python Advocacy Coordinator
Two new Python usergroups are being organized!
= Arizona =
Michael March is starting a group for those in the Flagstaff/Phoenix/Tucson
region of Arizona. The first meeting to get organized will be held on *Monday
July 30th* at 6:30pm. Location is not yet set -- need input from potential
If you are interested, a mailing list and wiki page have been established:
And also a Meetup.com group, where you can sign up to receive automated
calendar reminders of group activities.
= North/South Carolina =
While there is an existing group TriZPUG for the Raleigh-Durham-Chapel Hill
region, a new group is being formed for the *Charlotte and North-Central South
Carolina area*. No meetings have yet been scheduled - to participate in
discussions join the Google Group:
= Other Groups =
There are 34 states with Python usergroups, leaving 16 without any Python
organizations at all -- and this is just in the United States. We would like
to encourage the formation of more groups worldwide. If you've been wishing
there were meetings near you, step forward and help initiate or revitalize
one. There are experienced organizers waiting to mentor you on the mailing list:
Usergroups are a lot of fun, a source of employment opportunities and a great
way to enhance your programming and teaching skills. The Python Software
Foundation and the experienced group organizers are ready to support you in
Python Advocacy Coordinator