Since nobody here has answered you, I'd be interested to see what they came up with. I use MySQL for logging weather station data and events from my various security systems and sensors around the place. At present, I use a hodge-podge of PHP scripts to query it and do graphs using "Grafana". There has to be a better way.
It's a shame they don't do FileMaker for Linux. I wouldn't think it would take much to port it across, since Apple run it under Mac OS X. Many people who have been exposed to "proper" relational databases hate FileMaker and I admit that it does seriously mess with your mind when you are used to creating relational databases. Having said that, as a tool to quickly throw together a database (or a front-end to MS-SQL or MySQL), I've never found anything easier and quicker to use.
As with Access, FileMaker's biggest problem is that it sometimes allows people who shouldn't be messing with computers to create a huge, awful mess that is very expensive to and time consuming to fix!
Bookmarks