{"uri":"https://octothorp.es/","term":"databases","thorpes":[{"uri":"https://justatheory.com/2012/05/sqitch-dependencies/","title":"Sqitch: Where to Define Dependencies?","description":null},{"uri":"https://justatheory.com/2012/05/sqitch-plan/","title":"Sqitch Update: The Plan","description":"I gave my first presentation on Sqitch at PGCon last week. The slides are on Slideshare and the PGCon site. It came together at the last minute, naturally. I was not able to pay as close attention to PGCon sessions as I would have liked, as I was doing last minute hacking to get the deploy command working on PostgreSQL, and then writing the slides (which are based on the tutorial). I was pleased with the response, given that this is very much a project that is still under heavy development and available only as a very very early alpha. There was great discussion and feedback afterward, which I appreciate."},{"uri":"https://justatheory.com/2012/04/postgres-use-timestamptz/","title":"Always Use TIMESTAMP WITH TIME ZONE","description":null},{"uri":"https://justatheory.com/2012/01/vcs-sql-change-management/","title":"VCS-Enabled SQL Change Management","description":"Some thoughts on how to use VCS history to determine what changes need to be deployed or reverted without relying on a configuration file."},{"uri":"https://justatheory.com/2008/01/postgres-recurring-events/","title":"How to Generate Recurring Events in the Database","description":"Going deep on using Postgres functions to create efficient recurring events."},{"uri":"https://justatheory.com/2012/12/sqitch-rebase/","title":"Sqitch Update: All Your Rebase Are...Never Mind","description":null},{"uri":"https://justatheory.com/2011/09/dbix-connector-and-ssi/","title":"DBIx::Connector and Serializable Snapshot Isolation","description":null},{"uri":"https://justatheory.com/2013/11/toward-a-database-uri-standard/","title":"Toward A Database URI Standard","description":null},{"uri":"https://justatheory.com/2009/11/sql-view-aggregate-magic/","title":"My Catalyst Tutorial: Add Authors to the View","description":null},{"uri":"https://justatheory.com/2012/04/sqitch-draft/","title":"Sqitch — VCS-powered SQL Change Management","description":"Back in January, I wrote three posts outlining some ideas I had about a straight-forward, sane way of managing SQL change management. The idea revolved around specifying scripts to deploy and revert in a plan file, and generating that plan file from VCS history. I still feel pretty good about the ideas there, and work has agreed to let me write it and open-source it. Here is the first step making it happen. I call it “Sqitch.”"},{"uri":"https://justatheory.com/2012/01/sql-change-management-sans-redundancy/","title":"SQL Change Management Sans Duplication","description":"Here’s how I propose to eliminate the duplication of code between deploy and revert SQL change management scripts."},{"uri":"https://justatheory.com/2013/09/multirow-database-updates/","title":"Multirow Database Updates","description":null},{"uri":"https://justatheory.com/2012/07/sqitch-almost-usable/","title":"Sqitch Update: Almost Usable","description":null},{"uri":"https://justatheory.com/2012/06/sqitch-vcs-again/","title":"Sqitch: Back to the VCS","description":null},{"uri":"https://justatheory.com/2006/06/on-wine-webapps/","title":"What Works and What Doesn't in Online Wine Applications","description":null},{"uri":"https://justatheory.com/2012/01/simple-sql-change-management/","title":"Simple SQL Change Management","description":"I’ve been thinking a lot about SQL change management. I think I may finally have cracked this thing wide open."}],"bookmarks":[]}