Our great sponsors
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
I'd suggest searching for "Python Rest api framework" pick one and then search for tutorials that show you how to connect to a Postgres database with that framework, e.g. "FastAPI Postgres tutorial". Speaking of, I'm a big fan of FastAPI so I'd recommend that.
I've been able to use postgrest to provide an API for a flutter app. I used Keycloak for logging in and providing the json web token to the flutter app that postgrest then accepts. I think (but can't remember for sure) that it was this auth0 with flutter article I used, with small modifications to connect to Keycloak. I recall discovering a few design flaws with the approach, but I don't remember what they were. I was able to modify it to my satisfaction.