This SQLite Database Model is Easy and Ready for your Python Projects!

The best thing is that you can import this file into your own projects making it a good base to play around and learn with

If you wish to support me:

-------------------------------------
Disclaimer: These are affiliate links and as an Amazon Associate I earn from qualifying purchases
-------------------------------------

Sound like me:
-------------------------------------

Video like me:
-------------------------------------

PC Stuff:

[holdenchen]

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!

[georgeseese]

re: self.con.commit. Suggestion to use Context Manager (with self.con: self.cur.execute("""INSERT etc. ) commit and close are not needed.

[smalltardigrade]

Just saved a Digital Assignment with this.
You!!

[finkyfreak]

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!

[ammaralzhrani]

You are my teacher thank for all your tutorials.

[peterkim]

Thanks mate. This is really cool especially doing it in OOP way

[georgeseese]

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").

[AlmoGamingHD]

Another fantastic Tutorial! Keep with this great Work!

[ivanmihaylov]

Thank you very much, buddy! :) Keep making good videos!

[GeorgyKizesov]

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!

[Kyosika]

Never worked with SQLite, time to give it a shot. Is it similar to Google's Big Query?

[georgeseese]

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?

[Henry_Nunez]

Sera posible la ventana donde te muestras un poco mas pequeña por favor. 🙏

[majdmustafa]

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

[randomdude]

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

[samnfs]

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.

[mohammademal]

how to Store large number of data into sqlite? using python?

[mohammademal]

How to convert the large number of data from csv to sqlite?

[graczew]

Second :) do i get pin ;) :D:D:D great content as always!