#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
JSON API
curl -X GET \
-H "Content-type: application/json" \
-H "Accept: application/json" \
"https://octothorp.es/~/databases"