How to install SQLite on Ubuntu 17.04
{{postValue.id}}
To install SQLite on Ubuntu 17.04
SQLite is a relational database management system available on a C programming library. In contrast to many other database management systems, SQLite is not a client&ndash server database engine. Rather, it is embedded into the end program. In this tutorial, you will be guided through the installation of SQLite on Ubuntu 17.04.
Installing SQLite
Adding the required repository is the most import step to do before you begin with the installation of SQLite on your Ubuntu machine.
root@linuxhelp:~# add-apt-repository ppa:jonathonf/backports Backports of various (low impact) packages to Trusty and Xenial More info: https://launchpad.net/~jonathonf/+archive/ubuntu/backports Press [ENTER] to continue or ctrl-c to cancel adding it gpg: keybox ' /tmp/tmpl79oftld/pubring.gpg' created gpg: /tmp/tmpl79oftld/trustdb.gpg: trustdb created gpg: key 8CF63AD3F06FC659: public key " Launchpad PPA for J Fernyhough" imported gpg: Total number processed: 1 gpg: imported: 1 OK
Once it is done, update your repository as follows.
root@linuxhelp:~# apt-get update
Ign:1 http://ppa.launchpad.net/jonathonf/backports/ubuntu zesty InRelease
Ign:2 http://ppa.launchpad.net/jonathonf/backports/ubuntu zesty Release
Hit:3 http://in.archive.ubuntu.com/ubuntu zesty InRelease
Ign:4 http://ppa.launchpad.net/jonathonf/backports/ubuntu zesty/main i386 Packages
Get:5 http://in.archive.ubuntu.com/ubuntu zesty-updates InRelease [89.2 kB]
Get:6 http://security.ubuntu.com/ubuntu zesty-security InRelease [89.2 kB]
.
.
.
Get:35 http://security.ubuntu.com/ubuntu zesty-security/universe Translation-en [25.0 kB]
Get:36 http://security.ubuntu.com/ubuntu zesty-security/multiverse i386 Packages [1,980 B]
Get:37 http://security.ubuntu.com/ubuntu zesty-security/multiverse amd64 Packages [1,824 B]
Fetched 869 kB in 12s (67.7 kB/s)
Reading package lists... Done
Now is the time to install SQLite database. Run the following command for the same purpose.
root@linuxhelp:~# apt-get install sqlite3 -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
Suggested packages:
sqlite3-doc
The following NEW packages will be installed:
sqlite3
0 upgraded, 1 newly installed, 0 to remove and 102 not upgraded.
Need to get 697 kB of archives.
After this operation, 2,355 kB of additional disk space will be used.
Get:1 http://in.archive.ubuntu.com/ubuntu zesty/main amd64 sqlite3 amd64 3.16.2-3 [697 kB]
.
.
.
Preparing to unpack .../sqlite3_3.16.2-3_amd64.deb ...
Unpacking sqlite3 (3.16.2-3) ...
Setting up sqlite3 (3.16.2-3) ...
Processing triggers for man-db (2.7.6.1-2) ...
SQLite has been installed, invoke the following command to enter into SQLite terminal.
root@linuxhelp:~# sqlite3
SQLite version 3.16.2 2017-01-06 16:32:41
Enter " .help" for usage hints.
Connected to a transient in-memory database.
Use " .open FILENAME" to reopen on a persistent database.
Comments ( 0 )
No comments available