SQLite - Small and Super Power
It is easy to use, portable and integrates directly with applications. It is a serverless self-contained database engine and is great for development and testing so if you want a ‘lite’ solution for applications and just want something small scale then it is great. If you need a powerful database that can cope with much higher loads then MySQL is much better suited to your needs.
The storage capacity is higher than 140TB, nothing bad for a DB-Engine that has less than 1MB.
For Windows chose: Precompiled Binaries for Windows
| sqlite-tools-win32-x86-3280000.zip (1.70 MiB) |
A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exe program, and the sqlite3_analyzer.exe program. (sha1: 4063fe326243ab775a86c104fa77ac178f03976b) |
Download: https://www.sqlite.org/download.html
For Windows installation you need to follow the steps:
1º - Extract the folder to c:\sqlite
2º - Add on Windows Path environment variables the new folder address: c:\sqlite
3º - Done
To create a new database and table, this is the way:
Using Windows comand line:
1º - Go to c:\sqlite (cd c:\sqlite)
2º - Create a new folder: md db
3º - Type: sqlite3 mydb.db
4º - type: .databases
On that stage the database will be created:
To create a new table follows ANSI 92:
5º - create table students(id INT primary key);
6º - To list the tables - type: .tables
7º - To show the schema - type: .schema
:
SQLite has a plug-in for MS SQL Manager Studio
SQLServerCompactSQLiteToolboxforSSMS
https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolboxforSSMS#overview
SQLite - Between the most popular DB-Engines
Also:
https://www.explore-group.com/us/blog/the-most-popular-databases-2019/bp46/