SQLite Database: Notes

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

Linux command: lsusb

lsusb - list USB devices NAME lsusb - list USB devices SYNOPSIS lsusb [ options ] DESCRIPTION lsusb is a utility for displaying information about USB buses in the system and the devices connected to them. OPTIONS -v, --verbose Tells lsusb to be verbose and display detailed information about the devices shown. This includes configuration descriptors for the device's cur‐ rent speed. Class descriptors will be shown, when available, for USB device classes including hub, audio, HID, communications, and chipcard. -s [[bus]:][devnum] Show only devices in specified bus and/or devnum. Both ID's are given in decimal and may be omitted. -d [vend...

Powershell: Get-Uptime

Start with Powershell 6, there is Get-Uptime cmdlet to tell how long the system running.

Coursera: Notes

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

luyện

Search This Blog