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 *

Tue 19 Dec 2006

Maven 0.3.5 Beta

Category : Technology/Maven0dot3dot5.txt

Maven now has the ability to create tables, delete tables, and add new table columns (for SQLite3, PostgreSQL 8.x and MySQL 5 databases).

It can also now delete and modify table columns (only for PostgreSQL 8.x and MySQL 5 because you can't delete table columns in SQLite).

Three more steps, and I'll be able to get Maven to where I want it to be :

1) create databases from scratch, 2) allow drag and drop of data and table structures between the three supported databases, and 3) to support a broadening of the things we can specify on the table structures - e.g., foreign keys, default values, and especially various types of constraints.

Then Maven will start to get useful.

If I can do that, then I can keep Luca focused solely on accounting (and take away all those database management functions) because the user can use Maven to move the data across any of the supported databases.

Also, Luca can just restrict itself to providing the standard accounting reports and, hopefully, I can develop Maven so that the user can do all sorts of ad-hoc analytical reporting on it.

That, at least, is where I'm hoping to go with these two projects.

If I can use Maven to help me design and organise the data structures quickly, then I might be able to work faster on the applications I plan to overlay on top of Luca from next year, e.g., inventory, invoicing, time billing, etc...

Posted at 9:39AM UTC | permalink

Put your Mac to Work 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.