Unfortunately there aren't many blogging softwares written in Python. You might find quite a lot using django etc., but i think Zine is the only blog which builds on top of the werkzeug+sqlalchemy stack. Another problem with Zine might be, that it ships its own database-module build on top of sqlalchemy, which abstracts quite a lot of the sqlalchemy API usage.
If you are new, I would suggest you to look at some werkzeug example applications. They are all straight-forward and therefore, the code might a bit easier to understand.
PS: And don't be afraid if the SQLAlchemy isn't up to date. SQLAlchemy is developed very rapidly and there are often some smaller API changes. You probably won't notice any difference between all the versions on the first look, but there might be a class which was moved to another package, or an argument which was removed or added... Unfortunately those changes might break your code, but i am quite sure that you will understand it without any problems (if you even notice the difference).
When you once start your own application, I would suggest you to open the latest reference manual page of sqlalchemy and use the techniques described there.