Liquibase | Database Refactoring

In Database, Dev Tools, Open Source by bchesley0 Comments

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 bchesley0 Comments

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 …