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![](https://ecs-static.teamtreehouse.com/assets/views/marketing/shared/community-banner-white-47072046c51352fe6a69f5e691ff5700b28bb11d45197d7bdf066d9ea3f72d0c.webp)
![Jonathan Grieve](https://uploads.teamtreehouse.com/production/profile-photos/601842/micro_twitterCover.png)
Jonathan Grieve
Treehouse Moderator 91,253 PointsConsole doesn't work with sqLite3
Console does't work
My version of the console as of now is
treehouse:~/workspace$ sqlite3
SQLite version 3.7.17 2013-05-20 00:56:22
But the video's version is
```treehouse:~/workspace$ sqlite3 SQLite version 3.8.2 2013-12-04 14:53:30
Which seems to me to suggest that workspaces has reverted back to an earlier version which is not compatable with the suggested commands.
I can get into ```sqlite3``` by typing the command
But as soon as I try to open a database ```sqlite3 database.db``` I get locked in and no other commands will work.
```sqlite> sqlite3 database.db
...>
Help! :-)
3 Answers
![shadrackndacayisenga](https://secure.gravatar.com/avatar/14618a2788f777e325fc2b50e4b67f86?s=96&d=https%3A%2F%2Fecs-static.teamtreehouse.com%2Fassets%2Fcontent%2Fdefault_avatar-445fbbabfc8dc9188fb5967fe43322ee0c3e0dd1e10f378bf8343784af5a13eb.webp&r=pg)
shadrackndacayisenga
Python Web Development Techdegree Student 14,189 PointsI see , normally after using the sqlite3 command in the console
sqlite3
After the sqlite3 console prompt shows up
sqlite >
you can not us sqlite3 database command . Since there is no comand name sqlite3 in the sqlite3 commands.
Instead from the from the workspaces console prompt type in sqlite3 followed by the database name you want to target.
If its not already there, it will be created.
I would also delete all databases in the workspaces and make a new fresh copy/import of the database.
![Jonathan Grieve](https://uploads.teamtreehouse.com/production/profile-photos/601842/micro_twitterCover.png)
Jonathan Grieve
Treehouse Moderator 91,253 PointsThank you Shadrack. It seems to be working now.
I'm sure in Hampton;s version he was able to link the databases from inside of sqlite so i was following that setup rigidly. But I was able to get around by following your advice, so thanks for that :)
![shadrackndacayisenga](https://secure.gravatar.com/avatar/14618a2788f777e325fc2b50e4b67f86?s=60&d=https%3A%2F%2Fecs-static.teamtreehouse.com%2Fassets%2Fcontent%2Fdefault_avatar-445fbbabfc8dc9188fb5967fe43322ee0c3e0dd1e10f378bf8343784af5a13eb.webp&r=pg)
shadrackndacayisenga
Python Web Development Techdegree Student 14,189 PointsGlad to help, Happy coding.
![shadrackndacayisenga](https://secure.gravatar.com/avatar/14618a2788f777e325fc2b50e4b67f86?s=96&d=https%3A%2F%2Fecs-static.teamtreehouse.com%2Fassets%2Fcontent%2Fdefault_avatar-445fbbabfc8dc9188fb5967fe43322ee0c3e0dd1e10f378bf8343784af5a13eb.webp&r=pg)
shadrackndacayisenga
Python Web Development Techdegree Student 14,189 PointsTo start using sqlite3 make sure you type sqlite3 database.db in a blank workspace like:
treehouse:~/workspace$ sqlite3 database.db
That is; if you are already using in sqlit3 , to open database.db use .open command
treehouse:~/workspace$ sqlite3
. . .
sqlite> .open database.db
You can also just exit using .exit command to exit and open the database afresh.
.exit
Then go ahead and open the database
sqlite3 database.db
You can now use "SQL" commands to create tables, manipulate data, and so on.
You can also use sqlite3 dot commands commands like:
.databases
will list all databases
.tables
will show all tables in the database
.help
to see more other sqlite3 commands.
NOTE: not all dot commands are available in the open database, since each command may have a particular context in which to function.
![Jonathan Grieve](https://uploads.teamtreehouse.com/production/profile-photos/601842/micro_twitterCover.png)
Jonathan Grieve
Treehouse Moderator 91,253 PointsThanks Shadrock, but it doesn't work.
The .open command is deprecated on my console and it locks out as soon as I try
sqlite3 database.db
![Pierre Szuwarski](https://uploads.teamtreehouse.com/production/profile-photos/5832162/micro_10923252_10205003305175467_5291252648729344402_n.jpg)
Pierre Szuwarski
Courses Plus Student 1,585 PointsThanks !!
![shadrackndacayisenga](https://secure.gravatar.com/avatar/14618a2788f777e325fc2b50e4b67f86?s=96&d=https%3A%2F%2Fecs-static.teamtreehouse.com%2Fassets%2Fcontent%2Fdefault_avatar-445fbbabfc8dc9188fb5967fe43322ee0c3e0dd1e10f378bf8343784af5a13eb.webp&r=pg)
shadrackndacayisenga
Python Web Development Techdegree Student 14,189 PointsI see, I cant use the .open command either . In stead I used sqlite3 database.db, if you are using the same version then you will be ok. Here is what workspaces output tooks like.
sqlite3 database.db then .databases command
treehouse:~/workspace$ sqlite3 database.db
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
resulting output , shows the database :
seq name file
--- --------------- ----------------------------------------------------------
0 main /home/treehouse/workspace/database.db
.table command
sqlite> .tables
Outputs all the tables in the database.
address film_actor rental
category film_category sales_by_film_category
city film_list sales_by_store
country film_text staff
customer inventory staff_list
customer_list language store
film payment
SQL command, terminated by semicolon ";"
sqlite> SELECT * FROM city;
Output All elements in city table
1|A Corua (La Corua)|87|2015-01-08 14:08:08
2|Abha|82|2015-01-08 14:08:08
3|Abu Dhabi|101|2015-01-08 14:08:08
4|Acua|60|2015-01-08 14:08:08
5|Adana|97|2015-01-08 14:08:08
6|Addis Abeba|31|2015-01-08 14:08:08
7|Aden|107|2015-01-08 14:08:08
8|Adoni|44|2015-01-08 14:08:08
9|Ahmadnagar|44|2015-01-08 14:08:08
10|Akishima|50|2015-01-08 14:08:08
11|Akron|103|2015-01-08 14:08:08
. . . all element in city table ...
It works perfectly.
![Jonathan Grieve](https://uploads.teamtreehouse.com/production/profile-photos/601842/micro_twitterCover.png)
Jonathan Grieve
Treehouse Moderator 91,253 PointsThat's part of the problem. We're using different versions of Workspaces to the video. Does anyone know of a way to use a different Workspaces version? :-)
![Jonathan Grieve](https://uploads.teamtreehouse.com/production/profile-photos/601842/micro_twitterCover.png)
Jonathan Grieve
Treehouse Moderator 91,253 PointsThis is how my console looks. As you can see it also gives the Workspaces version and the commands I've tried to use.
frank martinez
8,858 Pointsfrank martinez
8,858 Pointsvery frustrating . .