{"uri":"https://octothorp.es/","term":"databases","thorpes":[{"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/05/sqitch-dependencies","title":"Sqitch: Where to Define Dependencies?","description":null},{"uri":"https://justatheory.com/2013/08/data-deployment-with-sqitch","title":"Data Deployment with Sqitch","description":null},{"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/2012/06/sqitch-vcs-again","title":"Sqitch: Back to the VCS","description":null},{"uri":"https://justatheory.com/2012/05/evolving-sqitch-plan","title":"The Ever Evolving Sqitch Plan","description":null},{"uri":"https://justatheory.com/2009/04/database-change-management","title":"Some Thoughts on Database Change Management","description":"Database migration frameworks and ad-hoc solutions leave things…wanting. Herein lie some preliminary thoughts on how to solve this problem."},{"uri":"https://justatheory.com/2009/11/pgtap-best-practices","title":null,"description":"Last month I gave two presentations at the PostgreSQL Conference West. The first was a variation on Unit Test Your Database!, which I’ve now given about six times (and will at least two more times, including tomorrow night for Portland PLUG and in two weeks at the JPUG 10th Anniversary Conference). The second was a new talk, a 90-minute tutorial, called “pgTAP Best Practices.” And here it is (download and Slideshare). Enjoy!"},{"uri":"https://justatheory.com/2010/07/introducing-mytap","title":"Introducing MyTAP","description":"After some prodding from the MySQL Community Manager, some OSCON hacking yields tangible results."},{"uri":"https://justatheory.com/2011/09/dbix-connector-and-ssi","title":"DBIx::Connector and Serializable Snapshot Isolation","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/2009/05/more-on-database-testing","title":"More on Database Testing","description":null},{"uri":"https://justatheory.com/2009/09/dbi-connect-cached-hack","title":"Keep DBI's connect_cached From Horking Transactions","description":"I’ve been on a bit of a Perl hacking tear lately. In addition to knocking out Test::XPath last week, I’ve been experimenting with TAP::Harness sources, Template::Declare, Catalyst views, a new Module::Build subclass for building database-backed applications, and, last but not least, an IRC logging bot. Oh, and that application I’m working on for PGX with Quinn Weaver. So much is crowding my mind these days that I’m having trouble sleeping. Tonight I’m up late hacking to try to get some of this stuff out of my head."},{"uri":"https://justatheory.com/2019/06/sqitch-v1.0.0","title":"Sqitch v1.0.0","description":"After seven years of development and production database deployments, I finally put in the effort to release v1.0.0."},{"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."},{"uri":"https://justatheory.com/2013/04/sqitch-sqlite","title":"Sqitch: Now with SQLite Support","description":null},{"uri":"https://justatheory.com/2012/07/sqitch-almost-usable","title":"Sqitch Update: Almost Usable","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/2012/12/sqitch-rebase","title":"Sqitch Update: All Your Rebase Are...Never Mind","description":null},{"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/06/sqitch-steps-to-change","title":"Sqitch: Rename Step Objects and the SQL Directory?","description":"After all of the thinking and rethinking about how to manage a Sqitch plan, I am just about done with all the changes to make it all work. One of the changes I’ve made is that tags are no longer objects that stand on their own between change steps, but are simply names the refer to specific change steps. Not only is this much more like how a VCS thinks of tags (basically another name for a single commit), but it also greatly simplifies the code for iterating over a plan and updating metadata in the database."},{"uri":"https://justatheory.com/2012/04/postgres-use-timestamptz","title":"Always Use TIMESTAMP WITH TIME ZONE","description":null},{"uri":"https://justatheory.com/2009/03/why-test-databases","title":"Why Test Databases?","description":null},{"uri":"https://justatheory.com/2009/10/dbix-connector-updated","title":"DBIx::Connector Updated","description":null},{"uri":"https://justatheory.com/2013/07/upcoming-sqitch-improvements","title":"Notes on Upcoming Sqitch Improvements","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/2013/11/toward-a-database-uri-standard","title":"Toward A Database URI Standard","description":null},{"uri":"https://justatheory.com/2006/06/on-wine-webapps","title":"What Works and What Doesn't in Online Wine Applications","description":null}],"bookmarks":[]}