If you want to get comfortable with SQLite, try some of the tutorials at: http://www.squidoo.com/sqlitehammer http://www.squidoo.com/sqlitetutorial http://www.squidoo.com/sqliteprogramming
There are also videos at http://www.youtube.com/user/Jaynonymous1 which you may find useful. Cheers, Jay On Jan 7, 6:50 pm, wormser17 <matt.lo...@gmail.com> wrote: > Hello. First, some quick context about my approach (I am not a > programmer): > > This is the directory where I installed Django: /Library/Python/2.6/ > site-packages/django > This is my project directory: /Users/mlooby/Sites/mysite > > Situation > 1) I created a SQLite3 database, named "project.db," by editing > settings.py with the following: > > DATABASE_ENGINE = 'django.db.backends.sqlite3' > DATABASE_NAME = '/Users/mlooby/Sites/mysite/project.db' > > 2) I created tables for the apps under INSTALLED_APPS by running: > > python manage.py syncdb > > 3) Next, I created my superuser account. > > 4) The tutorial then states the following: > > "If you're interested, run the command-line client for your database > and type \dt (PostgreSQL), SHOW TABLES; (MySQL), or .schema(SQLite) to > display the tables Django created." > > My Issue: I cannot get SQLite to display the tables that Django just > created after entering/running the following in a new Terminal shell: > > mlooby$ sqlite3 > SQLite version 3.6.12 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .schema > sqlite> .schema; > unknown command or invalid arguments: "schema;". Enter ".help" for > help > sqlite> .schema project.db > sqlite> .schema project > sqlite> .schema project; > sqlite> > > I've reviewedwww.sqlite.comand some related Google Groups, but my > searches were fruitless. Does anyone know why I can't get SQLite to > display the tables? > > Finally, please let me know if I've omitted any information that would > help identify the issue. > > Thank you.
-- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.