Writing and reading SQLite databases
SQLite is a lightweight database engine that is used in applications ranging from Android apps and Firefox to US Navy inventory systems. Because of the range of use, there are more applications running SQLite than any other database.
A SQLite database is a single file that is accessed by one or more database engines. The database engine is a C library that can be linked to an application; it is loaded as a library to a scripting language, such as TCL, Python, or Perl, or run as a standalone program.
The standalone application sqlite3 is the easiest to use within a shell script.
Getting ready
The sqlite3
executable may not be installed in your installation. If it is not, it can be installed by loading the sqlite3
package with your package manager.
For Debian and Ubuntu, use the following:
apt-get install sqlite3 libsqlite3-dev
For Red Hat, SuSE, Fedora, and Centos, use the following:
yum install sqlite sqlite-devel
How to do it...
The sqlite3
command is an interactive...