Spending some time improving my SQL with a focus on MySQL and the file archive management tool I’ve been framing up.

I looked at SQL Server Express but given I’m more familiar with MySQL and there are limitations on SQL Server Express that might eventually bite I’,m sticking with the open source tool. SQLite looked interesting as well but a full featured server engine seems like a better idea for this piece of work.

I’m currently trying to work through the initial schema for the database. Looking at tables and relationships. This is significantly more complex than SQL layouts I’ve designed from the ground up and I’m doing the whole job here. Should be interesting.

Once I have the schema sketched out and have figured out how best to define the tables and relations I’ll be moving on to get some coding in. I expect to build most of the machinery into one or more C# DLLs with the UI in a separate assembly (not sure currently but probably WPF initially). I’ll likely have a side-car native DLL to handle things like volume serial numbers that aren’t directly accessible from C#.