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

Online Learning: Free to Learn, Learn to Free

Photo Credit:  Gerd Altmann - pixabay.com Just make time to keep learning, practicing, and sharing.

Install the .NET Core Windows Server Hosting bundle

Remember to schedule in advance, since IIS must be reset after installing .NET Core Windows Server Hosting bundle.

VMware Workstation: vmrun.exe

Using vmrun.exe to manage VMs on VMware Workstation