Seeking an Agile Database Definition Language

Thursday, June 14th, 2007

The database schemas for my current project are getting hashed out, mostly in Visio. This is pretty but not very automatable. I’d like to see if we can follow a more agile, iterative approach to database development. In particular, I’d like to be able to check the database definition into source code control and build the whole thing, including database tables and sample databases for testing out of Ant. Requirements include:

  1. Supports (at a minimum) MySQL and Derby
  2. Can be read by Java and Python
  3. Allows for inserting of data for unit testing; i.e. not just table definitions

It also wouldn’t hurt if it could reverse engineer existing SQL databases.

I’m tempted to write my own, probably using XML, but surely someone has already done this? I haven’t found a lot though. What I’ve got so far are these, none of which really meet the requirements:
(more…)

Choosing a Bug Tracker

Tuesday, June 12th, 2007

So now that Hudson is up and running well, it’s time to install an issue tracker for the new internal project.

  • What I really want to use but probably don’t have the budget for: Jira
  • What I might get the budget for but probably not: FogBugz
  • What I really, really don’t want to touch with a ten foot pole: Bugzilla
  • What I’m willing to touch with a ten foot pole if I have to: Trac

Anything else I should consider? Anything that passes the no-P.O. test that’s actually pleasant to use?

Choosing a Continuous Integration Server

Saturday, June 2nd, 2007

I’ve been tasked with setting up a continuous integration server for a team Java project. Options are:

We don’t have a strong opinion about any of these. Anyone care to comment on which one we should use and why?

The Most Sensible License Agreement I’ve Seen in a Few Years

Tuesday, May 29th, 2007

From Delicious Library 1.6.4:

LICENSE AGREEMENT

DELICIOUS LIBRARY IS PROVIDED ON AN “AS IS” BASIS, WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, WITHOUT LIMITATION, WARRANTIES THAT THE PROGRAM IS FREE OF DEFECTS, MERCHANTABLE, OR FIT FOR A PARTICULAR PURPOSE.

which means… don’t sue us if something goes wrong!

Believe it or not, that’s it. Would that most payware licenses were this simple and obvious.

Polish Blog Spam

Tuesday, May 29th, 2007

There seems to be a small epidemic of blog spam coming in from apparently Polish sites. The comments take a variety of forms, but usually look something like this:

Thanks for very interesting article. btw. I really enjoyed reading all of your posts. It’s interesting to read ideas, and observations from someone else’s point of view… makes you think more. So please keep up the great work. Greetings

Sometimes they ask for permission to translate the article into Polish.

You may want to keep an eye out for these. Akismet seems to be missing a lot of them, and at first glance they seem like a real comment. However Googling some of the phrases makes it apparent that they’re spam. The exact wording varies.

NetBeans 6.0 M9 and JavaFX Script

Tuesday, May 22nd, 2007

Quick tip: if you’re playing with JavaFX Script, stick to NetBeans 5.5. The JFX plugin is pretty throughly broken in 6.0, as are several other unrelated features. 6.0 M9 is way too buggy to be used in production just yet.