SQLite Basics

| 1 min read

Week Of: 2021-11-28


SQLite basics


go to: Precompiled Binaries for Windows in: https://www.sqlite.org/download.html
and download the file.

locate the sqlite3 file in your preffered directory.

Start using

there you should run the command:

sqlite3 kanban.db

where the kanban.db is the db binary file.

Basic Help


Export the next command to Excel file

.excel --bom

where the --bom is for the Hebrew characters (UTF-8)

Show your all tables


SQL Commands

select * from card;