Liquibase | Database Refactoring

In Database, Dev Tools, Open Source by bchesleyLeave a Comment

Database Change Management You never develop code without version control, why do you develop your database without it? Liquibase is an open source (Apache 2.0 Licensed), database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes are stored in a human readable yet trackable form and checked into source control. Liquibase …

Hivelogic – Installing MySQL on Snow Leopard

In Database, Dev Tools by bchesley2 Comments

Installing MySQL on Snow Leopard Monday, 31 August 2009 • Short URL • 0 comments These are instructions for compiling and installing a 64-bit version of MySQL, the world’s most popular open source database, on Mac OS X 10.6 (Snow Leopard). The benefits of manually building MySQL yourself in /usr/local are detailed here. I also wrote a in-depth explanation of …

Turning On Multiple Statements In ColdFusion 8 MySQL 4/5 Datasource

In CF Admin, CF Tips & Traps, Database by bchesleyLeave a Comment

This setting in CF Admin will give you grief if you are inserting a second command inside a CFQUERY tag to retrieve the last inserted record key. login to CF Admin select the DSN to edit display advanced settings in the Connection String edit field enter ‘allowMultiQueries=true’ save the settings You should be able to execute multiple SQL statements within …