zope at kevinkal
Apr 23, 2007, 8:46 AM
General Recommendations for a MySQL Connection
I could use a recommendation on connecting to MySQL databases. I'll
keep it short and say that we have a few apps now that connect to MySQL
and that have taking a 'wrong turn' in development. I think fulfilling
these requirements will solve our issues and keep the development on the
right path and I would greatly appreciate feedback.
1.) Provide a migration path to zope3. An application that provides a
connection object which can provide the same API for zope2/Five and
zope3(we're currently using zope 2.9.6/Five 1.4)
2.) Provide 1 connection which will also try to reconnect when accessed
if the connection has timed out, the server has restarted.
We're currently importing MysqlDB which I think I could genarlize a
bit. I've used the zope 2 mysqlDA in the past which has seemed pretty
stable, but is this the way to go if the plan is to eventually migrate
to zope3. I've also looked at zalchemy which I think could also be
used to provide a utility with a connection pool, but seems to be more
than what we need right now.
Again, any input is greatly appreciated.
Zope-DB mailing list
Zope-DB [at] zope