Skip to main content

SQLite Database: Notes

SQLite logo: https://upload.wikimedia.org/wikipedia/commons/thumb/3/38/SQLite370.svg/800px-SQLite370.svg.png

SQLite is free for everyone to use for any purpose.

SQLiteStudio is an open source SQLite database manager, released under GPLv3 license.

DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

sqlite3 --version : check version

.open path-to-db-file : open database file
.tables : list all tables in database
.schema table_name : describe table schema
.help : get help
.quit : quit sqlite
Labels:

Popular posts from this blog

Linux command: ssh-keygen - Generate SSH Keys

ssh-keygen — authentication key generation, management and conversion
Read more

Powershell: Install-WindowsFeature AD-Domain-Services

Install-WindowsFeature AD-Domain-Services Powershell: Install-WindowsFeature AD-Domain-Services Check if AD-Domain-Services is installed Powershell: Check if AD-Domain-Services is installed
Read more

Google Pixel Chromebook: Notes

The Chromebook Pixel is a laptop at the high end of Google's Chromebook family of machines, which all come preinstalled with Chrome OS operating system.
Read more