Django schema with sqlite

Question

I am new to Django, I went through this Django site to create a basic application. They explained the procedure for using SQLITE3, MYSQL, postgresql ... I used SQLITE3 because they say that it is one large file that makes it easy to use at first.

The problem I am facing is using .schema to validate the created database. I checked some sites that talk about using this. But I'm stuck, and I'm embarrassed to use it.

What I did was

$sqlite3 sqlite>.schema sqlite> 

This code above did not work, then I stumbled upon a forum where they said install add_on for Fox Fox, which did not work for me, as a compatibility issue. I even indicated the name of the path where this database file is located.

 $sqlite3 sqlite> /home/ntan3/Django-1.2.3/mysite/eg_sqlite.db 

which gave an error with the wrong syntax next to '/'.

The thing can be successfully executed is a sample application explained by the Django site.

but I wanted to see the created database. Please help. Can someone guide me properly? even a specific link is also useful. Thanks.

Answer 1

This is basic command line stuff. You need to pass the path to the db file when entering sqlite3:

 $ sqlite3 /home/ntan3/Django-1.2.3/mysite/eg_sqlite.db