sqlite3 db

sqlite is a lightweight database, perfect for developing self-contained web applications. If you don’t have much data, and you don’t need to access your data outside of your application, sqlite is a great choice. This rules out the majority of use cases, but sqlite is also great for developing an application, as it is a file-based database. The host computer does not need to be configured because sqlite stores data the same way Linux does - as files.

Commands

Select all tables

.tables

List schema for TABLE

.schema TABLE

Quit sqlite interpreter

CTRL + D