Full Stack Flask, React, and Postgres, pt. 1
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2024
- Create a full stack application using Flask, PostgreSQL, and React. In this video, we'll set up our CRUD endpoints and test them using Postman.
SQLAlchemy docs: docs.sqlalchem...
![ถามตรงๆ กับ อาจตุพร ทำไม ประเทศไทย ใครเป็นนายก ก็โดนด่า พอออกเเล้วคนคิดถึง!!?? l [Nickynachat]](http://i.ytimg.com/vi/3YFLMXxBGAs/mqdefault.jpg)
Finally found a course that talks about all three and not just React and flask. Thank you
Great video man! You're video was done smartly and concisely, I really appreciate it!
This is the best tutorial I've found on this topic. Thanks so much Chris!
Please help me, have you tried the code steps on your own?🤦♂🙏
Hi, I'm getting and error: RuntimeError: Either 'SQLALCHEMY_DATABASE_URI' or 'SQLALCHEMY_BINDS' must be set. How do you get past this?
Did you ever sort this out
Did you figure it out?@@bigmack13
Thanks for the video and please keep up with the good work!
why you didn't use json dump(dumps) instead define format_event function?
I really don't understand how you are doing this without getting errors, I am now getting :RuntimeError: Working outside of application context. How do you get round all of this?
How did anyone get this to work, tables won't create, error messages everywhere, this is a nightmare for a beginner tutorial
Sounds frustrating. Hard to tell from the error messages alone without any other context. If you're just starting out, it's a great opportunity to lean on documentation. Check the Flask docs, search Stack Overflow for similar error messages, etc. It usually ends up being a small detail that got missed somewhere along the way. Super easy to do when following along with tutorials.
Super cute project idea :)
Also, it worked! I ended up using it for a database of my daughter's stuffed animals with images of each, and it's fantastic. All that's left is some bootstrapping and the manual labor of matching the photos.
HI, Instead of printing all the columns in GET request, How could I get only specific columns from the postgres table?
You'd just do SELECT {COLUMN_NAME_1}, {COLUMN_NAME_2} from TABLE instead of SELECT * from TABLE
Good video, but i think that middleware and backend is together, is a good option to pull apart the backend from middlware, for microservices, for example :)
There had an error, but was able to solve by using postgresql:// instead of postgres://. Thank you.
yeah, this was a great video and a huge help. you earned a like and a sub my friend
When I run POST and GET requests at localhost:5000/events, I get a 401 Unauthorized error. any ideas why?
Tricky to diagnose without a bit more detail but are you seeing any other error messages in the console. First thing that comes to mind is that you may have a CORS issue and may have simply missed that part of the setup. Happy to try to help troubleshoot further if you have more details/questions.
I'm sorry maybe I'm not understanding something but what is the purpose of having both sqlalchemy and psycopg2?
Sqlalchemy by itself is perfectly able to handle a postgress db.
This SO thread might help clear things up a bit: stackoverflow.com/questions/8588126/sqlalchemy-or-psycopg2
subscribed.
I went to fullstack javascript bootcamp, and used sequelize for database.
But just got a job that uses JS, Python, and SQL. This is the course I need to get up to speed. Saving this to follow along later. Thanks!
This is great, I'm having an issue with my model where the 'id' and 'created_at' default value are returning "null" - when I print "event" from the formatter method it just logs my description
While giving the db.create_all() for creating the 'event' table, I'm getting "Runtime error: Working outside of application context"
The way to resolve this is using 'application context' . I went through the documentation but couldn't figure out how the code would look like for this.
Please let me know if you could.
Without seeing the code you've got set up, this looks like it might point you in the right direction based on that error: flask.palletsprojects.com/en/2.3.x/appcontext/
You have to nest the db.create_all() inside a context block:
with app.app_context():
db.create_all()
Also make sure you declare the Event class before running create_all or it won't register in the database. I have no idea why it worked for him in the python shell without adding the context block. Probably something to do with the deprecation warnings, considering the video is almost 2 years old now. Still a good tutorial that helped me with ORMS!
great video
what commands should i runto start the project
can you show us how to deploy into AWS, Azure, DigitalOcean... or where ever? been having a hard time... getting front to talk to back correctly... even after building for production. Thank you
could you please make a video on flask backend ,react frontend ,microsoft sql server database
(stored procedure data )
Great set of videos Chris...thanks!
What theme are you using in vscode?
Synthwave '84
does this use any kind of JWT token?
Hi Chris,
Thanks for your video, so cool.
In your point of view, what is the best way to pass more than one value from the front to the back end . Like I would like to filter a table on multiple values.
Thank you
just use q object in flask
or any kind of tokens?
So you’re keeping the baby in the parent directory? 🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣
This project will not start for me properly
When you start working with these tools, the other stuff seems silly... Unless you're working for an enterprise, I guess.
Githhub link?
whats your font and theme?
Victor Mono and Synthwave '84
@@ChrisDeSilva thank you sir!
This is a great tutorial i must be sincere, but many of found it hard to setup Python with VS code powershell, you shouls have started from how you create your folders😭