PostgreSQL in Python - Crash Course

  Рет қаралды 63,735

NeuralNine

NeuralNine

Күн бұрын

In this video, we learn how to use PostgreSQL in Python.
PostgreSQL: www.postgresql.org/
◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾
📚 Programming Books & Merch 📚
🐍 The Python Bible Book: www.neuralnine.com/books/
💻 The Algorithm Bible Book: www.neuralnine.com/books/
👕 Programming Merch: www.neuralnine.com/shop
🌐 Social Media & Contact 🌐
📱 Website: www.neuralnine.com/
📷 Instagram: / neuralnine
🐦 Twitter: / neuralnine
🤵 LinkedIn: / neuralnine
📁 GitHub: github.com/NeuralNine
🎙 Discord: / discord
🎵 Outro Music From: www.bensound.com/
Timestamps:
(0:00) Intro
(0:17) Installing PostgreSQL
(4:52) PostgreSQL in Python
(15:33) Outro

Пікірлер: 51
@avidreader6534
@avidreader6534 Жыл бұрын
Your python videos have been so crucial for a java developer like me who wants to learn python. Thank you! Pls keep putting out beginner content like this
@Harleyotter
@Harleyotter 10 ай бұрын
Thank you so much! I spent hours on tutorials that produced nothing but errors. This was concise, informative, and easy to follow and test. Your video allowed me to end a very frustrating day with a success. Your voice and speaking speed are very pleasant and calming, too and I've discovered how much difference that makes when trying to learn/practice something new. Kudos!
@pepecopter
@pepecopter Жыл бұрын
Thanks man that's a great alternative to SQLite3 and MySQL. I can see why postgres is in the top databases and why it's so often required in job applications
@satomori6604
@satomori6604 Жыл бұрын
Perfect timing! Thank you! :)
@iamammar__
@iamammar__ 9 ай бұрын
Thank you so much finally I find the best tutorial video because no one tell the whole solution that you discussed in this video :)
@gameknightplayz
@gameknightplayz Жыл бұрын
thank oyu so much for your tutorials they have been very helpful on my coding journey i am glad to see a helpful and consistent youtuber
@asielalabbassi7097
@asielalabbassi7097 12 сағат бұрын
Thank you, an awesome video short,quick and easy to learn
@NiceChange
@NiceChange 6 ай бұрын
great video. Demystifying..great work
@tallalmoshrif6643
@tallalmoshrif6643 6 ай бұрын
Great stuff!
@user-xm5se6yz4y
@user-xm5se6yz4y Жыл бұрын
Dude, you are the best ❤️
@vc7057
@vc7057 Ай бұрын
Easy to watch and hard to make it work on my side 🙂 Thanks for the video
@grahamlindsay9798
@grahamlindsay9798 Жыл бұрын
Great video!
@ambivert_sigma_motivation
@ambivert_sigma_motivation 10 ай бұрын
Thankyou, really helpful :)
@rhard007
@rhard007 Жыл бұрын
Great video, any chance you can do another video with postgres + sqlachemy and then used them with fastapi ? Thank you. Love your content.
@suen-tech
@suen-tech 9 ай бұрын
Good advices Thank you
@mickelodiansurname9578
@mickelodiansurname9578 3 ай бұрын
30 seconds in, and subscribed...
@NaveenKumar-bl1oy
@NaveenKumar-bl1oy Жыл бұрын
Great -- need more Videos on SQL in Python and Some excel Automation -- doing Day to Day Work in Company. Hope You understand -- i want to do my work of doing lookups , filters and pivots and more excel works in Python
@mdbarin2014
@mdbarin2014 Жыл бұрын
unsurprisinhly it was excellent. Tanx
@Gadlbool
@Gadlbool 2 ай бұрын
Thenk you my bro🎉🎉🎉
@hoyinli7462
@hoyinli7462 Жыл бұрын
great video
@viktoraspranckietis3772
@viktoraspranckietis3772 Жыл бұрын
what plugin do you use for writing sql query?
@ilmiriliasov2521
@ilmiriliasov2521 Жыл бұрын
Thank You for tutorial!. id column type "serial" will be good use. And i saw in another video what man use "with" construction and he talk what not need make cursor.close(), if you use "with" construction. May be somewho will be useful this). Sorry for my "legendary" english)
@Sam-tg4ii
@Sam-tg4ii 5 ай бұрын
If we want to write to the same table in multiple processes, should each process/worker have its own connection and/or cursor?
@kenchak8356
@kenchak8356 Жыл бұрын
It's a great video. I have a question of querying data with NULL value from database. As found failure query result as I used WHERE name = %s with None in the condition tuple. I know that it should be name IS NULL instead of name = NULL. May I know how to fix this problem?
@daveys
@daveys 2 ай бұрын
3:33 - I had a load of strife getting the server running and access to the postgres user on Linux, but beyond that, PGAdmin seems to work OK.
@Abvht1656
@Abvht1656 8 ай бұрын
very strong password -1234
@kush_editz_yt
@kush_editz_yt 11 күн бұрын
Yes bro very strong nobody guesses it I use passwords like 58hsp*b4@ but it can be guessed so easily
@bluelightsaberondesk
@bluelightsaberondesk Жыл бұрын
at 8:00 I can't figure out how to even bring up that response in vscode for me? alt + enter doesn't do anything, and there doesn't appear to be a command to inject a language
@shoukatalamsifat7173
@shoukatalamsifat7173 7 ай бұрын
I am facing the same problem, Did you be able to solve it?
@goldenbook2731
@goldenbook2731 3 ай бұрын
i didnt inject and directly executed the file and it created a table for me
@dzakaash
@dzakaash 3 ай бұрын
Have solved it?
@goldenbook2731
@goldenbook2731 3 ай бұрын
@@dzakaash yea
@BlackWindow-if1pt
@BlackWindow-if1pt 11 ай бұрын
📈
@bigj3867
@bigj3867 Жыл бұрын
Please make a brief explanation video on mojo..... lots of thanks..
@danielperezcastano777
@danielperezcastano777 4 ай бұрын
Can you teach us how to handle .ini files with postgreSQL and python?
@lupusexperience
@lupusexperience Жыл бұрын
I'm a novice. Been using MySQL for 3 years in a project. Workbench is such a bad program. This one for PG looks much better. Nice video thank you.
@stylishskater92
@stylishskater92 Жыл бұрын
What? I dropped MySQL for PostgreSQL years ago, but whenever i go back to MySQL im i notice how great Workbench is. Definitely much better than pgadmin.
@lupusexperience
@lupusexperience Жыл бұрын
@@stylishskater92 Well it crashes 20x per day for me (ubuntu), so if pgadmin is worse I can't even imagine how it is lol.
@MahfudCodex
@MahfudCodex Жыл бұрын
Hello Sir, that a So Happy Code With Python, What is your Extension Sir, Please..
@philtoa334
@philtoa334 Жыл бұрын
Thx_.
@bobvance9519
@bobvance9519 Ай бұрын
I'm confused about what mogrify atually does.
@spencersedano
@spencersedano 11 ай бұрын
If you have errros installing PostgreSQL, just choose in 'locale', English, United States. I chose the country that I'm based in and it didn't work
@mensmentalhealth3012
@mensmentalhealth3012 Жыл бұрын
cool
@ryomensukuna4526
@ryomensukuna4526 11 ай бұрын
Where can i find that the user is "postgres". Someone help plz.
@maazshaikh5283
@maazshaikh5283 3 ай бұрын
you can find it in the properties tab of the server.
@scfdtutorials-ro2ru
@scfdtutorials-ro2ru Жыл бұрын
Can Python do anything without packages?
@JurinF
@JurinF 5 ай бұрын
yeah
@RidwanurRahmanextreme
@RidwanurRahmanextreme 11 ай бұрын
I chose a very complex one 1234 😂😂😂😂🧡
@RidwanurRahmanextreme
@RidwanurRahmanextreme 11 ай бұрын
In my case pgadmin didn't open 💔
@aharongina5226
@aharongina5226 9 ай бұрын
thumb down
SQLAlchemy Turns Python Objects Into Database Entries
22:23
NeuralNine
Рет қаралды 156 М.
REST API Crash Course - Introduction + Full Python API Tutorial
51:57
Жайдарман | Туған күн 2024 | Алматы
2:22:55
Jaidarman OFFICIAL / JCI
Рет қаралды 712 М.
Please be kind🙏
00:34
ISSEI / いっせい
Рет қаралды 160 МЛН
The Complete Guide to Python Virtual Environments!
15:52
teclado
Рет қаралды 328 М.
PostgreSQL CRASH COURSE - Learn PostgreSQL in 2022
50:26
Troy Amelotte
Рет қаралды 207 М.
5 Really Cool Python Functions
19:58
Indently
Рет қаралды 52 М.
MongoDB in Python - NoSQL Document Database
24:33
NeuralNine
Рет қаралды 42 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,4 МЛН
Python 101: Learn the 5 Must-Know Concepts
20:00
Tech With Tim
Рет қаралды 1,1 МЛН
5 Good Python Habits
17:35
Indently
Рет қаралды 393 М.
God-Tier Developer Roadmap
16:42
Fireship
Рет қаралды 6 МЛН
Неразрушаемый смартфон
1:00
Status
Рет қаралды 1,6 МЛН
Собери ПК и Получи 10,000₽
1:00
build monsters
Рет қаралды 1 МЛН
Какой ПК нужен для Escape From Tarkov?
0:48
CompShop Shorts
Рет қаралды 265 М.