Skip to content
Creates an SQLite installation from source
Ruby Shell
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.

SQLite Install Cookbook

License GitHub Tag Build status

Maintainer: OIT Systems Engineering (


This cookbook provides a single resource that downloads, configures, compiles, and installs SQLite.



This cookbook requires Chef 14+


Supported Platform Families:

  • Debian
    • Ubuntu, Mint
  • Red Hat Enterprise Linux
    • Amazon, CentOS, Oracle
  • Suse

Platforms validated via Test Kitchen:

  • Ubuntu
  • Debian
  • CentOS
  • Oracle
  • Fedora
  • Amazon
  • Suse


  • This cookbook should support any recent Linux variant.


This cookbook does not constrain its dependencies because it is intended as a utility library. It should ultimately be used within a wrapper cookbook.


This cookbook provides one resource for creating an SQLite installation.


This resource provides a single action to create an SQLite installation.


One action is provided.

  • :create - Post condition is that source and binary artifacts exist in specified directories.


  • year - Defaults to '2019'. The release year of SQLite to install. Needed to build the download URL.
  • version - Defaults to nil. The version of SQLite to install. Note that SQLite uses a 'dotless' format, e.g. '3300000'. If nil, will default to the latest version when this cookbook was updated. The helper default_sqlite_version is provided for fetching this value.
  • download_directory - Defaults to nil. The local path to the directory into which to download the source archive. See note below about paths.
  • build_directory - Defaults to nil. The local path to the directory into which to decompress and build the source code. See note below about paths.
  • install_directory - Defaults to nil. The local path to the directory into which to install the binary artifacts. See note below about paths.
  • owner - Defaults to root. The owner of all artifacts.
  • group - Defaults to root. The group of all artifacts.

Note on paths

If a path is set for download, build or install, then the client must assure the directory exists before the resource runs. The resource runs as root and sets permissions on any created files, so is capable of placing a user-owned directory in a root-owned directory.

Fairly standard defaults are used for paths. If download_directory or build_directory is nil (default), '/var/chef/cache' will be used. If install directory is nil (default), "/opt/sqlite/#{version}" will be created and used.

For build_directory, the path given is the parent of the source root that is created when the archive is extracted. For example, if build_directory is set to '/usr/local/sqlite-src', then the source root will be "/usr/local/sqlite-src/sqlite-src-#{version}".

For install_directory, the path given is the root of the install. For example, if install_directory is set to '/usr/local/sqlite', then the path to the SQLite shared library will be '/usr/local/sqlite/lib/'. The lib path must be added to linker and runtime configurations (typically use -L and rpath, respectively) for dependents to load the custom libraries.


This cookbook provides no recipes.


Custom resources can be used as below.

sqlite_installation 'No Defaults' do
  year '2018'
  version '3260000'
  download_directory '/usr/local/sqlite-dl'
  build_directory '/usr/local/sqlite-bld'
  install_directory '/usr/local/sqlite'
  owner 'some-dude'
  group 'some-dudes'


See and

You can’t perform that action at this time.