I would like to use Pylons with Elixir, however, I am not sure what is the best way to get about doing this. There are several blog posts (cleverdevil, beachcoder, adam hoscilo) and even an entire new framework about how to go about doing this; however, I am not certain about the differences between them. Which one is the best to use? Am I going to run into issues using one over the other?
I would prefer not to have to use SQLAlchemy directly because of its verbosity and repetitiveness.
Personally, I'd go with beachcoder's recipe as updated here. That said, with the possible exception of Tesla (which I'm not familiar with), they're all lightweight enough that it should be easy to switch between them if you have any kind of trouble; all the hard work is in your model.
Graham Higgins wrote about a pylon's template for this (do we call them templates ? you know, the packages that get installed depending on what arguments you give to paster create...). I used it and it worked fine.
You may also want to check this discussion on pylons list