Installing sqlite3 --SQLite Utility

Let's install "sqlite3" which is a SQLite client. Use the apt command.

sudo apt install -y sqlite3

Make sure you have the sqlite3 command available.


SQLite features

SQLite is not a client / server type database, but a library for processing rows such as database file creation / table creation, select, insert, update, delete.

Perl's DBD::SQLite contains libraries that operate SQLite, and packages for installing header files and shared libraries like "* -dev" like DBD::MySQL and DBD::Pg. I don't need it.

This is a necessary step to enable the command line utility called sqlite3.

Associated Information