The Ultimate Business Machine - Archives
List of Categories : Commentary * Database * Singapore * Technology * Travel *
Mon 18 Jun 2007
Luca and Maven
Category : Technology
I've updated Luca and Maven.
Luca is just a minor bug fix. (Thanks to Sam Pipe for spotting and reporting it).
But Maven has just gotten more useful and, maybe, a lot more usable. Maven is like CocoaMySQL, except that it works with the three popular SQL database types - MySQL, PostgreSQL and SQLite3, and it tries to provide a common interface for a user to work across all three.
I've added the ability to create and delete databases, and to switch between databases. With this in place, I'm finally able to do what I've been wanting to do for a long time - to drag and drop tables and field structures between databases, and across database of different types.
It's quite fun to be able to do this now. I'm going to see if this is going to help me build deeper database functionality into Luca a lot faster from now on.
With this version, I've added the ability to create and drop indexes. including primary, unique and non-unique keys.
Things to do next - Drag and drop contents (not just the structure) between databases of different types. Need also to handle the setting and editing of Null, Non-Null values, default values, compound keys and other constraints.