Distractions

I've been looking into Swing data bindings. This is a distraction. My priority should be to get a basic working app, without worrying about the GUI. WindowBuilder looks like it can create a good enough graphical UI, which I can implement at a later date.

Legacy

This is a re-implementation of an existing project that uses Microsoft Access. I'd like to transition to the replacement app before my Microsoft 365 subscription is renewed. I'll almost certainly renew the subscription, as I make heavy use of OneDrive and MS Office is just better than the competition. But, much as I like Access (yes, really), it's not something I want to use for a "business critical" function.

The plan

To get the new app running PDQ I'll duplicate the database schema with HSQLDB, as mentioned in February, and create a simple command line interface in Groovy. Once the CLI is feature complete I'll add the GUI.

Reporting

I've shown Reporting as distinct from the business classes. I expect this will initially be a series for SQL stored procedure, run from SQuirreL SQL Client. These procedures will, hopefully, be very close to the existing Access queries. Merging them into the business classes will be pretty easy, but can be deferred until the bulk of the project is complete.

15-JUL-2020 👈 Top of page 👉 17-JUL-2020

Find me coding on GitHub, networking on LinkedIn, answering questions on Stack Exchange and hanging out on twitter.

Table of Contents

Distractions

Legacy

The plan

Reporting