#databases

• Always Use TIMESTAMP WITH TIME ZONE

  https://justatheory.com/2012/04/postgres-use-timestamptz/

• VCS-Enabled SQL Change Management

  https://justatheory.com/2012/01/vcs-sql-change-management/

  Some thoughts on how to use VCS history to determine what changes need to be deployed or reverted without relying on a configuration file.

• How to Generate Recurring Events in the Database

  https://justatheory.com/2008/01/postgres-recurring-events/

  Going deep on using Postgres functions to create efficient recurring events.

• Sqitch Update: All Your Rebase Are...Never Mind

  https://justatheory.com/2012/12/sqitch-rebase/

• DBIx::Connector and Serializable Snapshot Isolation

  https://justatheory.com/2011/09/dbix-connector-and-ssi/

• Toward A Database URI Standard

  https://justatheory.com/2013/11/toward-a-database-uri-standard/

• My Catalyst Tutorial: Add Authors to the View

  https://justatheory.com/2009/11/sql-view-aggregate-magic/

• Sqitch — VCS-powered SQL Change Management

  https://justatheory.com/2012/04/sqitch-draft/

  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.”

• SQL Change Management Sans Duplication

  https://justatheory.com/2012/01/sql-change-management-sans-redundancy/

  Here’s how I propose to eliminate the duplication of code between deploy and revert SQL change management scripts.

• Multirow Database Updates

  https://justatheory.com/2013/09/multirow-database-updates/

• Sqitch Update: Almost Usable

  https://justatheory.com/2012/07/sqitch-almost-usable/

• Sqitch: Back to the VCS

  https://justatheory.com/2012/06/sqitch-vcs-again/

• What Works and What Doesn't in Online Wine Applications

  https://justatheory.com/2006/06/on-wine-webapps/

• Simple SQL Change Management

  https://justatheory.com/2012/01/simple-sql-change-management/

  I’ve been thinking a lot about SQL change management. I think I may finally have cracked this thing wide open.

Follow #databases on RSS or use the

curl -X GET \
  -H "Content-type: application/json" \
  -H "Accept: application/json" \
  "https://octothorp.es/~/databases"