How to store data with Python and SQLite3

If you are not storing your data into a database yet and aren't sure where to start let me help you - use SQLITE. In Python we have easy access to sqlite databases and I will show you how to easily create, connect and add data to you new database, including a project based example, where we don't want to add data that already exists.

Support Me:

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

[thebuggser]

Very nice overview of creating and viewing a database.

[tubelessHuma]

SQLite is very easy as compared to other databases. A short but very useful video.👌👍

[deeperblue]

Really helpful and great stuff. Thanks John.

[eugenepierce]

Thank you, John!
You're doing an amazing job by sharing your knowledge with others in such a great form.
Wish you all the best!

[mrklopp]

Thank you for this! Keep up the great work.

[AlexRodriguez-dojx]

As an extension to this tutorial would be really cool to see a way of hosting this sqlite3 database instance in a docker instance w/redis or something. Nevertheless excellent video, super practical. Love your content.

[rugvedz]

Thank you for the videos. I've learnt a lot from you. Can you please make a video about handling captchas without using selenium?

[wknd]

hey that was wonderful, could u make a video on when amazon blocks from scrapping or shows captcha . because the way you explains and teaches the things are really really easy to copup with . Thanks

[camp]

would be cool to see this as part of a scrapy project e.g. in a pipeline

[FabioRBelotto]

Great video.
Can you talk a bit about using sql "create table as" in python?

[Daalen]

Thanks John! Really helpful again.

A while back you mentioned a video for deploying to Heroku, is that still in works?

[patrykdabrowski]

Hi John,
Could you please share your VSC settings which you were usingin previous videos?
The theme looks pretty good and terminal also!

[ammadkhan]

Could you please make some video about using microsoft graph API to access outlook or sharepoint with some steps to Register the app

[businessman]

Amazing video! Could you do a video on web scraping using a VPN network as a proxy? For example, using Protonvpn or Nordvpn for scraping data from amazon? Thanks!

[bisratgetachew]

Great Video once again. Can you please finish the fastapi video? Thanks again

[dzeykop]

Hello John thank you for amazing, really amazing video again.
You lessons are awesome and it looks so easy. 😊😊😊👏👏👏
P. S. Please, Please, make a course on Udemy about all the Python stuff and I buy it immediately 😎😎

[gentrithoxha]

Hello, great content.I wanted to ask a question that i have looked in Google so long couldn't find answer. Is it possible to use selium in headless mode and then when a get 200 response open that same request in gui mode? I would appreciate if you respond to this.

[DM-pypj]

At no point do you close any of the connections. Does this mean you have a load of open connections in the background or is there some sort of (out of scope?) clean-up?

[trungnguyenduc]

Hi, Can you guide us how to create new sheet in workbook everyday for data update.

[asmuchican]

John I think mongodb is better than sqlite for crawling multiple spiders. In sqlite we have to write more codes and gives unnecessary errors related to pipelines and database connection. For complex and large project mongodb is better.