Slides for Keeping Your Database and PHP in Sync from php|tek 2008.
For those of you interested whether I’m writing this tool to release, check out dbMorph on SourceForge.
O’Reilly Radar – Insight, analysis, and research about emerging technologies.
- The Louvre of the Industrial AgeThis morning I had the chance to get a tour of The Henry Ford Museum in Dearborn, MI, along with Dale Dougherty, creator of Make: and Makerfaire, and Marc Greuther, the chief curator of the museum. I had expected a museum dedicated to the auto industry, but it's so much more than that. As I wrote in my first stunned... […]Tim O'Reilly
- Augmented reality as etiquette coachAlasdair Allen, author of Programming iPhone Sensors, says real-time facial identification -- the sort that pairs names and faces on the fly -- is closer than you might think. He expands on that topic and a number of others in this video interview. […]Mac Slocum
- Four short links: 30 July 2010The No-Twinkie Database -- These are all the Twinkie Denial Conditions described in my “Bad Game Designer, No Twinkie!” Designer’s Notebook columns. Each one is an egregious design error, although many of them have appeared in otherwise great games. A collection of "don't do this" for app designers. (via waxy) Cloud Privacy Heat Map (Forrester […]Nat Torkington
- Which social gaming companies are hiringDisney's announced purchase of Mountain View gaming startup Playdom, follows on the heels of EA's purchase of London-based Playfish last November. Based on active users, Zynga remains by far the biggest online social gaming company. But what other independent companies are growing? To see which companies are expanding, I used our data warehouse of […]Ben Lorica
- Facebook Mountain ("I wish I knew how to quit you")Facebook is an unstoppable force, rocketing to 500 million users, building a breakout software platform and hardwiring the web with "Like" buttons and single sign-on via Facebook Connect. This piece looks at the reasons why, even in the face of abysmal customer satisfaction levels that rank below the airline industry, the social networking giant […]Mark Sigal
© 2010 Maggie Nelson. All Rights Reserved.
This blog is powered by the Wordpress platform and beach rentals.
Dave Marshall
on May 23rd, 2008
@ 3:52 am:
How will your tool differ from something like DBDeploy, except for using XML?
Neil Garb
on May 23rd, 2008
@ 10:18 am:
Thanks for the great slides! We’ve been battling to get this right in our department for about 6 months now. We’ve got the code part down, but we’re still doing database updates and rollbacks manually.
On a related note, I devised a simple DB-based system to deploy (and sync) only those rows that have been marked as ‘approved’. If anyone is looking for a technique to do this, you can check it out at http://codecaine.co.za/blog/posts/quality-control-with-php-and-mysql/.
Maggie Nelson
on May 24th, 2008
@ 11:55 am:
Glad you asked, Dave! I was looking into DbDeploy when I was looking for a tool to do what I needed. The two big things that DbDeploy is missing are:
1. support for stored procedures
2. support for multiple branches of development
Dave Marshall
on May 25th, 2008
@ 8:30 am:
We just have the stored procedures in particular directorys and use phing to add them to the database.
I’ve never really got my head round branching changes to the schema. Procedures, triggers and views I can appreciate changing between branches and using our simple directory full of procedure scripts, we can branch and manipulate successfully.
But how do you add a schema change to the branch, but not the trunk? And then eventually merge back into the trunk? The schema in the trunk could have changed several times in between and so on. I suppose it depends on how you run the branches. We tend to run maintenance branches and every now and then a feature branch.
I’m not trying to be pedantic, it’s just something I’ve always struggled with. Maybe if I’d been lucky enough to get to your talk, things would be clearer :)