SQLite3 Tutorial

Welcome to my SQLite3 Tutorial! This tutorial is part of my Android Development Tutorial, so my Android tutorial is not over. I have many more videos on Android coming.

In this video I explain how to install SQLite3 on both Mac and Windows. I also cover how to use SQLite3 using the console. SQLite is an embedded relational database that doesn't require a dedicated database management system. The database is part of your code and not an outside resource. The reason for creating SQLite was to provide a self contained database that was easy to use, could travel with the program using it and run on any machine with no other required software.

[pratyushbarikdev]

Best tutorial on SQLite. Fast paced. Saves a lot of time. You have the best tutorials on youtube. Thank you. :)

[mbigras]

This was such a fun video to watch! These are the only videos I don't speed up
1. Because I find you move at a very engaging pace
2. Because it's just plain fun listening to you present information and I don't want to muck it up by speeding up the video.

[Whuffle]

Dude, once again - stumbling across your videos while looking for something and you've explained everything so briefly and eloquently, it's perfect for a beginner-intermediate like me. Thanks!

[svmathtutor]

Thanks again Derek. Update: Regarding choice of Windows file to download at 4:55, as of 2018 Feb 28, the 3 choices are now ---> Precompiled Binaries for Windows

(438.67 KiB) 32-bit DLL (x86) for SQLite version 3.22.0.
(sha1:

(729.28 KiB) 64-bit DLL (x64) for SQLite version 3.22.0.
(sha1:

(1.62 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exe program, and the sqlite3_analyzer.exe program.
(sha1: <-- I believe nowadays (2/28/2018), this 3rd file is the one we need to click.

[derekbanas]

It isn't a replacement for powerful databases if you need complex calculations, or if the database is large, but for most Tablet apps and small programs it works great

[bkboggy]

Thank god! A video about SQL that I can understand or not want to blow my brains out while I'm struggling to make out what the person is saying or falling asleep while waiting for them to spit out their thoughts. Thank you.

[randbabs]

just when I'm about to say how amazing SQLite is, I try to use change output to file (on Windows), and oh what a headache 

for those experiencing the same problem, the answer is using single quotes around the file name    

[rorosamy]

from SQLite wiki:
D. Richard Hipp designed SQLite in the spring of 2000 while working for General Dynamics on contract with the United States Navy.[7] Hipp was designing software used on board guided missile destroyers, which were originally based on HP-UX with an IBM Informix database back-end.

LOL this is crazy!

thank you for all you vidoes, I LOVE YOU!

[derekbanas]

You're very welcome :) I thought about using a GUI tool with SQLite, but I decided that it may be easier to teach with the terminal / command line. Before I'm done who knows what all Ill cover though.

[LalakaJeerasinghe]

Oh Thanks!
I was doing an assignment with PHP & SQLite. This was great use, especially the html table output. Looking forward for your SQLite3 2nd part and the rest of the android tutorials.

[chase-bank]

Oh thank the gods.... I'm in over my head, treading water, have been searching high and low for an easy nosql solution compatible with vuejs and phonegap. Finally gave in and gave up. Decided sqlite is my next best hope. Searched for a video tutorial... saw the author avatar. YES! It's Derek. I don't know if this'll work out, but I know I'm in good hands...

[jonlbs]

Yep... Here it is almost 5 years later and it's hard to beat your tutorials .. God Bless __ I hope all continues to be well :)

[MrValentas]

Do as you please. It's your time you offer to us. Don't do things you don't feel like doing at the moment. Just do vids that you think are fun for you. Then the best quality will follow.

Cheers, Valentas

[derekbanas]

SQLite is limited data type wise and in general. You wouldn't use it for a very complex database, but if your data isn't complex it works great

[derekbanas]

Thank you very much :) There is no need to donate. Your appreciation is all that is required

[derekbanas]

SQLite is pretty good about importing just about any SQL code from another database. Just export from the other database and import into SQLite. Just understand that SQLite is very limited datatype wise. I get into all that as the tutorial continues

[derekbanas]

You're very welcome :) The next video will be up tomorrow.

[derekbanas]

You're are very welcome :) It is very nice to hear that I cleared SQLite up.

[derekbanas]

Yes I will definitely make a bunch of games. I just want to get through all the basics first. The videos will come out on a regular basis for at least the next 2 weeks

[derekbanas]

Yes it is 1080p. YouTube probably didn't finish processing