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.
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.
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.
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.
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 :/
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?
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
I cannot get this to work. Has anyone made this work? Please link me a tutorial if you have! I really want to do the Data Engineering career path but I am utterly stuck on this part.
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.
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.
@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?
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!
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....
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
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
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?
It doesn't work on my side. It just keeps on saying command not found. I tried many times. I even downloaded Gitbash still it does not work. just a suggestion, maybe a new video version of installing it would help.
This still is not explained well. Codecademy READ YOUR COMMENTS and make improvements. This video is NOT helpful and is very confusing. If Martin still works for you he should be let go because he has no teaching abilities whatsoever. This would be acceptable for a free course but this is not a free course. This should be explained clearly and easy to understand. SHAME ON YOU for not updating this after years of horrible comments!
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.
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.
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
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?
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.
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).
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
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
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.
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?!
Someone should really try to imagine what a starting person is using and show it step by step. Choosing other command line app on purpose shows how poor this person's teaching skills are.
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.
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.
Exactly, Many steps have been skipped to create the illusion of simplicity - not good
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.
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.
Why Codecadamy still didnt replace this helpless video?
Been two years since your comment, this video is still attached
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
And 3 years @codecademy... Please update this...
I WAS ABOUT TO THROUGH AWAY MY LAPTOP, but thanx to this comment section i see im not alone
i don't comment often but had to today, to say this tutorial needs to be redone. The comments were more helpful
ahahahha
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 :/
VSCode has a SQLite extension. Simple installation
This needs more upvotes. Save yourself some time peeps
Same as question below. how do I get that git bash thing to work? Nothing seems to be working from the tutorial provided
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?
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
I cannot get this to work. Has anyone made this work? Please link me a tutorial if you have! I really want to do the Data Engineering career path but I am utterly stuck on this part.
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.
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.
@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?
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!
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....
Hello Codecademy? My question /comment is the same as everyone else below.
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.
For git bash users if you want the same command type:
$ alias Sqlite3="winpty sqlite3.exe"
I followed your instructions. but it is not working ((
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
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
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?
It doesn't work on my side. It just keeps on saying command not found. I tried many times. I even downloaded Gitbash still it does not work.
just a suggestion, maybe a new video version of installing it would help.
What shortcut did he use to clear the terminal?
ctrl+c
ctrl + c is to exit sqlite env, after exit, can type clear + enter , hope still can help you after 1 year
should be clear
This still is not explained well. Codecademy READ YOUR COMMENTS and make improvements. This video is NOT helpful and is very confusing. If Martin still works for you he should be let go because he has no teaching abilities whatsoever. This would be acceptable for a free course but this is not a free course. This should be explained clearly and easy to understand. SHAME ON YOU for not updating this after years of horrible comments!
it s outputting error " no such table : states" i tried state as well and names of other tables as well
Resolved: the file was 0 kbs made some mistake downloading
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.
My zip file doesn't even have an .EXE file in it. this makes no sense
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.
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
I ask chatGPT to complete git bash terminal comand line problem
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?
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.
Can I use the 32-bit tools if I'm on a 64-bit machine?
I cant set up this or Git bash because im on a Chromebook what do I do?
4:13 What's the shortcut to clear the (screen) previous commands in Git Bash?
From user CKode5725
"ctrl + c is to exit sqlite environment, after exit, type clear + enter"
Ditto...
The last step does not work on my Win 7 with GitBuh. Could you please give me some advice?
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.
Was hoping this tutorial would help but it is extremely confusing and skips over a lot. Make a new one already.
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.
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
Forget about this unrelated video and star over by following the written steps before on the codeacademy page and save yourself some headache
the last step does not work on git bash
Just out of curiosity, was this really uploaded two days ago?
helpful.
It didn't work for me and I don't know why
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).
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
Lol This is a Windows instillation, but you don't use command prompt or powershell....
Codecademy specifically has us use Git Bash.
Not easy for beginners
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
Thanks bro! It helped me much)
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.
This doesn't work!!
This video is terrible and needs to be replaced! Not sure what this guy is on about! Not Happy!!!!
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?!
yeah, no. worst tutorial ever
nothing works
the most useless video ever. super irritating wow
helpless video for beginner, . Can not follow him
Rubbish tutorial, doesnt explain properly
Helpless video, nothing works and I don't understand anything. It demoralizes me and other beginners
Someone should really try to imagine what a starting person is using and show it step by step. Choosing other command line app on purpose shows how poor this person's teaching skills are.
This video made me unsubscribe from Code Academy. Make a better one
this video is not helpful for a complete beginner as this skipped a few steps
@codecademy this video is outdated and should be updated. Disappointed
and I paid monthly fee for this dont understand nothing ...
this walkthru is garbage. don't waste your time
i am a beginner and that video does not help