SQLite GUI; SQLite executing commands

I’ve found a nice GUI for SQLite. It’s from ‘tksqlite’ project located here. You can download a working version here.

From console (sqlite3.exe) you can do the following:

.read FILENAME – execute a file with sql commands;
.quit
.databases – list databases
.tables – list tables
.headers ON – display table headers while executing (SELECT * …)
.schema – display database schema

Remember to open sqlite3.exe with a database argument:

sqlite3.exe database.db