How to install sqlite on Debian

Question

I need to install SQLite on my Debian VPS server. Can someone help me out? Kindly give me steps because I'm a newbie here and have no idea.

Thank you

Answer 1

$ sudo apt-get install sqlite3

Answer 2

I understand from your comments above that you wish to use sqlite with PHP. Although, this is an old question, here is how to do it for future reference.

PHP can communicate with SQLite databases with the help of the pdo-sqlite extension. On the current Debian, you need to install the package php5-sqlite. This will install and activate the module in your php.ini:

sudo aptitude install php5-sqlite

You can communicate with SQLite databases from the command line with the tools provided in the package sqlite or sqlite3. You can install these similarly. Note that these tools do not provide any PHP extensions.