Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Matthew Goodman
12,786 PointsPython Sqlite3 on windows 7
Following Kenneth Love Python DB with Sqlite3 but when I type sqlite3 in the cmd gives me this error below.
'''C:\Users\Matt\Documents\GitHub\database [master +8 ~0 -0 !]> sqlite3 student.db 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 inc luded, verify that the path is correct and try again. At line:1 char:8
- sqlite3 <<<< student.db
- CategoryInfo : ObjectNotFound: (sqlite3:String) [], CommandNotF oundException
- FullyQualifiedErrorId : CommandNotFoundException
C:\Users\Matt\Documents\GitHub\database [master +8 ~0 -0 !]>'''
I have checked the path tried adding the path I dont know what I have done, Please help me. Thanks
4 Answers
Kenneth Love
Treehouse Guest TeacherDo you know if SQLite is installed or not? If it's not, you can install it [from here]. Get the pre-compiled Windows binary that matches your system's architecture (32-bit or 64-bit).
Matthew Goodman
12,786 PointsI was under the impression that it came with Python 3.5 I downloaded the binary and tried to install it but was told had to add it to the correct path which I think I did but still didn't work
Kenneth Love
Treehouse Guest TeacherPython 3.5 comes with a library for using SQLite, but the actual database system will still need to be installed. You might need to restart to find out if it was added to the PATH or not.
Matthew Goodman
12,786 PointsSorry to sound daft restart the laptop ? And thank you so much I really love your courses.
Kenneth Love
Treehouse Guest TeacherYeah. Windows often needs to be restarted in order to find new executables and libraries that have been installed. I think they've fixed this in Windows 10.
Matthew Goodman
12,786 PointsAlso is there a way to find out within the cmd if it was added to the path
Kenneth Love
Treehouse Guest TeacherI don't know for certain, but the docs indicate that you should be able to run sqlite3.exe (maybe just sqlite3?). That should put you into a database shell.