March 16, 2008 § Leave a comment
What is it:It is an open source library to automate web browser, controlling it from command line. It is written in Ruby.What’s the downside:It can only control IE. But worry not, there’s FireWatir. FireWatir can control Firefox in addition to IE.What are the alternatives:
- Watir Main Site
- FireWatir Main Site at Google Code
- Mechanize Python Main Site
- WWW-Mechanize Perl Main Site
March 2, 2008 § Leave a comment
What is this problem about:
This is actually MySQL error message. It means that there are no MySQL connections anymore.By MySQL default, idling database connections will be closed after 8 hours. Not having MySQL connections means that no SQL operations can be performed. SqlAlchemy is simple reporting the error.
When using SQLAlchemy, how to prevent such problems?
See sample code below:
engine = create_engine(db_path, pool_size = 100, pool_recycle=7200)
Take a look at the pool_recycle variable. That will configure SqlAlchemy engine to reconnect every x number of seconds. This easy solution makes sure the existence of MySQL connection.