Thursday 30 April 2020

Install SQLite3 from Source on Linux

Install SQLite3 from Source

$ wget https://www.sqlite.org/src/tarball/sqlite.tar.gz

$ tar xzf sqlite.tar.gz     #  Unpack the source tree into "sqlite"
$ mkdir bld                   #  Build will occur in a sibling directory
$ cd bld                        #  Change to the build directory
$ ../sqlite/configure     #  Run the configure script
$ make                         #  Run the makefile.
$ make sqlite3.c           #  Build the "amalgamation" source file
$ make test                  #  Run some tests (requires Tcl)

$ whereis sqlite3
sqlite3: /usr/bin/sqlite3 /usr/include/sqlite3.h /usr/share/man/man1/sqlite3.1.gz

$ sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668

$ sqlite3
   SQLite version 3.7.17 2013-05-20 00:56:22
   Enter ".help" for instructions
   Enter SQL statements terminated with a ";"
   sqlite> .help
   [...]
   sqlite> .show
   [...]
   sqlite> .database
   [...] 
   sqlite> .table
   [...]
   sqlite> .quit

Ref :- sqlite.org sqlite.org/cli.html

No comments:

Post a Comment