Full Stack Flask, React, and Postgres, pt. 1
HTML-код
- Опубликовано: 25 ноя 2021
- 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.sqlalchemy.org/en/20/ 
Наука
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?🤦♂🙏
Thanks for the video and please keep up with the good work!
yeah, this was a great video and a huge help. you earned a like and a sub my friend
great video
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!
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 :)
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
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.
Great set of videos Chris...thanks!
What theme are you using in vscode?
Synthwave '84
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
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
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?
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
could you please make a video on flask backend ,react frontend ,microsoft sql server database
(stored procedure data )
what commands should i runto start the project
There had an error, but was able to solve by using postgresql:// instead of postgres://. Thank you.
does this use any kind of JWT token?
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
or any kind of tokens?
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
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.
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!
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.
So you’re keeping the baby in the parent directory? 🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣
When you start working with these tools, the other stuff seems silly... Unless you're working for an enterprise, I guess.
whats your font and theme?
Victor Mono and Synthwave '84
@@ChrisDeSilva thank you sir!
Githhub link?
This project will not start for me properly
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😭