Strongly considering that maybe MediaGoblin should drop sqlite support and move to Postgres. Migrations are just too painful, and there are some nice features we could take advantage of if we moved to a postgres-only setup.
It's more the pain than the lure of features though. I wouldn't even be considering it if migrations weren't such a huuuuge nightmare.
My concern would be how much of an obstacle Postgresql presents to deployment, as it entails creation of a new 'postgres' user, starting of a daemon process, creation of a 'mediagoblin' postgresql user, and creation of a database.
Christopher Allan Webber likes this.
Yeah, you subclass Field and override db_type ;)
But can you do a join across tables using SQL where one of the parameters is the value of a specific key in a json field? Not a current Django feature... and I'm not sure how they'd do that with their current API.
Django's ORM is definitely easier, but the separation of concerns in SQLAlchemy is top notch.