Sqlite3

sudo apt install sqlite3

sudo sqlite3 #without sudo file can not be created

create table dbname(textname text, intname int);

.tables

.databases

.exit

sudo sqlite3 

.open test.db

INTEGER

INT

INTEGER

TINYINT

SMALLINT

MEDIUMINT

BIGINT

UNSIGNED BIG INT

INT2

INT8

TEXT

CHARACTER(20)

VARCHAR(255)

VARYING CHARACTER(255)

NCHAR(55)

NATIVE CHARACTER(70)

NVARCHAR(100)

TEXT

CLOB

BLOB

BLOB

REAL

REAL

DOUBLE

DOUBLE PRECISION

FLOAT

NUMERIC

NUMERIC

DECIMAL(10,5)

BOOLEAN

DATE

DATETIME