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

Synology: Commonly Used Commands

Commonly used commands via ssh with Synology NAS.

American Accent Training Resources

American Accent Training Book and CDs American Accent Training by Ann Cook Rebecca Linquist https://www.youtube.com/user/rebeccalinquist LISA’S YOUTUBE VIDEOS http://www.accurateenglish.com/lisas-youtube-videos/ Rachel's English Youtube Channel https://www.youtube.com/user/rachelsenglish Accent Ace https://www.youtube.com/user/AccentAceConfidence Practice American English sounds with free video lessons by Cheryl A. Posey http://www.speakingyourbest.com/freevideolessons.html Shaw English Online https://www.youtube.com/user/ShawEducation Pronunciation Pro https://www.youtube.com/user/pronunciationpro Heather Hansen https://www.youtube.com/user/heatherhansen

Microsoft Windows: Commonly Used Shortcuts

Windows shortcuts Shortcuts Description Windows + Up Arrow Maximize active window Windows + Down Arrow Restore active window Windows + Left Arrow Move active window to half left of screen Windows + Right Arrow Move active window to half right of screen Windows + A Open Notifications window Windows + C Open C ortana Windows + E Open Windows E xplorer Windows + F Open Windows' F eedback Hub Windows + I Open Windows Settings Windows + L L ock screenr Windows + M M inimize all active windows Windows + P Send screen to P rojector Windows + R Open R UN dialog Windows + Pause Open System Properties window Windows + SHIFT + S Open S creenClipping tool CTRL + SHIFT + ESC Open Task Manager