SQLite in Python || Python Tutorial || Learn Python Programming

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

Жыл бұрын

Are you a Python programmer who loves Data? This is your lucky video! Hit play as we dive into the world of SQLite in Python. We'll cover connecting & creating databases, cursors, different ways to execute queries, the secrets of dodging SQL Injection Attacks, and more! So buckle up, grab your coding gear, and let's get this party started!
Find our programming playlists here:
Python: bit.ly/PythonSocratica
SQL: bit.ly/SQL_Socratica
Subscribe to Socratica + bell for notifications:
bit.ly/SocraticaSubscribe
⧓⧓⧓⧓⧓
We recommend:
How to Be a Great Student
ebook: amzn.to/2Lh3XSP
Paperback: amzn.to/3t5jeH3
Kindle Unlimited (read free): amzn.to/3atr8TJ
Python Cookbook, 3rd edition
amzn.to/3jprjX2
⧓⧓⧓⧓⧓
Join this channel to get access to perks:
/ @socratica
Support Socratica on Patreon:
/ socratica
Python instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Michael Harrison
Edited by Megi Shuke and Michael Harrison
#pythontutorial #sqlite #coding

Пікірлер: 114

@cyndicorinne Жыл бұрын

This is a great introduction to the use of for SQLite and Python. As always, the deadpan humor is much appreciated. 💜

@AhmadAlMutawa_abunoor Жыл бұрын

I can not convey how much I am glad to see your videos coming back. I use SQLite extensively with C#. But I am glad to see that I can extend my usage to python as well. Please, please, please, make more videos like this, and with more frequency 🙏🙏

@KaizerKilborn Жыл бұрын

I started learning SQL yesterday, and am using it in Python. This video has arrived with precise timing. Would expect nothing less from Socratica. Thank you for making this video!

@Socratica Жыл бұрын

SYNCHRONICITY!! 💜🦉

@thatotherguy4245 Жыл бұрын

This could not have come at a better time...my boss just asked me to speed up our dashboards and start managing our own data instead of relying on the technology team. Awesome video as always.

@darius_defiant Жыл бұрын

I love the way this is narrated SO much. It's the perfect amount of efficient, to-the-point teaching and humour. It keeps me engaged and interesting through otherwise relatively dry subject matter

@djl3009 Жыл бұрын

{ "title":"SQLite in Python", "chapters":{ "start" : "00:00:00", "What is SQLite" : "00:00:34", "Create DB" : "00:01:20", "Create Table" : "00:02:27", "Insert data" : "00:03:13", "Commit the connection" : "00:04:42", "Data Types" : "00:05:07", "execute & exececutemany" : "00:05:50", "executescript" : "00:06:01", "Cursor iteration" : "00:07:12", "? placeholder" : "00:07:39", "Summary" : "00:08:42", "end" : "00:10:10" } }

@felsrage 3 ай бұрын

"timestamps.json"

@ImHansana123 Ай бұрын

pinTheComment()

@ImHansana123 Ай бұрын

pinTheComment()

@alvarocafe Жыл бұрын

This channel just keeps getting better! Cheers!

@Socratica Жыл бұрын

𝙎𝙩𝙖𝙮 𝙞𝙣 𝙩𝙝𝙚 𝙡𝙤𝙤𝙥 𝙄𝙉𝙁𝙄𝙉𝙄𝙏𝙀𝙇𝙔: snu.socratica.com/python Code samples & test data live at → github.com/socratica/python

@metinunlu_ 11 ай бұрын

I don't remember enjoying a cs related education video this much, absolutely loved it! Thank you.

@FlyingTurtleLP Жыл бұрын

Oh how much I love these videos :D ... Amazing style and so entertaining!

@df6148 Жыл бұрын

I would really love a MongoDb video just like this. 🙏🏽

@murphygreen8484 Жыл бұрын

Have you tried duckdb?

@df6148 Жыл бұрын

@@murphygreen8484 I have not 😞 . Thanks for the recommendation it looks interesting. 😄

@paulw3182 Жыл бұрын

This is wonderful, the comedic take is sublime.

@neurite001 Жыл бұрын

Appreciate you have included the topic of SQL injection in this short video.

@JorgeEscobarMX Жыл бұрын

Omg! ❤ it's been so long. I'm just happy to have a new SQL video on socratica

@Socratica Жыл бұрын

We're so tickled we had a chance to make another programming video! Working on the next script now...

@pochta1000 Жыл бұрын

Great, great, great to see and hear you back ! Thank you ! So cool that you have immediately involved ChatGPT (who haven't ?). Eager to see more and more of your brilliant videos !

@kiiandrii Жыл бұрын

these videos are always so clear and funny.

@abyss2200 Жыл бұрын

Yes lol exactly

@Poerak 6 ай бұрын

SQLite standing behind you: Am I a joke to you?!

@MrPioneer7 Жыл бұрын

Welcome back Socratica. Please continue posting videos.

@rhysdavies9376 3 ай бұрын

I'm new to Python and SQL and this helped me overcome my first hurdle - also made me giggle too, which is very much a plus - Great stuff!!

@Dettol68 6 ай бұрын

Love the video style, production and clear content, thank you!

@manjubeli 8 ай бұрын

This is pure gold! loved the humor

@sabuein Жыл бұрын

Thank you, and welcome back :)

@mhamd2020 7 ай бұрын

Welcome Back, OMG I watched just to enjoy your amazing hilarious presentation. :D Aslo, as alwase the best content ever.

@absmustang Жыл бұрын

Another fine video full of memorable info. Thanks!

@baasantserenganbold2925 Жыл бұрын

Wow, thank you. I love your tutotials.

@ozzman530 Жыл бұрын

I've been using SQLite3 for years in python to import and export Excel files. I love the versatility. It makes anything I can put into Excel, easy to handle for generating formatted colorized output in a terminal of a bastion server. Also love the fact that I still learned a couple new concepts from this video. Great job.

@user-yo9om1zr3l 10 ай бұрын

hi there do i have to download sqlite3 to connect? i'm getting an error.

@ozzman530 10 ай бұрын

@@user-yo9om1zr3l you should be able to use sqlite in python, but if you want to interact with the program outside of python you may need to download some more materials.

@graytonw5238 Жыл бұрын

I come to these videos for the bone-dry humor in addition to the education. Another winner!

@kingofcastlechaos 11 ай бұрын

I need to write a Python script that detects I am watching your videos, and then reminds me to NOT be drinking or chewing while watching, or I may be cleaning up my desktop yet again. LOVE the humor!

@budddmj8191 Жыл бұрын

You are back!

@ahmadnurokhim4168 9 ай бұрын

i love how you explain these things

@jordang6142 5 ай бұрын

I love how she specifies "In another timeline" for the SQL intro lol. So the SQL series is another timeline in the SCU - Socratica Cinematic Universe. Very small touch but I love it 😂

@cryptolikeaboss Жыл бұрын

The Snap at the end... LOL🤣

@cryptolikeaboss 4 ай бұрын

It got me too 😅😅😅😅😅😅😅🤣

@bckzilla Жыл бұрын

Sensational. Thanks.

@faisalfftamil7814 Жыл бұрын

Wonderful💙

@astroweeb Ай бұрын

Great Video!

@jamesT008 Жыл бұрын

As always good explained😊

@pile333 Жыл бұрын

Well done!

@travelvideos Жыл бұрын

Welcome back!

@eder8170 Жыл бұрын

Hey there It's been a while .. u are my hero

@user-bb5rs8rv4u 3 ай бұрын

Great stuff

@aliwaseem5990 Жыл бұрын

BIG like for your BIG video.

@abyss2200 Жыл бұрын

Ulka I'm obsessed with you and your abilities. I wish you come to India then 🍽️ be from my side. Please bring your Socratica fnds too 😅

@Shubh22 Жыл бұрын

Only Socratica can make me watch a tutorial on Friday night!

@kunalsoni7681 10 ай бұрын

Very Interesting Video ⭐⭐⭐⭐⭐😊

@oguching Жыл бұрын

She's back.

@murphygreen8484 Жыл бұрын

Can you close the connection with a context manager?

@Allen-by6ci Жыл бұрын

Hey Socratica...Please put Ulka's name in the credits... She does a fantastic job... Thanks!

@Socratica Жыл бұрын

Ulka's the BEST! You can find the Socratica Team credits in the Description. Thanks for your nice message. 💜🦉

@onyilimba 8 ай бұрын

Been using your tutorial since school, now I'm a graduate in computer science. How time flies. 😅 Waiting for a new tutorial to be dropped back then.

@Socratica 8 ай бұрын

We're so happy to be making this journey with you! 💜🦉

@claudiatrujillociafre3865 14 күн бұрын

Thank youuuuuu

@rrsrjspa Жыл бұрын

I Love your videos

@FilterYT Жыл бұрын

I enjoy this character, I would watch even if I wasn't interested in the subject.

@oida10000 Жыл бұрын

I would recommend using the with statement, it does the closing for you. Question can I do: with sqlite3.connect("mydb") as mycon, mycon.cursor() as curs: #do something or does it need to be with sqlite3.connect("mydb") as mycon: with mycon.cursor() as curs: #dosomething Update maybe you need to use the context liberary for that.

@birdie123 Жыл бұрын

Example usage of context manager, simply use it on the connection. import sqlite3 def execute_query(query, db_name, parameters= ()): with sqlite3.connect(db_name) as conn: cursor = conn.cursor() query_result = cursor.execute(query, parameters) conn.commit() return query_result if __name__ == "__main__": db_name = "member.db" query = "SELECT * FROM table" results = execute_query(db_name=db_name, query=query) for result in results: print(result)

@farhadpza Жыл бұрын

Thanks, please talk about mongodb and python too

@JorgeEscobarMX Жыл бұрын

I wonder if sqlite has constraint support. To enforce relational rules between tables

@arunsp767 Жыл бұрын

I'm now convinced that ChatGPT is a subconscious copy of Socratica

@krzysztoflechowski5745 Жыл бұрын

Thanks!

@Socratica Жыл бұрын

Thank you so much, kind Socratica Friend!

@krzysztoflechowski5745 Жыл бұрын

@@Socratica votary

@happyspaceinvader508 Жыл бұрын

It would be awesome if Socratica did NodeJS and Golang.

@murphygreen8484 4 ай бұрын

Refresh with a video on DuckDB?

@zarakikenpachi011 Жыл бұрын

8:38 = cur.execute("SELECT * FROM membros WHERE fn=?", (user_input,)) Thank you! executescript is new for me...

@benjamindover4337 Жыл бұрын

Now you're speaking my language.

@Bruno-rm9er 8 ай бұрын

That was the most weird and understandable tutorial I've seen in a while

@Socratica 8 ай бұрын

Weird and Understandable is us exactly thank youuuu 💜🦉

@yash1152 Жыл бұрын

1:32 please share how to start from a csv data?! thanks :)

@MrEarbuckets Жыл бұрын

JS is respectable....FINALLY! Wheeee!

@anterprites Жыл бұрын

6:09 Flashbang harder than Filian

@zoltanposfai3451 Жыл бұрын

You got me for a moment, but I checked. I'm alone in the room...

@cmugy Жыл бұрын

❤❤

@Tubemanjac 8 ай бұрын

2:04 "If you try to connect to a database file that does not exist, then one will be created for you. So if you misspell the name of an existing database, surprise - you now have a second database." This example shows that evolution in programming languages apparently does not imply better quality and sophistication. More than 50 years ago some languages would automatically inform you of een error which, depending on the errorcode could be processed and taken appropriate action on the fly under program control.

@intron9 7 ай бұрын

You wrap it around "if os.path.exists(filename) " . There will always be a default action for every command. You must think of every common use case.

@furqanehsan8338 Жыл бұрын

Love from Pakistan ❤

@arulananthams2540 Жыл бұрын

We need how to use chatgpt in terminal

@TheRealPyCodeSniffer Жыл бұрын

how are you making this voice?

@TECHNOCANNON 26 күн бұрын

Surprise! You now have a second database...😂😂

@hammer86_ Жыл бұрын

Fun Fact: sqlite uses flexible typing, and datatype names in column definitions are completely optional 😳

@xornand6833 Жыл бұрын

hei ! I subscribed in a Group Theory Channel what happened ?

@orionNsirius 2 ай бұрын

I need to overcome the anxiety that I don't have graphical interface if using sqlite

@kevon217 Жыл бұрын

it’s not always the size of data that matters, but how you use it…

@BijouBakson 8 ай бұрын

A robot? :)

@forgottenvy Жыл бұрын

She's back to the channel or it's just AI generated video? Or she's been an AI all along? I don't follow this community much so I was curious

@thatotherguy4245 Жыл бұрын

It's AI...you can see the pixels

@emman100 Жыл бұрын

@@thatotherguy4245 🤣🤣🤣

@amateurwizard Жыл бұрын

Everywhere I go I overload SQLite Databases 😢

@dixztube Жыл бұрын

whoa js is respectable now!? how about that!

@thatomofolo452 Жыл бұрын

Fr Fr Fr 🎯🎯🎯💯

@ArsParfenov Жыл бұрын

Did You really name yout son Robert'); DROP TABLE Students;-- ?

@Alchemist10241 8 ай бұрын

everything is big now 🤣

@faisalali5025 2 ай бұрын

Whopping zero bytes🤣

@andromilk2634 Ай бұрын

Why is this video talking like a robot?

@TheSpacecraftX Жыл бұрын

Implying Java is not a respectable programming language haha.

@el_witcher 4 ай бұрын

Not even C++ got a taste of respect haha

@justintodd5145 Ай бұрын

Java is a great language.

@WoWUndad 26 күн бұрын

Java has been dead for 10+ years and yes microsunsystems and their autistic kiddie language is terrible

@MehediHasan-sz5xf 10 ай бұрын

ridiculous

@xucaen Жыл бұрын

I wish you wouldn't use ChatGPT.

@stultuses Жыл бұрын

She has been teaching Python and sql well before ChatGPT ever existed I wish people wouldn't just think people are using ChatGPT

@Socratica Жыл бұрын

We definitely want to help people understand how to use this new remarkable tool. We can't ignore that it exists! 💜🦉

@GrypV Жыл бұрын

Thanks!

@Socratica Жыл бұрын

Thank you for your kind support!!