SQLite Database with Python: How to Create Tables, Insert Data, and Run Queries

What about PyMongo?

I cracked soft soft today!

mycursor = conn.cursor()
mycursor.execute("""
SELECT * FROM MYFIRSTTABLE
""")
output = mycursor.fetchone()
print(output)
Will also do the trick an don't need to go to the site... just saying...

Thank you very much for this simple but very effective video. Your time and effort are very much appreciate here. Just a question if you don't mind: what is the advantage of using SQLite instead of just importing your data properly formatted and placed in a xlsx/txt/xml file? Anyway....thank you

Hey there,
God bless you efforts.
I am new to sql with a general enquiry.
Why using a cursor would make use of ram memory much more than views?
Aren't views produced in memory ram?
Thanks for taking care of my enquiry.

Thanks so much! I already knew SQL from my time working with php and databases and just needed help using it in Python.

thank you! It helped me a lot to clear up doubts, greetings from Argentina!

very nice