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

Databases

trouble setting up sqlite

C:\>cd sqlite
# here it looks like I'm in the sqlite folder
C:\sqlite>ls  
'ls' is not recognized as an internal or external command,
operable program or batch file.
# when I try to see a list of whats in there
C:\sqlite>ls 
'ls' is not recognized as an internal or external command,
operable program or batch file.  
# I get this error
#  what am I missing?
C:\sqlite>sqlite3 my.db
'sqlite3' is not recognized as an internal or external command,
operable program or batch file.

C:\sqlite>

1 Answer

Jennifer Nordell
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there! Essentially, you're missing the bash shell. The command ls is used on linux variants, but you're clearly working on a Windows machine. If you are working on Windows 10, the bash shell was included in an anniversary update, but it needs to be properly configured to use

Also, sqlite3 will need to be set up as an environment variable on your Windows system to be able to run it from any directory as such.

here is some information on how to set up bash on Windows 10

And here is some information on environment variables.

If you don't want to set up the bash shell you can use the command dir in the console to list the contents of the working directory. Hope this helps! :sparkles:

Thank you so much Jennifer. Dir did in fact show that sqlite was installed. I have been feeling pretty comfortable just working with the cmd. Is it a big advantage to use Bash? I just took a quick look at those links. Yes, I will take some time and go through those. Thanks again.

Jennifer Nordell
seal-mask
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

It really just depends on what you're most comfortable with. Windows has its own command line commands. Bash has its own. That being said, I would point out that most web servers are linux-based. Knowing your way around a linux system just by using commands is a big feather in your cap if you're looking for work in any development environment. Any familiarity with bash is only going to benefit you. More so (in my opinion) than working with the command line in Windows.

Thanks for your reply, I got everything working thanks to your help. So yes bash is a good thing to learn and I'll tackle that process :D