How To Install SQLite on Windows

SQLite is a database engine used to access and manage relational databases. In this video, we'll show you how to set up SQLite on a Windows computer, where to find sample datasets, and how to start running queries.
Before diving into SQLite, you'll need a solid understanding of SQL and the command line - which you can learn about in the courses below.
And if you want to learn more about SQLite and relational databases, check out the following articles.
- What is SQLite?: bit.ly/3pwDZei
- What is a Relational Database Management System?: bit.ly/3AyO80q
- Learn SQL: bit.ly/3A8ckp9
- Learn the Command Line: bit.ly/3SYKhRw
- - - - -
Join the millions learning to code with Codecademy.
Learn to code: bit.ly/3c3GZf6
Check out our full course catalog: bit.ly/3K65RQ0

[@ljreyes01]

The step by step instructions that precede this video skip over the installation instructions for Git BASH and this video doesn't even use Git BASH as a terminal. For a beginner, we are really skipping over a few things. I reinstalled GIT 3 times already trying to recreate the "alias" command and no luck.

[@seradfb345]

I agree, no-one had ever mentioned installing a console on my course up to this point. I just started out and installed Cmder now but can't get the states up, just error messages.

[@alexissanchezbro]

Exactly, Many steps have been skipped to create the illusion of simplicity - not good

[@bokimitrovic9269]

Why Codecadamy still didnt replace this helpless video?

[@tom.b.6174]

Been two years since your comment, this video is still attached

[@YeHnJaCk]

i've no clue wtf i am doing in that page that links to this video. the video doesnt do what the text says at all

[@dianagabrielaaldeanquinter4940]

Very confusing! the worst is that Codeacademy send me here so I thought it would be reliable but I ended up losing a lot of time messing around with a video that shows a step by step that doesn't work on Git BASH :/

[@tha_karatejoe]

VSCode has a SQLite extension. Simple installation

[@solaawodiya7360]

I tried working on the Bash prompt but no progress. Also, the file you downloaded is for 32 bit systems which brings the question that can it be used on a 64 bit system? It's not very helpful that you didn't explain that

[@spencermerlis1687]

There needs to be a link to how to download and CMDR, which he uses, or Git-Bash, or some other such terminal, along with links to FAQs and Troubleshooting. The video is useful in terms of watching, not doing. It doesn't do what it needs to for students. There are missing pieces of the puzzle.

[@spud1300]

Can I use the 32-bit tools if I'm on a 64-bit machine?

[@jepool117]

So a few updates that I have pieced together for everyone who is only able to download the x64 bit version. After downloading you need to add this path to the directory, which will enable the Codeacademy steps to be actually be followed. Once the file how been downloaded and unzipped, go to 'This PC' right click and go to 'Properties' > 'Advanced system settings' > 'Environment Variables...' > Then in the SECOND WINDOW called 'System variables' scroll down the the variable called 'Path'. Once that has been highlighted click 'Edit...' Then go to 'New' > 'Browse...' then find the file folder that is sqlite-tool-win-x64 etc wherever it has been downloaded and click ok to add as a path. Still learning things, but at least this will make it show up in BASH - good luck all

[@hamidesbergenov9274]

I followed your instructions. but it is not working ((

[@BAMboozzleya]

I cant open the starter pack from git bash I download it and add it to the sqlite tools file but it still doesn't list it when I type ls on git bash what am I doing wrong?

[@moose3136]

After you run this command (winpty ./sqlite3.exe) and then you get to the (sqlite> ) prompt. What worked for me was to then type .open acs-1-year-2015.sqlite, for the gitbash users its suggested in the prompt, afterwards you can manipulate the tables.

[@strangeDog]

I ask chatGPT to complete git bash terminal comand line problem

[@3Wolfuck3]

The last step does not work on my Win 7 with GitBuh. Could you please give me some advice?

[@bernardoquina3047]

For git bash users if you want the same command type: $ alias Sqlite3="winpty sqlite3.exe"

[@rubentar3641]

This is a very poor tutorial @Codecademy. If your objective is to make learning code easy, seamless and straightforward this needs to be updated. Skipped way too many steps, did not elaborate on keyboard shortcuts used in git bash, etc. I had to watch tutorials from competing educators to understand how to use SQLite offline.

[@rubentar3641]

@3:27 "I"m using cmder due to personal preference, but most other terminals like Command Prompt, Git Bash, and Powershell work similarly." Why would you do this if you told us to exclusively use Git Bash in the previous video?

[@Kyleandbet]

Hello Codecademy? My question /comment is the same as everyone else below.

[@thejquinn]

I cant set up this or Git bash because im on a Chromebook what do I do?

[@user-jt7td1ox2q]

4:13 What's the shortcut to clear the (screen) previous commands in Git Bash?

[@MarvinDHernandez]

From user CKode5725 "ctrl + c is to exit sqlite environment, after exit, type clear + enter"

[@elharrison10]

Ditto...

[@jaredvillarreal1505]

is there a better tutorial that actually shows you how to install this and check to make sure it works? this guy did a horrible job of explaining things

[@chaupham2594]

What shortcut did he use to clear the terminal?

[@manhtran9568]

ctrl+c

[@CKode5725]

ctrl + c is to exit sqlite env, after exit, can type clear + enter , hope still can help you after 1 year

[@arghyadas2836]

should be clear

[@muniisauce]

i don't comment often but had to today, to say this tutorial needs to be redone. The comments were more helpful

[@gustavosolaeche674]

ahahahha

[@Kst_diana]

I WAS ABOUT TO THROUGH AWAY MY LAPTOP, but thanx to this comment section i see im not alone

[@bri276]

Sooo you guys don't care about people who are trying to learn SQL anymore, and won't update this information or help anyone asking for it. Noted.

[@BlissAden]

The instructions of this video does work on 19/10/2022. But on the end of you want to quickly open any sqlite3 file then use the 4 steps @Kiyoo's Wrld comment

[@charkee167]

This sucks. @codecademy please remake this awful video. It skips around to much and the thing written on your website isn't even related. It says use gitbash which you have to download. But in this video the person isn't even using git-bash....

[@sergismael]

helpful.

[@anythingstuff4605]

the last step does not work on git bash

[@mohammedtariqmohiuddin217]

By far this has to be the most useless video, the instructor is clearly unaware of the instructions mentioned on the website and due to his personal preferences has skipped the installation steps. requesting help from experienced programmers for installation of sqlite and GIT

[@user-xc9iu9ur4b]

Did anyone actually managed to solve this? I get lost about the 3.40 mark and can't get the files to show in the Git Bash. This is a really frustrating video Codecademy!

[@dinisharob]

My zip file doesn't even have an .EXE file in it. this makes no sense

[@chaitanyasundaram4024]

This doesn't work!!

[@clouddude7783]

Was hoping this tutorial would help but it is extremely confusing and skips over a lot. Make a new one already.

[@harmonydale8896]

This video has annoyed me and wasted so much time. Do better Codecademy. This video hasn't been up long enough for the course to have changed - how about you provide an instructional video that actually flows and provides enough detail for those in a beginner level class.

[@beautymahajan]

Not easy for beginners

[@joaopedrozardi4087]

Not helpful at all for beginners... I'm on the go-off-platform stage of a data scientist track and this video does not help me in anything besides making me even more confused about how those command prompt simulators work... I still have no idea how to use SQLite out of the platform

[@Obirtae]

Forget about this unrelated video and star over by following the written steps before on the codeacademy page and save yourself some headache

[@bigRed90]

Followed right along with this video as part of my SQL module - Very little variation on my system from his and got the exact same outputs with ease. This was fun, and I'm really enjoying learning this way.

[@lunas8280]

nothing works

[@saras6588]

Yet another disappointing Codecademy video. I'm starting to regret my Pro paid membership. Here's a pro tip: don't pay for their classes.

[@DaBearsManiac2]

Lol This is a Windows instillation, but you don't use command prompt or powershell....

[@MarvinDHernandez]

Codecademy specifically has us use Git Bash.

[@felix-ve8jk]

I love codecademy but this really is one of the worst videos you guys have put out. I've gone through the SQL course and worked with MySQL for 2 years.

[@gustavosolaeche674]

how did u do to install the cmd and run the database example? please. i cant really run it and i dont know how to

[@goyslee]

I don't understand why some people have isues with this. Simple instructions to follow and all works, I have even forwarded some part of it.

[@flatline2258]

I have to agree with the majortiy of the comments that this video guide is not helpful if one is new or wishes to follow Codecademy's own instructions. For those who are having issues following the: echo "alias sqlite3=\"winpty ${PWD}/sqlite3.exe\"" >> ~/.bashrc and source ~/.bashrc steps, I found that replacing the "${PWD}" part with the full directory path fixes it. It might also be because whatever folder name you have has a space in it (like I did).

[@logansharon8868]

This video should just be deleted outright. Not helpful in any way. The data files aren't even available for download anymore and can't seem to be found anywhere. I mean there isn't even a desc for this video? Seriously CodeCademy? I paid for your pro version FOR THIS?!

[@doms_cinema]

and I paid monthly fee for this dont understand nothing ...

[@Ali-ys5vk]

i am a beginner and that video does not help

[@iamakii]

this video is not helpful for a complete beginner as this skipped a few steps

[@foliesimultanee414]

Helpless video, nothing works and I don't understand anything. It demoralizes me and other beginners

[@thophamvan1358]

helpless video for beginner, . Can not follow him

[@Anthonyrharrod]

@codecademy this video is outdated and should be updated. Disappointed

[@jovcha]

This video made me unsubscribe from Code Academy. Make a better one

[@bradxwx]

this walkthru is garbage. don't waste your time

[@kofiyeboah8732]

the most useless video ever. super irritating wow

[@nonsensesocks204]

I did not find this video helpful after the 3:40 mark. this is especially irritating because the video is linked directly below instructions on how to download sqlite using git BASH as a terminal and then you've attached a video instructing us how to do it using a different terminal. For beginners this makes learning challenge. expected of a free learning program -more than a little disappointing as a subscriber to the pro paid membership. I will be taking this into consideration when deciding whether to continue paying for my subscription.

[@owenchang2290]

I agree. That is exactly the part of the video where I got lost today. I posted my inquiry with screenshots on the Codecademy community forum. Really hoping to get a solution to the issue.

[@CarLos-by5xl]

Just found this out, ON 3:48 mark **FOR GIT BASH USERS** mark instead use $ WINPTY ./sqlite3.exe YOUR_FILENAME.sqlite then hit enter.

[@creightonfowler1909]

Thanks!

[@sakibulislam938]

Thanks!

[@anthopantho3283]

Thank you!

[@carroyoca100]

YOU ARE A BEAST

[@techstar4775]

Same as question below. how do I get that git bash thing to work? Nothing seems to be working from the tutorial provided

[@StackReacher]

This has jumped right into GIT without there being any tutorial on codeacademy on how to use it. I have wasted a lot of time trying to get the commands to work. Perhaps upgrade the course to teach you how to use it first?

[@carlos_gonri]

​ I change the name of the file to states.sqlite and finally worked, that way I could query the "states" table, otherwise how could I know what the name of the table is if it's not for the video?

[@shoaibamin2074]

it s outputting error " no such table : states" i tried state as well and names of other tables as well

[@shoaibamin2074]

Resolved: the file was 0 kbs made some mistake downloading

[@PoorGamerGaming]

Just out of curiosity, was this really uploaded two days ago?

[@ysa722]

It didn't work for me and I don't know why

[@TipaFilosoph]

Thanks bro! It helped me much)