Perfect timing for this video. Started looking at sqlite last week, then deceided it was to advanced for me, and just wanted to save my data as json/dict/csv file.. A buddy of mine convinced me to go back to sql, so will try that, and with your video i just got a good introduction to it. :)
It's spooky how timely some of your videos are. After sitting on an online Python course for a year, I have only this weekend started with the SQLite section. Happy to see the practices reinforced here with some great features I was wondering about (using with Pandas), but hadn't learned yet. Thank you for all of your content.
You don't have to delete the database. You already added the condition: CREATE TABLE IF NOT EXISTS books - this ensures that the books table is created only when it doesn't already exists.
Hi, what about relations? If I have two tables. In first Books(id, title, authorId, price), the second Authors(authorId, firstName, secondName). Do I need to use JOIN in SQL command or is there a more pythonic way?
Could you highlight some real world use cases for this? If I understand correctly, this can't be used to create a persistent database. For example load data walk away come back next week and the dad is still there. If you can't do that? What's the use of this? Thanks much
I've never watched a single one of this guy's videos before, but on seeing the link and his attire, I thought to myself, "this man is going to have a British accent." Why did that thought run through my mind? Why was it accurate? I have no idea. Is there really anything about his attire that screams "I'm British"? Not that I can see. Such strange coincidences we sometimes experience.
Yours is a highly underrated channel amongst the computer science related channels on TH-cam. Great video as always. ❤
Perfect timing for this video. Started looking at sqlite last week, then deceided it was to advanced for me, and just wanted to save my data as json/dict/csv file.. A buddy of mine convinced me to go back to sql, so will try that, and with your video i just got a good introduction to it. :)
It's spooky how timely some of your videos are. After sitting on an online Python course for a year, I have only this weekend started with the SQLite section. Happy to see the practices reinforced here with some great features I was wondering about (using with Pandas), but hadn't learned yet. Thank you for all of your content.
You don't have to delete the database. You already added the condition: CREATE TABLE IF NOT EXISTS books - this ensures that the books table is created only when it doesn't already exists.
Thank you so much, just what I was looking for, very well designed - cheers!
Love Sqllite and sqllite studio is a massive time saver.
this is exactly what I was lookiing for. Thank you Python Programmer !
A gentle introduction by an English gentleman.
Thank You! ❤️❤️
Amazing Video, been waiting for this.
Thankyou sir❤️
Hi, what about relations? If I have two tables. In first Books(id, title, authorId, price), the second Authors(authorId, firstName, secondName). Do I need to use JOIN in SQL command or is there a more pythonic way?
Some of the code is cropped off on the right hand side. Is it available as a download?
My favorite SQLite command.
.mode csv
Thank you ,so informative video :).
Always the best
Make a video on Machine Learning using WSL2 platform. (On Windows 10)
Thanks for lesson maestro!
I'll always wanted this videos to be in OOP style
Could you highlight some real world use cases for this? If I understand correctly, this can't be used to create a persistent database. For example load data walk away come back next week and the dad is still there. If you can't do that? What's the use of this? Thanks much
A comb. of Python and sqlite3 offers the modern environment for interactive data management
Hey -
what colour theme are you using for vccode?
14:29 - 'DataFrame' object has no attribute 'append'
S tier vid
Pretty cool
I've never watched a single one of this guy's videos before, but on seeing the link and his attire, I thought to myself, "this man is going to have a British accent." Why did that thought run through my mind? Why was it accurate? I have no idea. Is there really anything about his attire that screams "I'm British"? Not that I can see. Such strange coincidences we sometimes experience.
Hi
I miss some of your videos because i did not recognize it is yours
will be better if you put your photo in video thumbnail to recognize it
The only question that i dont understand is how to insert to many data in such ways.. It is not comfy to enter massive data with command like that
Sqlite doesn’t come with Python. The module does.
.
Hey -
what colour theme are you using for vccode?
Hey -
what colour theme are you using for vccode?