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: ...

SQLite is a simple yet powerful embedded SQL database engine. ... For example, to create a new table, type:CREATE TABLE myTable (id INTEGER, name VARCHAR(100)); ... Ruby and Python, ...