I have read the ‘Database classes overview’ in wxPython documentation.
I tried to follow the examples, but it seems that wxODBC classes are
not included in the wxPython package. When runtime, it says ‘module
wx.DbTable/wx.DbGridTableBase not found!’, but I import those modules
in my sources.
I am building a database application using PostgreSQL and Firebird last releases both along with Python 2.5.2 and
wxPython 2.8.9.1. I’m migrating from Clipper to these wonderfull and powerfull technologies.
Of course I have installed wxPython in my computer!
I"ve follow many of the examples in the wxPython DEMO and no problem have been araise, until I inmerse in wxODBC classes.
I have read the 'Database classes overview' in wxPython documentation. I tried to follow the examples, but it seems that wxODBC classes are not included in the wxPython package. When runtime, it says 'module wx.DbTable/wx.DbGridTableBase not found!', but I import those modules in my sources.
Python already has a standard API for accessing databases, there was no need to reinvent the wheel and add wrappers for the wx classes. (Also, support for the wx DB classes has been dropped in 2.9, so even if we did have Python wrappers for them they would be useless in the next release series.)
I am building a database application using PostgreSQL and Firebird last
There are modules available that implement the standard DB-API for both of these databases. The API is documented here: http://www.python.org/dev/peps/pep-0249/. There are also very useful tools like SQL Alchemy that provide powerful layers on top of the DB-API that are highly recommended.
···
--
Robin Dunn
Software Craftsman http://wxPython.org Java give you jitters? Relax with wxPython!
I have read the 'Database classes overview' in wxPython documentation. I tried to follow the examples, but it seems that wxODBC classes are not included in the wxPython package. When runtime, it says 'module wx.DbTable/wx.DbGridTableBase not found!', but I import those modules in my sources.
I am building a database application using PostgreSQL and Firebird last releases both along with Python 2.5.2 and wxPython 2.8.9.1. I'm migrating from Clipper to these wonderfull and powerfull technologies.
I have recently switched over to SQLAlchemy from another ORM tool to connect to a Firebird database. Some time ago I did a sample for this, which one day I will put on the wiki but it will still need a bit of cleaning up, will send it to you off line.
I have read the 'Database classes overview' in wxPython documentation. I tried to follow the examples, but it seems that wxODBC classes are not included in the wxPython package. When runtime, it says 'module wx.DbTable/wx.DbGridTableBase not found!', but I import those modules in my sources.
I am building a database application using PostgreSQL and Firebird last releases both along with Python 2.5.2 and wxPython 2.8.9.1. I'm migrating from Clipper to these wonderfull and powerfull technologies.
I have recently switched over to SQLAlchemy from another ORM tool to connect to a Firebird database. Some time ago I did a sample for this, which one day I will put on the wiki but it will still need a bit of cleaning up, will send it to you off line.
Werner
__________
I think it's only fair to warn you that SqlAlchemy may slow your application down some. I recently switched to it as well as SqlAlchemy is extremely flexible. I noticed that it loads slower than my original version did the first time I loaded it. If I load it again, the applications loads much faster. This leads me to believe that the OS must be caching some of the application somehow.
Regardless, SqlAlchemy is very cool and I hope to write about it soon as well.
I think it's only fair to warn you that SqlAlchemy may slow your application down some.
I noticed that it loads slower than my original version did the first time I loaded it.
Does it run noticeably slower, or just load slower?
If I load it again, the applications loads much faster. This leads me to believe that the OS must be caching some of the application somehow.
probably disk cache -- large python modules often load faster after the first time.
-Chris
···
--
Christopher Barker, Ph.D.
Oceanographer
Emergency Response Division
NOAA/NOS/OR&R (206) 526-6959 voice
7600 Sand Point Way NE (206) 526-6329 fax
Seattle, WA 98115 (206) 526-6317 main reception
I think it's only fair to warn you that SqlAlchemy may slow your application down some.
I noticed that it loads slower than my original version did the first time I loaded it.
Does it run noticeably slower, or just load slower?
In my case it is just the load very it is noticeable slower the first time. Especially with a large model.py (or whatever one calls it, which contains all the table definitions), I guess it might also be slower if one autoloads the table definitions from the database.
Werner
···
If I load it again, the applications loads much faster. This leads me to believe that the OS must be caching some of the application somehow.
probably disk cache -- large python modules often load faster after the first time.
I think it's only fair to warn you that SqlAlchemy may slow your application down some.
I noticed that it loads slower than my original version did the first time I loaded it.
Does it run noticeably slower, or just load slower?
The first time I ran it, it loaded slower and seemed to run slower too. The second time I ran it, it loaded and ran much quicker than my original implementation. I do autoload my tables from SQL Server, so that may be the issue. Not sure what the best approach is to making it faster...maybe caching some of the database data locally?
If I load it again, the applications loads much faster. This leads me to believe that the OS must be caching some of the application somehow.
probably disk cache -- large python modules often load faster after the first time.