Previously, Flatlogic web app generator allowed you to model a database schema from scratch. We received a lot of requests from our users who had already modelled DB schemas and found it inconvenient to manually remodel the schema in Flatlogic schema editor.
To eliminate this obstacle and increase our users’ satisfaction, we are introducing a new platform feature: Creating a web app from an SQL dump. The feature supports both Postgres and MySQL dialects and identifies tables and column types, also trying to discover relations based on index, reference and constraint information. “users” table is automatically added to the DB model to preserve web app user management functionality. If the “users” table already exists in the imported DB, the column lists of the two tables are merged. SQL import is invoked by simply uploading the SQL dump file, literally in one click.
We recommend that you choose “Structure only, no data” mode when dumping the SQL from your database; otherwise the data dump will result in unnecessary volume uploads which sometimes could be huge and even lead to upload failure.
After the successful file upload and schema import, the schema editor allows you to review and edit the schema, and correct names and column types in case those were not identified correctly by the SQL dump parser. Also you can add one-to-many (relation one) and many-to-many (relation many) relation types if such were not discovered automatically.
Flatlogic schema editor also allows you to extend your existing DB schema while keeping all the data intact by applying our generated migrations feature.
Enjoy this new feature and model Admin web apps for your existing database literally in one click!
Click here to learn more about upcoming features. Here you’ll see some info about Flatlogic plans and some points from the roadmap.