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

Windows command: icacls

Icacls is a command-line utility that can be used to display or modify discretionary access control lists (DACLs) on specified files, and apply stored DACLs to files in specified directories.
Read more

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.
Read more

C++: Online IDE

Without C++ compiler installed, try these free online C++ IDE.
Read more