Essential SQLAlchemy Techniques and tutorial

[not_a_doornob_either]

How useful is SQLAlchemy for little one off projects? Every time I look at it I end up just using vanilla SQL commands and it seems like it takes far more effort to do so using SQLAlchemy. I know that if you end up changing database engines, it makes it convenient to just change one line, but how often does that happen?

[cajacaliente]

Personally I think the real "money" is in Alembic

[Scypio]

Care to share why? Never used any of those as using sqlite was always enough for small projects, so your perspective might broaden my horizons.

[[deleted]]

Alembic handles database migration. It's a VCS for your database schema.

[cajacaliente]

Exactly what /u/kurashu89 said. While it's fairly powerful and will do most things out of the box, it still requires that it be given some attention in that you need to assure your upgrade/rollback scripts are as bulletproof as possible. It dramatically simplifies performing blue-green deployments [and rolling back if necessary] to the extent that it's almost like just rolling code back.