Tag: python
FirebirdDA : Firebird database adapter for Zope2
The trunk of django-firebird was updated with support for django 1.3
The svn trunk of django-firebird was updated with support for django 1.3
Please, feel free to try. Any feedback is welcome.
Initial release (0.7.0) of new Python driver for Firebird – FDB is ready for testing
As promised, FDB initial release (0.7.0) is out: http://pypi.python.org/pypi/fdb/0.7.0
It’s almost feature-complete (ready for 95% of users), but it could be
still buggy (it’s beta!), and the code wasn’t optimized for size and
speed. In all other ways it’s ready for wide testing.
What’s missing:
– Distributed transactions
– ARRAY support
– EVENTs support
– Stream BLOBs
– TRACE service
– Documentation (but you can use KInterbasDB one as FDB is as close to
it as possible).
– Python 3.x support (haven’t had time to test it, but it shouldn’t be
hard to make it work there)
What’s new since my last post here:
– Support for stored procedures (proper one according to Python DB API,
behaviour is the same as in KInterbasDB)
– Prepared Statements. It works in exactly the same way as in
KInterbasDB, i.e. you can use explicit PS via cursor.prep(), or use the
internal PS cached for all statements executed via cursor.execute() – it
will detect previously executed command and re-use prepared statement
(cached per cursor instance!).
– Fully implemented cursor.description attribute, i.e. including
precision for DECIMAL/NUMERIC fields. Should now return the same results
as KInterbasDB.
– trans_info/transaction_info and db_info/database_info calls like in
KInterbasDB.
– Better object dependency and lifetime management, so Python memory GC
should be much happier now. I modelled it as much as KDB does it as
possible.
Source code is also in Firebird Project’s Subversion repository:
(KInterbasDB source moved)
Sorry for GIT/Mercurial etc. fans, but Firebird project uses only SVN
for all its code (except old obsolete ones that are still in CVS) and it
would be pointless to create another type of repository for such a small
project. However, you’re free to set up mirrors or local repositories on
GIT or whatever 🙂
Merry Christmas to all
Pavel Cisar
IBPhoenix
[ED: if you want to know how easy is to use , or how compatible it is related to kinterbasdb , read this post ]
Python Firebird driver PyFirebirdSQL 0.6.5 is released with new documentation page and stored procedures fixes
The most important fix is callproc() is now implemented.
Here is the download page and the full changelog
Documentation page is located on github
http://nakagami.github.com/pyfirebirdsql/
python firebird driver pyfirebirdsql 0.6.2 is released
Here is the download page and the full changelog
For overview here is the short changelog:
Small changes list compensations
Hostname and user (from environ) send as is.
python firebird driver pyfirebirdsql 0.6.1 is released
Here is the download page and the full changelog
For overview here is the short changelog:
Added savepoint() and rollback to savepoint support (and tests)
Added _op_execute_immediate() operation
Services.getAttachedDatabaseNames() bugfix
Bugfix for python3
Correct file attibute for some py modules
pyfirebirdsql (Firebird driver for python 3.x) version 0.5 released
Please try new release 0.5.0
http://pypi.python.org/pypi/firebirdsql/0.5.0
Changelog includes :
- execute parameter bugfix.
- Added more tests.,
- fetchall() simplification
- use generators when fetching records.
- Support only for python > 2.5+
Firebird nagios plugin written in #python
At work we use a lot of Firebird databases, and so far our system admins checked the availability of a Firebird Database by simply trying to connect via telnet to the port 3050 and see if they would get a response. With this kind of check you can’t really determine if the database is really up and running,
Therefore they asked me if I could write a plugin for nagios which would do a real check to ensure that the Databases are up and running, here is my result.
I chose to write the plugin in python, due it’s simplicity, and because I already wrote some script using the python-kinterbasdb extension
pyfirebirdsql 0.4.1 – pure python driver released
pyfirebirdsql 0.4.1: pure python dbapi for firebird rdbms released new version with these changes:
-Python 2.5 support
-connect() dsn can set port number. ex) dsn=’example.com/3050:foo.fdb’
You read in the full commit log
Hajime Nakagami commented on firebird-python:
The most important reason to supoort Python2.5 is “Jython”.
Now 0.4.1 work on CPython 2.5+(include 3.x), IronPython and Jython.I have never test on PyPy