Welcome to the Treehouse Community
The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.
Databases with peewee ORM
Everytime I type sqlite3 with the name of my database in my command line I'm getting this error: "sqlite3 : The term 'sqlite3' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1
- sqlite3 diary.db
- CategoryInfo : ObjectNotFound: (sqlite3:String) , CommandNotFoundException
- FullyQualifiedErrorId : CommandNotFoundException" Which I don't understand because I thought SQLite itself was already installed in python. I'm not sure if this matters but I am using Visual Studio Code as my IDE. Can someone please tell me what I'm doing wrong???
Megan AmendolaTreehouse Teacher
I had the same issue when I tried to run this command on my windows computer for the first time during a livestream. I talk about it in this video starting at about 4:20.
I'll also try to this out the steps here as best as I can:
1) Download SQLite - Select Precompiled Binaries for Windows choose either the 32 or 64 bit one.
2) Unzip the folder - it will download as a zip file, so you will need to unzip it.
3) Create a folder on your computer called sqlite - mine is inside of my docmuents
4) Move the unzipped folder you downloaded into this new folder called sqlite
5) Now you need to add this location to PATH - I followed these directions NOTE when you get to the step where he says to click new and type in your location, click browse instead. This way you can navigate to the folder and save it to PATH that way. I think it is a lot easier than trying to remember how to type its location.
6) Restart/reopen the terminal
7) Then you should be able to run
sqlite3.exe diary.db to open your db in the sqlite shell
Thank you so much!!
Hi. Megan, or anyone else...
I followed all these steps, and then restarted my system. I'm still getting the same error code Jayda quoted above.
If I run
C:\>echo %PATH% it shows up and seems to be installed correctly.
Any other thoughts about what might be going on?