Building SQLite

These are instructions are for building "SQLite":http://www.sqlite.org/ from source. SQLite is a fantastic little database, and favorite of mine when building Rails apps that center around things like content management and blogging. I'll do a longer post in the future on why and when to choose SQLite over bigger more traditional databases like MySQL, Postgres, SQL Server, and Oracle. Sorry Windows users, these instructions are for OS X and Linux/Unix people, but fear not, the SQLite homepage has "prebuilt binaries":http://www.sqlite.org/download.html for you. A quick note: These instructions are in the same vein as Dan Benjamin's "how to build from source" instructions on "Hivelogic":http://www.hivelogic.com/ and he has plenty written on why to use "/usr/local":http://hivelogic.com/articles/2005/11/29/using_usr_local and how to get the "prerequisites":http://hivelogic.com/articles/2005/12/01/ruby_rails_lighttpd_mysql_tiger set up on your machine. If you don't have /usr/local in your path, and don't have the build tools set up yet, go take a look at those two articles and come back when you're done. It's not scary, I promise. Back? Great, continuing... h2. Getting the SQLite Source First you need to get the source for SQLite. Make sure you're in your temp directory first for downloading the source code. <pre> curl -O http://www.sqlite.org/sqlite-3.3.5.tar.gz tar xvzf sqlite-3.3.5.tar.gz cd sqlite-3.3.5 </pre> h2. Building SQLite Next is the build process, which is just as easy. <pre> ./configure --prefix=/usr/local make sudo make install cd .. </pre> h2. Final Steps Well, really, there aren't any final steps, you should have a functional install of SQLite working now, but to test it type: <pre> sqlite3 -version </pre> ...and you should see the output: <pre> 3.3.5 </pre> You also might want to clean up your temp build directory by running: <pre> rm -rvf sqlite-3.3.5 rm -f sqlite-3.3.5.tar.gz </pre> If all has gone according to plan you now have a working install of SQLite, and are free to enjoy the pleasures of a small, fast, file based, zero config database.

2006-05-02T15:09:17+00:00

0 <p>These are instructions are for building <a href="http://www.sqlite.org/">SQLite</a> from source. SQLite is a fantastic little database, and favorite of mine when building Rails apps that center around things like content management and blogging. I’ll do a longer post in the future on why and when to choose SQLite over bigger more traditional databases like MySQL, Postgres, <span class="caps">SQL </span>Server, and Oracle.</p> <p>Sorry Windows users, these instructions are for <span class="caps">OS X</span> and Linux/Unix people, but fear not, the SQLite homepage has <a href="http://www.sqlite.org/download.html">prebuilt binaries</a> for you.</p> <p>A quick note: These instructions are in the same vein as Dan Benjamin’s “how to build from source” instructions on <a href="http://www.hivelogic.com/">Hivelogic</a> and he has plenty written on why to use <a href="http://hivelogic.com/articles/2005/11/29/using_usr_local">/usr/local</a> and how to get the <a href="http://hivelogic.com/articles/2005/12/01/ruby_rails_lighttpd_mysql_tiger">prerequisites</a> set up on your machine. If you don’t have /usr/local in your path, and don’t have the build tools set up yet, go take a look at those two articles and come back when you’re done. It’s not scary, I promise.</p> <p>Back? Great, continuing…</p> <h2>Getting the SQLite Source</h2> <p>First you need to get the source for SQLite. Make sure you’re in your temp directory first for downloading the source code.</p> <pre> curl -O http://www.sqlite.org/sqlite-3.3.5.tar.gz tar xvzf sqlite-3.3.5.tar.gz cd sqlite-3.3.5 </pre> <h2>Building SQLite</h2> <p>Next is the build process, which is just as easy.</p> <pre> ./configure --prefix=/usr/local make sudo make install cd .. </pre> <h2>Final Steps</h2> <p>Well, really, there aren’t any final steps, you should have a functional install of SQLite working now, but to test it type:</p> <pre> sqlite3 -version </pre> <p>...and you should see the output:</p> <pre> 3.3.5 </pre> <p>You also might want to clean up your temp build directory by running:</p> <pre> rm -rvf sqlite-3.3.5 rm -f sqlite-3.3.5.tar.gz </pre> <p>If all has gone according to plan you now have a working install of SQLite, and are free to enjoy the pleasures of a small, fast, file based, zero config database.</p> 12

Building SQLite notebook/2006/05/02/building_sqlite