SQLite is a simple yet powerful embedded SQL database engine ... Type ".help" to see a list of the available SQLite commands. ... then type "exit" at the command line to close the terminal window.

For administration, SQLite offers an intuitive utility program conveniently named sqlite with which users of MySQL and PostgreSQL will feel perfectly at home. It has both shell and command-line modes.

List all SQLite databases. To prove the database is indeed created, you can look for the todo.db file in the current folder, or simply issue the following command:. sqlite>.databases main: ...