# PostgreSQL database (or flask integration)

**URL:** <https://forums.realmacsoftware.com/t/postgresql-database-or-flask-integration/37699>\
**Category:** RapidWeaver Classic\
**Created:** [February 23, 2021, 12:04am UTC](https://forums.realmacsoftware.com/t/postgresql-database-or-flask-integration/37699 "2021-02-23T00:04:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jabraham](https://avatars.discourse-cdn.com/v4/letter/j/5daacb/32.png) [@jabraham](https://forums.realmacsoftware.com/u/jabraham)\
**Post date:** [February 23, 2021, 12:04am UTC](https://forums.realmacsoftware.com/t/postgresql-database-or-flask-integration/37699/1 "2021-02-23T00:04:22Z")

</div>

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:

1. 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…

2. Some way to call Python API from a POST or a button, and

3. 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](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?

---

<div class="post-metadata">

**Author:** ![capetom](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/capetom/32/14351_2.png) [@capetom](https://forums.realmacsoftware.com/u/capetom)\
**Post date:** [February 23, 2021, 8:14am UTC](https://forums.realmacsoftware.com/t/postgresql-database-or-flask-integration/37699/2 "2021-02-23T08:14:16Z")

</div>

see this post…

> [@In an awkward place - suggestions please](http://forums.realmacsoftware.com/t/in-an-awkward-place-suggestions-please/37524/2):
>
> There is something in the pipeline from the maker of [platform](https://platform.barth-partners.com). CRUD with SQL data and fit with PHP7.2 + I am also using Kuler and running out of PHP-version.…

@jay is  
working on a CRUD stack which should work with PostgreSQL

---

<div class="post-metadata">

**Author:** ![jay](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/jay/32/15118_2.png) [@jay](https://forums.realmacsoftware.com/u/jay)\
**Post date:** [February 23, 2021, 9:20am UTC](https://forums.realmacsoftware.com/t/postgresql-database-or-flask-integration/37699/3 "2021-02-23T09:20:23Z")

</div>

Just to confirm what @capetom wrote:

I am currently developing a CRUD stack which will support MySQL, SQLite3 and Postgres.

---

<div class="post-metadata">

**Author:** ![dripple](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/dripple/32/20481_2.png) [@dripple](https://forums.realmacsoftware.com/u/dripple)\
**Post date:** [February 23, 2021, 3:19pm UTC](https://forums.realmacsoftware.com/t/postgresql-database-or-flask-integration/37699/4 "2021-02-23T15:19:22Z")

</div>

Adding content from forms into databases is even for RapidWeaver not a big deal. The existing stacks usually work on MySQL because it’s the most common database you’ll get with your hosting packages.

If you just need to get data from a user input, store it away and retrieve it later (CR), and don’t want to use MySQL and / or some of the advanced database stacks, then perhaps a combination of Form Snap / Form Loom by Yabdab and any of the Google Spreadsheet stacks might do the job.

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/system/32/25301_2.png) [@system](https://forums.realmacsoftware.com/u/system)\
**Post date:** [March 26, 2021, 1:19am UTC](https://forums.realmacsoftware.com/t/postgresql-database-or-flask-integration/37699/5 "2021-03-26T01:19:27Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
