Web Development with Python Tutorial - Flask & Dynamic Database-Driven Web Apps

[@jovianhq]

We hope you enjoy this tutorial, and we look forward to seeing what you'll build! If you'd like to get your project reviewed by our team & earn a certificate, register here for free: jovian.com/learn/web-development-with-python-and-flask If you have any questions or face issues, please post them in the comments and we'll help you out. Do check out our KZbin channel as well, where we're posting new tutorials every week. Thanks @freecodecamp and Beau for hosting us! 🙏🏼

[@officialmoai3107]

Thanks!

[@bosserichie5578]

I am stuck at the function "def load_jobs_from_db()". I keep getting "TypeError: cannot convert dictionary update sequence element #0 to a sequence"... Little help here please...

[@mariadelendik7722]

@@bosserichie5578 Good day everyone. I want to express my deep gratitude to the author of the course for the work done. Thank you, your course is very informative. I'm having some problems in the code at 4:20. I understand that this is due to the fact that the version of the SQLAlchemy is 2.0.4. Solved it like this: def add_application_to_db(job_id, data): a=data["full_name"][0] b=data['email'][0] c=data["linkedin_url"][0] d=data['education'][0] e=data['work_experience'][0] f=data['resume_url'][0] with engine.connect() as conn: conn.execute(text(f"INSERT INTO applications (job_id, full_name, email, linkedin_url, education, work_experience, resume_url) VALUES ({job_id}, '{a}','{b}','{c}', '{d}', '{e}', '{f}')")) At the same time, in the "app.py" file, you need to change the dictionary to: "data = request.form.to_dict (flat = False)" because Flask returns a dictionary of the "ImmutableMultiDict" type, and we need a simple dictionary() All success in your studies!

[@jovianhq]

@@bosserichie5578 Try asking this question on the course discussions page, our team will reply: jovian.com/learn/web-development-with-python-and-flask/discussions

[@paulcal3500]

​@@jovianhq Hi, I am new to using replit. I followed exactly what you did but am getting this error: "sh: line 1: python: command not found exit status 127" Any idea how to fix this?

[@parrobo]

You are a super teacher. I wish we could teach students in the University in such granularity and functionality. There is no point dumping boring theories onto students' brain about www, HTTP, etc. Tutorials like this puts everything into context. Well done and thank you so much for making and sharing these contents.

[@ggggggg98767]

what a tutorial, started from zero, by the end got almost everything, on my way of building personal projects with obtained skills and knowledge!!

[@swastiksharma7637]

For those facing issue related to the TypeError while appending the row in the result_dict at 2:56:00 can use result_dicts.append(row._mapping), i was also facing this issue wasted around 2 Hrs to figure it out!

[@macchiato1083]

You made my day! I was looking to why I was having this error and I looked online but I could not get around it. Thanks a bunch!

[@kimdiane4680]

wow thank you so much!!!! You help me a lot ;)

[@Bic-Jin]

👍👍👍

[@DilshadHussainDH]

bhai bhai bhai!!!! :) Thank You!!

[@aryanthombre2971]

thanks a lot man that really helped

[@SreevathsaBV]

This is gold! The flow was absolutely flawless and understood without having to rewind and watch. Great stuff! 👌

[@jovianhq]

Thanks, we're glad you liked it!

[@banabasejiofor7470]

For those experiencing some issues around 3:29, this worked for me def load_job_from_db(id): with engine.connect() as conn: result = conn.execute( text(f"SELECT * FROM jobs WHERE id={id}") ) rows = [] for row in result.all(): rows.append(row._mapping) if len(rows) == 0: return None else: return row

[@haniyrasul6710]

Thanks for the code! For my case, I had to modify the last part. You saved the day. Cheers! rows = result.all() if len(rows) == 0: return None else: return dict(rows[0]._asdict())

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image

[@AbuRayhanSushmoy]

This worked well for me, def load_job_from_db(id): with engine.connect() as conn: result = conn.execute( text("select * FROM jobs WHERE id= :val"), {"val": id} ) rows = result.all() if len(rows) == 0: return None else: return rows[0]._asdict()

[@pukhrajkumawat7570]

If you don't get proper dictionary @3:26:50 here is the function that worked for me: def load_job_from_db(id): with engine.connect() as conn: result = conn.execute(text("SELECT * FROM jobs WHERE id = :val"),{'val': id}) row = result.fetchone() return row._asdict()

[@yashumaria]

Thanks :)

[@minhajmasood5706]

Hey thanks for the solution however, a small edit to your snippet did the magic for me: def load_work_from_db(id): with engine.connect() as conn: result = conn.execute(text("SELECT * FROM work WHERE id = :val"),{'val': id}) row = result.fetchone() if row: return row._asdict() else: return None Thing that is a bit confusing to me is why on earth the original code doesn't work. I mean it seems to be working when the Prof is writing it but when I followed his methods it won't work for me. Anyhow Thanks for sharing your solution!

[@sahilsarvade4346]

@@minhajmasood5706 thanks for the fix . i was struggling so bad because of this

[@prakharpandey7745]

4:21:16 if anyone's facing issues where the data is not being inserted into the database, even though there's no errors in your code, then write conn.commit() after the conn.execute() command.

[@nambativepeter8514]

Aakash has been a very big blessing to my career. I had an interview and somehow passing Algorithms through code challenges was difficult. But the moment i lay hold of Aakash tutorial on Data structures and algorithms. After going through the course this time i went into the test and came out successful. Thank you Co-founder of Jovian Aakash

[@jacktoneclarance5792]

If you're stuck at 2:56:09 this worked fine for me: with engine.connect() as conn: result = conn.execute(text("select * from jobs")) result_dicts = [] for row in result.all(): result_dicts.append(dict(row._mapping)) print(result_dicts)

[@proytookhdutta32]

Dhanyawad Mitra!

[@Bic-Jin]

👍👍

[@juwonlosiyanbade6320]

You're my hero! Let's just say I should have checked the comments 2 hours ago

[@joelfernandez5141]

Thank you bro

[@zariarogers2846]

Thank you!

[@Matty100]

Thank you Aakash and freeCodeCamp for taking the time to create and share this video it was a great walk through for flask and mysql in the cloud!!

[@chillaxbaap]

at 2:55:20 if you are stuck with dict( ) conversion, try using ._asdict() method Apparently it will be like first_result_dict = result_all[0]._asdict()

[@EngrMMI]

thanks DeeJay

[@coding_world_live9]

Thanks man

[@keotshepileditlhage288]

How did you manage to push your work to GitHub?

[@dalidasha_]

Thank you!

[@brindaayshwaryalaxmi]

this really works people can use this as alternate

[@johngodoy2929]

First, I'd like to say this is one of the most fluid and well explained coruses i've ever taken

[@jovianhq]

Thanks, we're glad you enjoyed the course!

[@de-frag0121]

This was absolutely amazing, built a fully packaged website with dynamic data and email linked, basically everything

[@jovianhq]

Thanks! There's definitely a lot more to web development that we haven't covered here, but we wanted to demonstrate that the end-to-end process of a fully functional website isn't as long or hard as it seems. 🙂

[@de-frag0121]

@Jovian Absolutely, but for a starter guide this covered tons of features. I was able to build a well packaged web just by following your tutorial. Thanks again and keep up the great work 👍

[@rizvy99]

@@jovianhq law, cantonment, religious theology, business naming, economy, history, literature, surrounding flora and fauna is related to all Jews mastermind game, why we need to disguise or mockery that we are different. the thing is everyone is on the same page

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image

[@tekghimire7078]

I gained more knowledge from you than I did from my entire college web development course. Thank you, sir.

[@Chitranshu0]

This Course is the best ! NO Questions, But very Out Dated!

[@mariumbegum7325]

The fact that this is available is fantastic!

[@ajaykuchhadiya5812]

I usually don't comment on videos but this one is super helpful. cheers to you man , This was flawless

[@penujahansith2688]

The course is really cool. the best tutorial for flask for beginners

[@jamesosewe7296]

Wow ! Wow ! Wow ! Wow !!! This is just absolutely fantastic. This is a whole career

[@rajuljha]

By far the best tutorial I have seen, explaining the end to end workflow and resolving errors on the go. Thank you so much FreeCodeCamp and Aakash!!

[@prajwalm.s7976]

were you able to create a free database using Planet scale?

[@Pier_Py]

sir, you are the best. Just started with web development and i literally understood everything without any problem. thank you very much

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image link

[@macchiato1083]

In case you are having a problem with the images not being displayed in the /job/id after including the banner.html and nav.html into your jobpage.html around 3:36:33, you will need to go into the banner.html file, in the add ../ to your image source path so it will be like this src="../static/hero.jpeg" and remember to apply the same to nav.html file too. That should fix it. Good luck!

[@mathewtuwei1031]

The best web development tutorial so far! easy to Follow and understand.

[@chillaxbaap]

why waste time understanding replit, when you can do it in vscode anyway

[@girishnaik6433]

by far the most easy to understand tutorial I've come across

[@sambitjasu940]

Absolutely love this course.. Thank you 🙂

[@jovianhq]

Thanks, we're glad you found it useful!

[@rathore354]

I have great respect for Jovian; he is an excellent teacher.

[@mukto2004]

He is definitely a good web development teacher. You teached in-depth and everything I loved it

[@bombasticnonsense4247]

I am grateful to see a tutorial that is not using SQLIte. Looking forward to this. Thank you.

[@jovianhq]

Yeah, we're using PlanetScale to set up a free MySQL database here. You can also use Supabase or Neon if you'd like to use Postgres.

[@akj3344]

@@jovianhq Gonna finally try neon. Lets see

[@fleckenfurz77]

@@jovianhq Is there another way except giving PlanetScale credit card information?

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image

[@brainstormingsharing1309]

Always keep it up! You're doing great! 👍👍👍👍👍

[@jovianhq]

Thanks, we're glad you enjoyed the tutorial!

[@princekhunt13579]

This is a very good tutorial. You will learn flask, how to deploy on render and hosting.

[@sujalbedre]

4:19:02 The code of data: def add_aplication_to_db(job_id, data): with engine.connect() as conn: query = text( f"INSERT INTO applications(job_id, full_name, email, linkedin_url, education, work_experience, resume_url) VALUES (:job_id, :full_name, :email, :linkedin_url, :education, :work_experience, :resume_url)" ) conn.execute( query, { "job_id": job_id, "full_name": data["full_name"], "email": data["email"], "linkedin_url": data["linkedin_url"], "education": data["education"], "work_experience": data["work_experience"], "resume_url": data["resume_upload"], }, ) conn.commit() It will work definitely,

[@SetTheCurve]

issue around 2:47? instead of: "ca": "/etc/ssl/cert.pem" use: "ssl_cert": "/etc/ssl/cert.pem"

[@kevinleonumana98]

Thank you, I was stuck in that part. But I need to know why ? ¿ What is the difference ?

[@1-2weeks96]

@@kevinleonumana98 "For convenience, the following keys may also be specified inline within the URL where they will be interpreted into the “ssl” dictionary automatically: “ssl_ca”, “ssl_cert”, “ssl_key”, “ssl_capath”, “ssl_cipher”, “ssl_check_hostname”." - it's from the docs.

[@1-2weeks96]

thanks!

[@SatyaMedidi]

This is Awesome. Please continue with the next steps!! This Content is GOLD!!

[@AbuRayhanSushmoy]

if you're stuck at 2:56:12 This is one of the solutions you can try, with engine.connect() as conn: result = conn.execute(text("select * from jobs")) result_dicts = [] for row in result.all(): result_dicts.append(row._asdict()) print(result_dicts)

[@jerryk.7582]

i wanted to share the web site i developed using this video cos its my frst time web though i used pycharm cos my code on replit was like #python not found so i knew there aint way after trying many time,i watched this video for two weeks while building my own and learnt everything, aakash is my teacher for life

[@cricketcentral1815]

planetscale have no free plan now....how you access this for free?

[@orionNsirius]

@@cricketcentral1815 I just checked PlanetScale, it still offer free plan as Hobby.

[@caiozendron5024]

If you had trouble converting to dict at around 2h:54m, apparently Legacy.Row is out of date. This worked for me: with engine.connect() as conn: result = conn.execute(text("select * from jobs")) result_all = result.all() first_result = result_all[0] column_names = result.keys() first_result_dict = dict(zip(column_names, first_result)) print(first_result_dict)

[@caiozendron5024]

with engine.connect() as conn: result = conn.execute(text("select * from jobs")) column_names = result.keys() result_dicts = [] for row in result.all(): result_dicts.append(dict(zip(column_names, row))) print(result_dicts)

[@lloydstevens3399]

@@caiozendron5024 thanks thats great, how did you work this out?

[@whitneyz1986]

@@caiozendron5024 Thank you very much 🙌, I was really stuck at this point.

[@sujeetverma1324]

@@caiozendron5024 thanks it was useful for anyone who is stuck with other func. for 'load_job_from_db()' function it should work like this: def load_job_from_db(id): # CREATE "LIST" OF row with id with engine.connect() as conn: query = "SELECT * FROM jobs WHERE ID={}".format(id) result = conn.execute(text(query)) column_names = result.keys() result_dicts = [] rows = result.all() if len(rows) == 0: return None for row in rows: result_dicts.append(dict(zip(column_names, row))) return (result_dicts)

[@lksdf4380]

Cool bro! Thanks a lot.

[@rangikeertana4736]

Excellent tutorial. Nothing irrelevant. To the point👌

[@fifamontage30]

This is Gold bro 👌

[@suchitajain7619]

Hi Akash. Thank you for the detailed tutorial on Python web development. Specially delving into the very basics like HTML and CSS. It is a good refresher as well helped in learning Python web development as a whole.

[@KhelGyanOfficial]

This tutorial is just awesome!! Bro please make one similar video which will include HTML,CSS, Java Script, Angular & Database in that. Mainly I would like to understand how javascript Anular and DB work together.

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image

[@akashkunwar]

RReally thank you it has been a great help. I was trying to learn flask form other sources but this was the most helpful 4.5 hr video.

[@jitunnahak115]

i am working as a python backend developer this video lot a help me thank you so mush for nice video..

[@shanmugavelu953]

Thanks for your tutorial. It made sense how the web development can be done following your tutorial.

[@teogf]

One of the best tutorial I've ever seen about Flask.

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image link

[@huytrant]

Web Development with Python Tutorial very helpful video, i learned a lot from here. Looking forward to the next videos

[@jovianhq]

Glad you liked it!

[@adambishop2997]

This is actually so helpful, Thank you so much!

[@ayodeleadeynka4195]

The tutorial was very impactful. Thank you for putting this togetter

[@arepitas5019]

Thank you for this, so well-explained and comprehensive!

[@jovianhq]

You're welcome! 🙂

[@RadomName3457]

Very useful tutorial, thanks a lot, Jovian and Freecodecamp!

[@clotildefurah9549]

Thank you very much for sharing. Best one video!

[@MrBasu-iq6md]

Thank you for this tutorial. This is a gem.

[@acpucio]

Thanks you Mr. Aakash for this wonderful tutorial.

[@kaushikvenkatraj3175]

For anyone experiencing issues at 4:23:00 for getting an error message that 'job_id' is not an argument. You can make the following changes to the code : def add_application_to_db(job_id, data): row = {'job_id' : job_id, 'full_name' : data['full_name'], 'email' : data['email'], 'linkedn_url' : data['linkedn_url'], 'education' : data['education'], 'work_exp' : data['work_exp'], 'resume_url' : data['resume_url'] } with engine.connect() as conn: query = text("INSERT INTO applications (job_id, full_name, email, linkedn_url, education, work_exp, resume_url) VALUES (:job_id, :full_name, :email, :linkedn_url, :education, :work_exp, :resume_url)") conn.execute(query,row) conn.commit()

[@dhrroovv]

whats the reason of using conn.commit()? I understand that its important bcz my code was not working until I used this line of code. But any reasons?

[@yogeshmishra6025]

Thank you very much for this tutorial, i could understand entire tutorial, and make it work on my laptop, render and planetscale, I used PyCharm on my laptop instead of replit, and the insert functionality I had to make some changes to make it work - had to use key value pair : values={'job_id': job_id, 'full_name':data['full_name'], 'email':data['email'], 'linked_url':data['linkedin_url'], 'education':data['education'], 'work_experience':data['work_experience'], 'resume_url':data['resume_url'] } and then add this 'values' to the conn.execute (query, values)

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image

[@sujalbedre]

@@ananyachauhan775 You can go to the description and you will get that.

[@germantoenglish898]

I had to install python package at Replit for it to work. Otherwise I get a not found error. Took me an hour to figure it out but it's working now.

[@mohamadderouich1899]

Thank you very much for this tutorial, it helps me a lot to understand how web dev works and to build a good mindset about internet and web dev. thank you very much

[@tabannikdel6475]

Simply great! Thank you for this great step by step project. I can see my project built up by only watching your video. Many many thanks.

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image link

[@franfurey]

After many hours i finally finish this course! REally nice to get some practice. Thanks!!! a lot.

[@ananyachauhan775]

can you please provide the correct and complete link of jovian image link

[@nirmesh44]

best tutorial ever👍👍👍

[@chakibheraoua8125]

Great job ! Thank you for this tutorial

[@Su_Code]

this guy is a god level teacher

[@prajwalm.s7976]

2:22:49 any alternative to Planet Scale because it is asking card details even for the free plan

[@abdullahmuhammadmoosa7170]

Brother did you find any?

[@AbuRayhanSushmoy]

aiven worked fine for me

[@srirams2351]

Good work da baiii

[@memusirobi5031]

wow am grateful for the great work done here💖😄

[@kent4239]

The deployment to planetscale is different now, are there any update things or anything like that?

[@orionNsirius]

I am having problem with Planet scale revoke my username and password after pushing GitHub commit. What issue did you have?

[@Editinggeek]

I'm stuck on that exact point. Planetscale is not offering hobby database to users in my country. I'm searching for an alternative. If you found another way please let me know.

[@kent4239]

I used them I just figured it out, might have emailed them or something.@@Editinggeek

[@SujataMishra-h5o]

from 2.55.22 timeing, i got this issue sorted instead of using dict(), used _asdict():# first_result_dict = dict(result_all[0]) # we are having issue with this dict function as its unable convert dictionary update sequence element #0 to a sequence, so using chart gpt i found it runs well as using .asdict() which makes dict function able to convert the above issue Else all good, i just shared as any one else may have this issue.Thanks The Vedio is very clarified and self dependable.

[@jensonbbenson]

The following also worked for me: with engine.connect() as conn: result = conn.execute(text("SELECT * FROM jobs")) result_dicts = [] for row in result.all(): result_dicts.append(dict(zip(result.keys(), row))) print(result_dicts)

[@imballama]

2:56:29 if your code didn't work, try to use - "for row in result.mappings()"

[@dzaenkireolm]

this worked for me perfectly. first i tried this for row in result.all() jobs.append(row._mapping) return jobs this does makes it a list of dict but jsonify was having typeobject error and i couldnt find an easy solution for it but ' for row in result.mappings()' this works like a charm, you can do like shown in the video just instead of result.all() use result.mappings().

[@sandeepsudhakar8803]

Very good tutorial and should help many developers to build on similar lines. Great job 👍

[@lksdf4380]

Thank you bro! It's so cool course for Flask beginner.

[@lhcunha1]

Great lesson. Thanks!

[@yuvaranip9544]

Awesome tutorial ...

[@jkepler-eh4zr]

1:18:42 When I do this, there is no output, because the variable 'job' is not accessed by jobitem.html.

[@ryanm03]

absolutely great tutorial!!!!!

[@babu_g19]

Very helpful. Thanks for sharing 👍

[@jovianhq]

Glad you found it helpful!

[@rushilnarsai]

For the mySQL database using Planet scale, they do not have a free plan anymore. What's the best alternative?

[@aayushmaan3128]

same concern

[@svilenivanov3621]

Good job! 🤛🏻

[@soliarym4071]

finnaly finish it thank you so much

[@umehmoses8118]

Thank you for helping us Africans

[@hitenbhadra-ju6mr]

😂😂😂

[@IamTanmoy28]

You guy's have electricity??😮

[@timothycollins718]

😂😂😂😂

[@kimsoyoung1257]

Is not he look like indian..haha😅

[@eliudmkenya001]

@@IamTanmoy28No, we wait for thunderstorms and use the lightning flash to do our school assignments and other things 😢.Sometimes we also read using our father’s cigarette light

[@Indiagotlatenthq]

Amazing lecture!!!

[@jovianhq]

Thanks!

[@greedycode]

when 3rd part of this video is coming? Great work man👍👍

[@MrWang-ms2qz]

Thank you very much for this course!

[@jovianhq]

You're welcome!

[@sadiqhussain9202]

How to store a file type input in SQL instead of taking resume url? how about .pdf? I know it isn't a right approach with SQL DB but is there any workaround to it?

[@SujataMishra-h5o]

Why again and again the PlanetScale MySql Pw is getting changed and my web-page is not running in Render atall . Please help me any suggestion

[@ForRo3sS]

This gentelman somehow has the best way for me to understand!

[@bbheinz32]

This was great!!

[@TECHWITHSEBASTIAN]

This was like super useful ! Thank you a lot Sir , I appreciate your work

[@jovianhq]

You're welcome Sebastian! We hope you were able to follow along and deploy your own website.

[@darnred07]

Thank you for this😊

[@jovianhq]

You're welcome, looking forward to seeing what you'll build!

[@aayushmaan3128]

Planet scale stopped its hobby tier package what is a good alternative for it?

[@aayushmaan3128]

I am replying to myself Aiven is a good alternative

[@dhrroovv]

@@aayushmaan3128 hey thanks man. i thought of using amazon rds but would now try aiven.

[@LifeCodeGame]

Take the first step towards becoming a web developer with Python by learning Flask and Dynamic Database-Driven Web Apps with this comprehensive course!

[@adrianperez9382]

Muchas gracias fue divertido. Algunas cosas han cambiado pero se pueden realizar.

[@sandeepmandrawadkar9133]

Very informative tutorial. Thanks for creating such a wonderful tutorial and helping the needy🙏 Now the site Planet-scale is not totally free. Please can you suggest any alternative.

[@BIRAJDE-wn6lz]

Awesome lecture!

[@jovianhq]

Glad you enjoyed it!

[@arghobasak]

WOW 😃❤

[@smokegamer5560]

Great Video

[@philosophyindepth.3696]

i am gonna watch it i find it intresting as teaching is good

[@developer_dhanji]

This video is helpful 👍

[@aryanthombre2971]

Loved your content , is it important to buy a domain to put it on your submit project and earn certificate section?

[@lukaszbolach506]

Hello community! I stucked around 3:18. Does anyone know why after deploying to Render, and building whole app correctly I got error: access denied for user : ..userHameHere... and right after that notification on email from planet scale that 'leaked secret has been revoked' ... database password has been detected in public repository onGH. Any connections using this password will be disconnected. Any ideas how to fix it?