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

Popular posts from this blog

Free online resources to practice

Photo Credit:  johnhain  - pixabay.com There are many free online resources for us to practice almost any or specific skills as long as we have an Internet connection.

Check free space with disk free and disk usage

df -h -h: display result in KB, MB, GB Check free disk with disk free (df)

Coursera: Notes

Learn Without Limits - Build skills with courses, certificates, and degrees online from world-class universities and companies.