We use RapidWeaver for websites, and Flask for web apps. Our backend database is PostgreSQL. I’d like to be able to combine them, so that our web apps can be embedded in pretty RapidWeaver websites, and so that I don’t have to write python code just to make a form to enter data, or a web table to display some data.
So, I guess I just need:
Some form plugin that can support PostgreSQL. I can’t find any, they all seem to be MySQL ?? I don’t mind if the RapidWeaver plugin mostly does the display, formatting, a and some validation checks, because…
Some way to call Python API from a POST or a button, and
Some way to render PostgreSQL data into a table or a page.
Another option would be some sort of CRUD system like EasyDB https://www.stack-its.com/stacks/easydb.php, so that a lot of the simple stuff (aka everything but the “business logic”) can be done in RapidWeaver without using Flask at all. Flask API calls would then just be for “Business Logic” (e.g. running some scientific algorithm).
Of course I can embed the Flask web app in frames in RapidWeaver. So, it’s not hard to get the various flask web apps inside of RapidWeaver. But, I’d like the forms, table displays, etc, to be formatted using a RapidWeaver plugin rather than writing dumb python code to format a table!
Finally, if I must use MySQL to get DB functionality in RapidWeaver, there is a foreign data wrapper for Postgres that allows Postgres to access MySQL tables, to provide compatibility with our other apps.
Does anyone have any advice for me? Is this whole thing just a dumb idea? Should I abandon RapidWeaver for any dynamic web app’s forms?