The
Ultimate
Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog • Archive • Cutedge

by: Bernard Teo








Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

The Ultimate Business Machine - Archives

List of Categories : Database * Technology * Commentary * Singapore * Travel *

Mon 18 Jun 2007

Luca and Maven

Category : Technology/LucaAndMaven.txt

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.

Posted at 7:59AM UTC | permalink

Mac@Work
Put your Mac to Work

• Sivasothi.com? Now how would you do something like that?
• Weblogs. Download and start a weblog of your own.
• A Mac Business Toolbox
A survey of the possibilities
• A Business Scenario
How we could use Macs in businesses
• VPN Enabler for Mavericks
• MailServe for Mavericks
• DNS Enabler for Mavericks
• DNS Agent for Mavericks
• WebMon for Mavericks
• Luca for Mavericks
• Liya for Mountain Lion & Mavericks
• Postfix Enabler for Tiger and Panther
• Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

  • Apache 2 Web Server
  • Postfix Mail Server
  • Dovecot IMAP Server
  • Fetchmail
  • SpamBayes Spam Filter
  • Procmail
  • BIND DNS Server
  • DNS Agent
  • WebDAV Server
  • VPN Server
  • PHP-based weblog
  • MySQL database
  • PostgreSQL database

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.