Great video as always John! I have recording tip for you. There are apps(Loom; it also records in circular shape so better than square...) that moves your headcam up or down depending on your mouse (not sure about keyboard cursor). Or you could write something that does it for you. Wishing you a good luck!
Thanks! It’s been a while since I made this video and now I use separate recordings for face cam and screen so I can move it around and adjust while editing
Hi John, thank you for the great content you are producing. Just a quick question in relation to the above. Should you also include db.create_table() into example_usage.py? Thanks!
I’m not sure I’ve never used that! It’s a good starter sql database that is stored locally and is good for learning on and small applications. Also easy enough to port it over to something better when needed
can I make this work with an nested class for the tables as I want to have a range of "presets" saved up, that can be chosen within a GUI that gives out a variable that decides what preset is chosen and triggers some other code that would read and write from/to this table as needed, but I ran into the problem that I cannot pass the cursor/connection from my database class to my table class
Hi John GREAT VIDEO BTW I've followed the structure of your code and i really like it but i've been having a problem. my problem is trying to insert data from a user input from a different .py File
i'm looking to web-scrape google news for all the articles for my country about COVID-19 for a year(2020-till now), I've tried all the methods and i'm definitely doing it wrong, can you please make a video on that? love from india.
First! Great video.
Thanks! first and pinned
This is exactly what I've been looking for. Thank you. I'm working on a Flask project that involves web scraping to database. Your videos help a ton!
re: self.con.commit. Suggestion to use Context Manager (with self.con: self.cur.execute("""INSERT etc. ) commit and close are not needed.
Just saved a Digital Assignment with this.
Thaaaaank You!!
You are my teacher thank for all your tutorials.
Thanks mate. This is really cool especially doing it in OOP way
I like the idea of always using triple quotes for """SQL command""" even if it's not required (e.g. on a short command "SQL command").
Yes you’re right I think that is better too
Great video as always John! I have recording tip for you. There are apps(Loom; it also records in circular shape so better than square...) that moves your headcam up or down depending on your mouse (not sure about keyboard cursor). Or you could write something that does it for you. Wishing you a good luck!
Thanks! It’s been a while since I made this video and now I use separate recordings for face cam and screen so I can move it around and adjust while editing
Great video, thanks John!
Another fantastic Tutorial! Keep with this great Work!
Thank you!
Thank you very much, buddy! :) Keep making good videos!
Many thanks...
Great Explanation Sir,
Excellent works
Brilliant. Thank you very much.
This is really cool
Hi John, thank you for the great content you are producing. Just a quick question in relation to the above. Should you also include db.create_table() into example_usage.py? Thanks!
Thank you for your videos.
Thanks. Re: DATE type. SQlite says it has 5 types, not including DATE. But DATE is accepted. Your var 'today' is a string. Why not use type TEXT?
Yes, correct again. I'm mixing types here which is not a good idea
Never worked with SQLite, time to give it a shot. Is it similar to Google's Big Query?
I’m not sure I’ve never used that! It’s a good starter sql database that is stored locally and is good for learning on and small applications. Also easy enough to port it over to something better when needed
@@JohnWatsonRooney Will definitely give this a try. You have no how much easier you've made my life with your Python videos.
I was about to ask it also! Thanks for both question and answer!!!
Thanks
Sera posible la ventana donde te muestras un poco mas pequeña por favor. 🙏
can I make this work with an nested class for the tables as I want to have a range of "presets" saved up, that can be chosen within a GUI that gives out a variable that decides what preset is chosen and triggers some other code that would read and write from/to this table as needed, but I ran into the problem that I cannot pass the cursor/connection from my database class to my table class
Hi John GREAT VIDEO BTW I've followed the structure of your code and i really like it but i've been having a problem. my problem is trying to insert data from a user input from a different .py File
Nice
how to Store large number of data into sqlite? using python?
How to convert the large number of data from csv to sqlite?
i'm looking to web-scrape google news for all the articles for my country about COVID-19 for a year(2020-till now),
I've tried all the methods and i'm definitely doing it wrong,
can you please make a video on that?
love from india.
17 likes - 87 views
Wow!
Second :) do i get pin ;) :D:D:D great content as always!
Haha thanks! There can only be one pin sorry!!
@@JohnWatsonRooney I know. I will try act faster next time 😉