SQLite Database With Python - #24

In this video I'll teach you how to use the SQLite database in your Python Programs! Most people don't know that Python comes with SQLite installed already, there's nothing to do to install it! In this video I'll show you the very basics of using it.

In this series I'll teach you to program with Python in 2019.

Grab My SQLite Python Course at Codemy:

✅ Watch The Other Videos In This Python Playlist:

▶️ See More At:

✅ Join My Facebook Group:

✅ Subscribe To My YouTube Channel:

Take $22 off with coupon code: youtube

[DP-xzcc]

A fun fact is that actually in a project i worked in, for Mercedes Benz, this corporataion also used SQLite for its corporate sales systems to keep the data locally available for its salesmen. Thus, i think SQLite has a huge impact, even outside of the android world, where it is also used extensively. Btw. i find this "wrap up" video at the end of the tkinter/sqlite lesson really valuable!

[manafalbayati]

you are the best :) thanks a lot ! I'm following all your classes in python

[michaelbrunetti]

Thanks! I needed to perform some simple interactions with a table in our db. This helped me get started on that!

[SophisticatedCashew]

I really appreciate your videos. Thanks.

[immortalsun]

I like how you’re using unregistered Sublime Text.

[noname]

I like so much your videooss 💖. But I have a question of how can I insert a full text in database (sqlite) ?

[LandNfan]

Can the elementary data items be referenced by name, e.g. customer.first_name? That would make it self-documenting and eliminate the need for many comments. Sorry if that’s a dumb question. Chalk it up to my first programming language being COBOL 47 years ago.

[benwilliams-ksp]

when I try to put in c.execute("""CREATE TABLE customer() """), it just thinks it is a string, apart from that, the script is identical up to that point. Why would that be?

[aesharao]

I am trying to create boxplot for SQLite database. Can you help me with that please?

[parsabahrambeik]

Hi, Thanks for your videos. Please show me just one video in your video list that has a clear connection to MySQL or SQL Server database. This is almost my only problem with Python. .

[s-rich]

is there a way to import images into an SQLite database and then randomly select them in python?

[larrycash]

I'm trying to find a way to import CSV to SQLite 3 without using a library's

[SandeshKarumuri]

I have data in database as <h1>codemy</h1>
What to do to print on to the browser as a heading formatted Codemy??

[lisalpeiris]

hello, can you insert form data from HTML?

[theNewMaker]

Hi
Am just a follower from Sudan you can search in Google about it so you can know how hard to reach your courses I wish I have dollars to pay you really worth it it's so fanny even if I have I can't buy it because we can use any kind of master card or visa card est...
Between focus in understanding English and understanding python now I have to find another way to get sgl3
I wish you luck and keep it up