python - How to view database and schema of django sqlite3 db

Question

I am new to django framework.

I tried to create a simple blog by following djangogirls tutorials.

Here by default we get sqlite3 as default database Engine

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    }
}

I tried some ORM queries also, Even performed some row sql queries

At my django project I have this db.sqlite3 file

blog  db.sqlite3  env  manage.py  mysite

My Question: How to knew the schema that django created in this db.sqlite3(I knew mysql where I can see details about each database and tables,so here I just want to know more things in sqlite)

I have sqlite3 in my system and I tried .database command,but it just shows me

seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main 

question from:https://stackoverflow.com/questions/42227778/how-to-view-database-and-schema-of-django-sqlite3-db

Answer 1

Goto the folder where the database is and then

sqlite3  db.sqlite3

Then

.tables

or .schema

depending on what you want. Instead of invoking sqlite3 directly you could do

 python manage.py dbshell 

and then type the sqlite commands.

If you are working with a legacy database you can generate Django models for that using the

 python manage.py inspectdb

please see https://docs.djangoproject.com/en/3.0/ref/django-admin/#django-admin-inspectdb for additional info.

But please do yourself a favour and get a GUI database client. Life is much easier when you have one.