Python Scrapy Tutorial - 15 - Basics of SQLite3 database

In this video we are going to learn about the basics of SQLite3 so that we can store the scraped data in a database.

Next video - Storing data in a SQLite3 database

#python

[felixsuen]

import sqlite3

conn =
curr = conn.cursor()

curr.execute('''drop table if exists my_mind''')
curr.execute('''create table my_mind (BLOWN text)''')

curr.execute('''insert into my_mind values ('YOU SIR IS FREAKING

conn.commit()
conn.close()

# can't change my mind

[apoorvjaiswal]

love your passion bro
always with zeal and passion
"Alright guys we are back again"

[suhasjain]

create table query is not working....the colour is also not getting changed when i type """create table table"""

[ianforrest]

these videos are amazing, keep it up man!

[julianandresgomezgomez]

Hi, how could i do for pycharm recognizes, in orange, the sqlite commands?

[python]

Sir, what database would you recommend for doing a scrape with 500, 000 records?

[AliRaza-viqj]

very very very brilliant nice best awesome
good explanation... #the man of architect you are sir thank you so much

[ahmednagrapk]

while at part where we print the pipeline print("pipeline : " + item['Title'][0]) its show starting from index 1st value nor 0. kindly solve it

[alizeshan]

Hey man! Great video series. Learning a lot, in a relatively short period of time.

Just one question regarding this video.
My execute command isn't working properly. The 'Create Table' query stays green as if the "sqlite3" module hasn't been imported.
I am using Python3 so i shouldn't need anything other than the "import sqlite3" command, right?

[FunGuardian]

you can also use db browser for sqlite, good app for viewing db

[shikhartripathi]

I am having an error while installing scrapy in a new project it shows list index out of range, please help me out

[fredbarnes]

This only works for me if I don't create the curser and do conn.execute('sql')

[abbasnoufal]

when i import sqlite3 it doesnt create a db file why?

[rishab]

database is created but the value is not getting stored in it. can anyone please help?

[antonioja]

hi there youre amazing man,
i cant find error for the
curr.execute('''insert into my_mind values ('YOU SIR IS FREAKING
pycharm says that is unable to resolve table