I am now looking at integrating Google’s Protocol Buffers into ZODB. This means that wherever possible, ZODB should store a serialized protocol buffer rather than a pickle. The main thing my customer hopes to gain is language independence, but storing protocol buffers could open other possibilities as well. I think this is a very good [...]
Continue reading about Contemplating Integration of Protocol Buffers into ZODB
For those just tuning in: RelStorage is an adapter for ZODB (the database behind Zope) that stores data in a relational database such as MySQL, PostgreSQL, or Oracle. It has advantages over FileStorage and ZEO, the default storage methods. Read more in the ZODB wiki.
Download this release from PyPI. As I mentioned in another post, [...]
I’ve been working on packing a 6.5GB production database based on RelStorage and MySQL 5.0. It contains 6.4 million objects, meaning “select count(1) from current_object” returns 6426879. I would call this a moderately sized database. When I first approached it, it had not been packed for at least 3 months. At first, I could not [...]
After a lot of testing and performance profiling, on Friday I released RelStorage 1.1. On Saturday, I was planning to blog about the good news and the bad news, but I was unhappy enough with the bad news that I decided to turn as much of the bad news as I could into good news. [...]
I was interested in adding MySQL 5.0+ support to RelStorage, so I went ahead and did it. The code is in Subversion now.
The tests I’ve run suggest the MySQL adapter is already a lot faster than ZEO and both of the other adapters. The MySQL adapter has consistently finished the tests 40% faster [...]
I’m writing RelStorage, a new storage implementation for ZODB / Zope / Plone. RelStorage replaces PGStorage. I’ve put up a RelStorage Wiki page and the zodb-dev mailing list has been discussing it. There is no stable release yet, but a stable release is planned for this month.
While performance is not the main [...]