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

nmap - The Network Mapper

WARNING : It is ILLEGAL to scan hosts without permission.
Read more

Microsoft Windows Server 2012 R2 Standard Evaluation Product Key

Microsoft Windows Server 2012 R2 Standard Evaluation D2N9P-3P6X9-2R39C-7RTCD-MDVJX DBGBW-NPF86-BJVTX-K3WKJ-MTB6V
Read more

IBM Domino: Enable SMTPClientDebug, SMTPDebug

Add parameters to NOTES.ini SMTPClientDebug=1 SMTPDebug=2 Option 1: Add parameters via GUI IBM Domino: Enable SMTPDebug in NOTES.ini Option 2: Add parameters via command SET CONFIG "SMTPClientDebug=1" update Run command to update router configuration tell router update config IBM Domino: tell router update config to update configuration and reload routing table Send an email to @gmail.com to check result IBM Domino: Log file after enabling SMTPClientDebug parameter in NOTES.ini file
Read more