1

I am currently developing a flutter web app for tracking the information in students classes. The app is basically a task management app curated for students.

I have finished most of the flutter UI design, but my main issue now is connecting the web app with my intended database, postgresql . I have come to understand that I cannot connect a flutter web app directly to the postgres database. I plan to use python to run the functionality of the postgres database i.e python scripts to populate tables in the database etc.

The only solution I can think of is creating an API that can take user information from my flutter frontend and store it in my python-run postgres database. How could I achieve this, or what are alternative solutions for connecting the flutter UI to my postgres database?

Improve this question

1 Answer 1

Reset to default
3

Connecting a frontend application directly to a database is usually not a good idea. You will expose a lot of security concern within your application. What you are proposing right now is already a good option. Python is a good backend choice for a new project, do explore framework like Flask, FastApi (for creating API), and SqlAlchemy or Sqlmodel (for interacting with your database).

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.