Creating a database, table, and inserting - SQLite3 with Python 3 part 1

Welcome to an SQLite mini-series! SQLite, as the name suggests, is a lite version of an SQL database. SQLite3 comes as a part of the Python 3 standard library.

Databases offer, typically, a superior method of high-volume data input and output over a typical file such as a text file. SQLite is a "light" version that works based on SQL syntax. SQL is a programming language in itself, but is a very popular database language. Many websites use MySQL, for example.

SQLite truly shines because it is extremely lightweight. Setting up an SQLite database is nearly instant, there is no server to set up, no users to define, and no permissions to concern yourself with. For this reason, it is often used as a developmental and protyping database, but it can and is used in production. The main issue with SQLite is that it winds up being much like any other flat-file, so high volume input/output, especially with simultaneous queries, can be problematic and slow. You may then ask, what really is the difference between a typical file and sqlite. First, SQLite will let you structure your data as a database, which can easily be queried, so you get that functionality both with adding new content and calling upon it later. Each table would likely need its own file if you were doing plain files, and SQLite is all in one. SQLite is also going to be buffering your data. A flat file will require a full load before you can start querying the full dataset, SQLite files don't work that way. Finally, edits do not require the entire file to be re-saved, it's just that part of the file. This improves performance significantly. Alright great, let's dive into some SQLite.

[pradyothshandilya]

These are really good man! I'm not sure why people even go to college anymore. People like you and bucky from thenewboston teach more in a day than I would learn in a semester

[squaresdotcom]

u r helping lots of people worldwide by your knowledge and u will have a place in heaven

[jasonarthur]

who are the two specials that didn't "like" this?
These are amazing. Thanks dude.

[viallykazadimutombo]

In one word, you're simply the "best" in Python

[BrandonJacobson]

Just ran this code today (7 Jan 20) and it worked perfectly. I'm going to give you a huge shout out in my next YouTube video. Just in case one of my 1, 133 subscribers (LOL) hasn't seen your channel.

[markosaric]

Awesome tutorial! I only needed part 1 and 2 to finish what i was building, but it was extremely helpful! Thanks!

[ericBorja]

I've recently been learning a bunch about programming in python and have stumbled upon a bunch of your videos. They're very helpful.

[nicholasrj]

I'm learning how to program as a career change (should have done that longtime ago). Your tutorial on SQLite is by far the best out there. Thank you so much for doing this!

[marquisewitsell]

Thanks. Even in 2022 this still rocks!

[darkhailhailfire]

Harrison, I love you. I was the one who made the comment about the map scanner on your other video. This will be super useful for scanning, to make it faster and more efficient.

[mitchellhayes]

i am in a Udacity nano degree program right now and it might be that this was easier to understand because it is the second time seeing this material, but holy smokes your video is very easy to follow and i just wanted you to know that i appreciate you taking the time to make and share them.

[jackbartlett]

Love your enthusiasm! its helping me resist falling asleep with all of this sql.

[crediblemulk]

I found these just at the right time. Massively helpful, well explained and saved my bacon.

[HimothyOHooligan]

I'm comfortable with python but not SQL. This was a pretty good beginner tutorial. Thanks dude

[riptorforever]

Thx for this leasson!!! From Brazil, Pernambuco, Recife !

[slickwillie]

Best video series on the subject. Even better than Corey Schafer. LOL

[AhmedAli-dzhy]

Really you make it so simple for me. I appreciate your time

[janski]

Very clear and simple, great tutorial as always!

[andreasmiles]

Dude! You rock! Really like the delivery and topics covered. Thanks a million.

[jp]

Great set of tutorials really helped me out with a computer science project. Thanks