Using MySQL (in fact the MariaDB fork of MySQL) database, I want to design a user-friendly front-end – ideally using an HTML server.
More than CRUD: It's got to be able to do things like forms and subforms, i.e. be "client-facing". Rules out phpMyAdmin, MySQL Workbench, sqlYog, etc.
I've seen this: GUI MySQL database frontend: no solution then, but this was 2 1/2 years ago.
I've also found the LibreOffice Base idea... but of course this doesn't use an HTML server. I've tried this route and found that these forms didn't work very satisfactorily: buttons and textboxes lack the configurability of JQuery equivalents, for example.
The plan is to find a solution in Windows which can then be used in Linux. So not Kexi or Access.
Might Drupal be a possible answer? My impression is that this would mean much to learn before bearing any fruit.
After some thought and testing over a couple of days I have decided to try the Drupal route. The Wavemaker solution may work OK but I have sufficient doubts about the quality of the project and of the app for it to worry me. Drupal is much more widespread, more mature and probably represents a better investment for my time. It'll probably take a long time to get this relatively basic requirement (invoice forms with multiple entries, stuff like that) but it'll probably be interesting.