Flask AppBuilder (FAB) is a rapid development env based on Flask which should make it easy to develop CRUD apps. I had a database model that I wanted to get a better UI for so I tested FAB for this. Here are some learnings while working with this.
FAB seams to need an id column as the primary key
The primary key column is not shown in the UI. FAB seams to assume that a id column is used that isn't shown. I had to add a id column to the table and use this as the primary key instead (not optimal...). Sidenote: I tried misc macOS tools to add a auto_increment id column (MySQL Workbench, TOAD, Sequal Pro etc.) but ended up installing phpMyAdmin locally instead. It seams to be the best tools around for MySQL/MariaDB only phpMyAdmin managed this in one go (without export/import to new tables).