SQLite3 is a build-in library for python3 to access the database. It's nos C/S mode database like MySql, it just like file in the local disk. Operations in the database just like operating the files.
There is a tool for you to manage your local database which called sqlitebroswer.
├── coffee-shop
│ ├── coffee_shop.db
│ ├── create-model.py
│ ├── demon
│ │ ├── movie.db
│ │ ├── movie_worksheet.pdf
│ │ └── select-like.py
│ ├── delete-data.py
│ ├── insert-data.py
│ ├── manage-menu.py
│ ├── select-data.py
│ └── update-data.py
├── LICENSE
└── README.md
you can run the program by:
Python3 manage-menu.py
You can just switch to the deamon dir and look at the PDF for details.
Just read the other python source files to know more details.
look at the online course here
the complete coffee shop sample in the ./coffee-shop-complete dir.