Install SQLite, installsqlite

Source: Internet
Author: User
Tags sqlite download

Install SQLite, installsqlite

Http://www.tutorialspoint.com/sqlite/sqlite_installation.htm

The SQLite is famous for its great feature zero-configuration, which means no complex setup or administration is needed. this chapter will take you through the process of setting up SQLite on Windows, Linux and Mac OS X.

Install SQLite On Windows
  • Go to SQLite download page, and download precompiled binaries from Windows section.

  • You will need to downloadSqlite-shell-win32-*. zipAndSqlite-dll-win32-*. zipZipped files.

  • Create a folder C: \> sqlite and unzip abve two zipped files in this folder which will give you sqlite3.def, sqlite3.dll and sqlite3.exe files.

  • Add C: \> sqlite in your PATH environment variable and finally go to the command prompt and issueSqlite3Command, which shoshould display a result something as below.

C:\>sqlite3SQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite>
Install SQLite On Linux

Today, almost all the flavors of Linux OS are being shipped with SQLite. So you just issue the following command to check if you already have SQLite installed on your machine or not.

$sqlite3SQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite>

If you do not see above result, then it means you do not have SQLite installed on your Linux machine. So let's follow the following steps to install SQLite:

  • Go to SQLite download page and downloadSqlite-autoconf-* .tar.gzFrom source code section.

  • Follow the following steps:

 

$tar xvfz sqlite-autoconf-3071502.tar.gz$cd sqlite-autoconf-3071502$./configure --prefix=/usr/local$make$make install

Above procedure will end with SQLite installation on your Linux machine which you can verify as explained abve.

Install SQLite On Mac OS X

Though latest version of Mac OS X comes pre-installed with SQLite but if you do not have installation available then just follow the following steps:

  • Go to SQLite download page, and downloadSqlite-autoconf-* .tar.gzFrom source code section.

  • Follow the following steps:

$tar xvfz sqlite-autoconf-3071502.tar.gz$cd sqlite-autoconf-3071502$./configure --prefix=/usr/local$make$make install

Above procedure will end with SQLite installation on your Mac OS X machine which you can verify by issuing following command:

$sqlite3SQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite>

Finally, you have SQLite command prompt where you can issue SQLite commands to do your excercises.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.