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

Entity Framework Core: Notes

Entity Framework is [WHAT] an object-relational mapper [WHY] enabling .NET developer to work with relational data using domain-specific object.
Read more

nginx on RHEL

Install nginx $ sudo yum install nginx Enable nginx service on boot $ sudo systemctl enable nginx Start nginx service $ sudo systemctl start nginx Check nginx service status $ sudo systemctl status nginx Check nginx version $ nginx -V Check configuration files $ sudo nginx -t Reload nginx service $ sudo nginx -s reload nginx Cheat Sheet sudo nginx -s reload sudo nginx -t sudo systemctl enable nginx : Enable nginx on start up sudo systemctl start nginx : Start nginx sudo systemctl reload nginx : Reload nginx systemctl status nginx : Check nginx status nginx in the news
Read more