How To Install SQLite on Mac

Ready to start exploring data?
In this video, we'll show you how to download and install SQLite - a database engine used to access and manage relational databases - on your Mac computer. You'll also learn how to find sample datasets, explore data in your Mac terminal, and dive deeper into the data on your own.
Before getting started with SQLite, it helps to have some background knowledge of SQL and the command line. To get started, check out the courses and content below.
- What is SQLite?: bit.ly/3c3jD9F
- What is a Relational Database Management System?: bit.ly/3wDKeRN
- Learn SQL: bit.ly/3QCNrZt
- Learn the Command Line: bit.ly/3dAsIXD
- - - - -
Join the millions learning to code with Codecademy.
Learn to code: bit.ly/3K5wQuS
Check out our full course catalog: bit.ly/3K5wCnw

[@bbulliard]

Wonderful video! Thank you

[@Errlyy]

my terminal doesnt read cd~and after typing .schema nothing pops up even though ive made sure to choose where i have it saved. what am i doing wrong?

[@yufliu]

you need to add a space between cd and ~ like "cd ~" NOT "cd~"

[@khoatruong91]

@@yufliu I added that but nothing happened.. anyone know what I can do

[@MrPaulkool]

Great video, very useful thank you

[@successbound24]

Great video information in the video! My complaints are; 1. The closed caption obstructs the view of the commands being typed, making in more difficult to follow along while practicing and, 2. There should be clearer instructions on how to get the data site on Stanford instead of just jumping to it.

[@meriaphan]

You can turn off the CC or drag it to the top

[@leemzx9730]

Hi Rob, I hope someone from codeacademy can help me with this. I downloaded SQLite and all the steps went well (for my mac) until I attempted to down the data starter pack. I always get an alert saying I need to find or download an application to open the date with?? Super stuck. Been trying to figure it out for ages. Is it because I'm based in the UK or have I not really downloaded the SQLite? Thanks :)

[@alejolawyer]

what is the specific command to install like codeacademy said? they said we need 3200100 version, but I can not see any command to install that version, it comes with another more recently. thank you.

[@naganikhilbijjala1000]

I never thought this would be that easy. I struggled a lot for setting MySQL on my system. But this is done just in 1 to 2 minutes

[@eirikureiriksson5035]

Hopefully it will work for me

[@TURALOWEN]

Thank you!

[@fulvoma512]

Up until this point in the course codecademy has been holding my hand and going step by step... but as soon as it got the page where I am to download and attach to databases it ASSUMES that I know SO many things, Git Bash, and directories, and how to speak to the terminal, and even when I'm following the steps in the video it is not doing the things it is doing for him. So frustrating. Why did you all decide to give up on the SQL course right at the point of application?

[@fulvoma512]

Example: I am supposed to type "cd ~/Downloads/sqlite-tools-win32-x86-3200100/sqlite-tools-win32-x86-3200100/." into the terminal. that doesn't work. Well, probably because I did what the man in this video told me to do, which was moving the file to my own folder OUT of downloads. So I use the directory there: "cd ~C:\Users\Admin\Desktop\Learning\sqlite-tools-win32-x86-3380200" that doesn't work. So I drop the "C:\Users\Admin" and try it again, but the same issue. No such directory found. Why all this struggle? And why are the dashes going the opposite direction now between the example they shared and the actual directory? Completely in the dark here and it's like they go from holding your hand to pushing you off into the deep end without help, except actually there is help, it just sends conflicting signals that don't go with the actual instructions on the page...

[@emilioariston]

My Mac mini stops the install as it is form an unknown source. How do I override that?

[@sergiizakharchenko6084]

It was pretty confusing for me. I wish he showed links to web pages when he switched from one website to another. For example, how can I find the "SQLite Data Starter Packs" page?

[@jeffreyharding4263]

google it ....

[@kabigyakarki5761]

Where is the link to download the sqlite?

[@ManontheBroadcast]

sqlite3 comes pre installed on a mac... should i use this or do i have to re-download it ? ... Thanks...

[@fulvoma512]

weird how there is no support for the questions here

[@mofo888]

Does this work on a M1 mac?

[@viniciustinoco7188]

Does anyone know where can I download the SQLite Data Starter Packs from? Thanks in advance!

[@sazimi101]

I have the same question! Just messaged Codecademy

[@catalitt]

do you have the answers for these questions?

[@lyudmilastarodubtceva801]

1) District 15, New York has the highest poverty population: 285896 2) If you don't count null values then Montana has the lowest amount of immigrants: 21356 3) New York has higher asian population: 1196134. LA has 451761

[@westonclarke4546]

@@lyudmilastarodubtceva801 Can you share the commands for question 1 and 3? I got the same district for 1, but with a different population. Answer to 1 shows: Congressional District 15 (114th Congress), New York|762550 For question 3, how did you search for asian population by city? Thanks!!

[@abbierevolution]

@@westonclarke4546 question 1: SELECT name, below_poverty_line FROM congressional_districts ORDER BY below_poverty_line ASC; question 3: SELECT name, asian FROM places ORDER BY asian ASC;

[@ZlajaDivjakinja]

I have figured out Further Queries 2/3 except which place has the higher Asian population: NYC or LA. The OR and City specific thew in a curveball

[@yufliu]

For my answers I got the following, let me know if anyone has a better way of doing it: #1 SELECT name, below_poverty_line FROM congressional_districts ORDER BY below_poverty_line DESC; #2 SELECT name, foreign_born_population FROM states ORDER BY foreign_born_population ASC; #3 SELECT name, asian FROM places WHERE name LIKE 'Ne%' OR name LIKE 'Lo%' ORDER BY asian DESC;

[@lioha88]

Not sure if it's better but a bit different: #1 SELECT name, below_poverty_line ...> FROM congressional_districts ...> ORDER BY below_poverty_line DESC ...> LIMIT 1; #3 SELECT name, asian FROM places WHERE name = 'New York city, New York' OR name = 'Los Angeles city, California' ORDER BY asian DESC;

[@SNEEDANDBREED]

E

[@user-ih2fq1ck2q]

these instructions dont match up with the instructions provided in the tutorial: For Macs, use the Mac OS X (x86) sqlite-tools package: 1. Install it, and unzip it. 2. In your terminal, navigate to the directory of the unzipped folder using cd. 3. Run the command mv sqlite3 /usr/local/bin/. This will add the command sqlite3 to your terminal path, allowing you to use the command from anywhere. 4. Try typing sqlite3 newdb.sqlite. If you’re presented with a sqlite> prompt, you’ve installed SQLite! Enter control + d to quit. You can also exit by typing .exit in the prompt and pressing return.

[@jcmm0305]

Those are my answer: 1.- Congressional District 15 (114th Congress), New York|285896 2.-Montana|21356 3.-New York city, New York|1196134

[@reecehowell5596]

All great until i hit ".schema" Nothing comes up any solutions?

[@windowfries]

I figured it out. When you're in the terminal and you're typing out the acs-1-year etc, make sure that you type 2015.sqlite NOT 2015-sqlite If you use the dot instead of the dash it should work, at least that is what helped me

[@charleshebert8434]

so a newer version comes up on mac, and when I press .schema nothing happens ideas?

[@twostories7264]

make sure you choose desktop (or wherever your sqlite file is saved) in the terminal before you go to sqlite. if you're not in the right location it won't read your table so there will be no schema to show