{"uri":"https://octothorp.es/","term":"sqitch","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":null,"description":null},{"uri":"https://justatheory.com/2012/11/changing-sqitch-ids","title":"Thinking about Changing Sqitch Change IDs","description":null},{"uri":"https://justatheory.com/2013/08/data-deployment-with-sqitch","title":null,"description":null},{"uri":"https://justatheory.com/2012/06/sqitch-vcs-again","title":"Sqitch: Back to the VCS","description":null},{"uri":"https://justatheory.com/2012/09/sqitch-symbolism","title":"Sqitch Symbolism","description":null},{"uri":"https://justatheory.com/2014/09/sqitch-goes-vertical","title":"Sqitch Goes Vertical","description":null},{"uri":"https://justatheory.com/2013/09/sqitch-templating","title":"Sqitch Templating","description":"Last week saw the v.980 release of Sqitch, a database change management system. The headline feature in this version is support for MySQL 5.6.4 or higher. Why 5.6.4 rather than 5.1 or even 5.5? Mainly because 5.6.4 finally added support for fractional seconds in DATETIME columns (details in the release notes). This feature is essential for Sqitch, because changes often execute within a second of each other, and the deploy time is included in the log table’s primary key."},{"uri":"https://justatheory.com/2012/08/sqitch-depend-on-it","title":"Sqitch: Depend On It!","description":null},{"uri":"https://justatheory.com/2014/01/templating-tests-with-sqitch","title":"Templating Tests with Sqitch","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/07/sqitch-almost-usable","title":"Sqitch Update: Almost Usable","description":null},{"uri":"https://justatheory.com/2012/12/sqitch-rebase","title":"Sqitch Update: All Your Rebase Are...Never Mind","description":null},{"uri":"https://justatheory.com/2025/01/sqitch-1.5.0","title":"Sqitch 1.5.0","description":"Sqitch v1.5.0: out now in all the usual places!"},{"uri":"https://justatheory.com/2018/10/flaked-brewed-and-docked","title":"Flaked, Brewed, and Docked","description":"Sqitch v0.9998: Now with Snowflake support, an improved Homebrew tap, and the quickest way to get started: the new Docker image."},{"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/05/dbi-in-sqitch","title":"Use of DBI in Sqitch","description":"Sqitch uses the native database client applications (psql, sqlite3, mysql, etc.). So for tracking metadata about the state of deployments, I have been trying to stick to using them. I’m first targeting PostgreSQL, and as a result need to open a connection to psql, start a transaction, and be able to read and write stuff to it as migrations go along. The IPC is a huge PITA. Furthermore, getting things properly quoted is also pretty annoying — and it will be worse for SQLite and MySQL, I expect (psql’s --set support is pretty slick)."},{"uri":"https://justatheory.com/2013/07/upcoming-sqitch-improvements","title":"Notes on Upcoming Sqitch Improvements","description":null},{"uri":"https://justatheory.com/2013/01/sqitch-trust-but-verify","title":"Sqitch: Trust, But Verify","description":null},{"uri":"https://justatheory.com/2013/02/sqitch-homebrew-tap","title":"Sqitch Homebrew Tap","description":"If Sqitch is to succeed, it needs to get into the hands of as many people as possible. That means making it easy to install for people who are not Perl hackers and don’t want to deal with CPAN. The Sqitch Homebrew Tap is my first public stab at that. It provides a series of “Formulas” for Homebrew users to easily download, build, and install Sqitch and all of its dependencies."}],"bookmarks":[]}