Expected duration: less than 1 week We have got a project with a dynamic database, where tables are being constantly created based on a limited list of generic tables (Example: generic table name: "_customer_details", newly created table name "ABC_customer_details") with columns/properties fields. The database is MySQL.
Currently, we are handling the requests in PHP, and we are doing raw queries, and we are looking to migrate to python. We have tried Django dynamic models but to no luck, as there are some issues with MySQL not being DDL transactional.
We are looking for a recommendation on what other Python Web Framework we could use that will match our requirements, with a sample project solution that can: 1. Read data from dynamic tables. (_customer_details, _customer_orders - generic tables. ABC_customer_details, ABC_customer_orders, DEF_customer_details, DEF_customer_orders - Actual tables pre-existing in the DB) 2. Insert/Update the same dynamic tables. 3. Tables are not defined at runtime. (Only the generic tables) 4. Actual tables are already in the database, they don't need to be created from Python. 5. We have around 280 generic tables and 500 customers. (roughly 140 000 tables)