Never knowingly knowing narwhals

Category Archives: SQLAlchemy

Beep My Stuff enters public Beta

Written by dazza on April 2, 2009 — 1 Comment

After a rather long period in closed beta I’ve opened Beep My Stuff to a public beta. Beep My Stuff is a web site that makes it FREE and easy to create an online library of your Books, Movies, Video Games and Music. Check it out, all feedback is much appreciated. It’s built with Turbogears, [...]

Also posted in Beep My Stuff, FreeBSD, PostgreSQL, Python, Software, TurboGears

SQLAlchemy-Migrate upgrade scripts in a transaction

Written by dazza on July 27, 2008 — 8 Comments

SQLAlchemy Migrate is a really good tool for managing database upgrades for SQLAlchemy centric projects. I’ve been using it for 6 months on New Metal Army and I haven’t had a screwed website upgrade yet! For those that don’t know SQLAlchemy-migrate allows you to version control database changes and easily upgrade and downgrade a database. [...]

Also posted in NewMetalArmy, PostgreSQL, Python, TurboGears

PostgreSQL, SQLAlchemy, Dropping all tables and sequences

Written by dazza on November 23, 2007 — 6 Comments

I’ve been working in deployment scripts for my current project and sometimes I need to drop all the tables and sequences from the database so I can create everything from scratch. I had been doing a   DROP SCHEMA public CASCADE; CREATE SCHEMA public AUTHORIZATION bob; GRANT ALL ON SCHEMA public TO bob;   This [...]

Also posted in PostgreSQL, Python, Software