SQLite Install Cookbook

Maintainer: OIT Systems Engineering (ua-oit-se@alaska.edu)

Purpose

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

Requirements

Chef

This cookbook requires Chef 14+

Platforms

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

Notes:

• This cookbook should support any recent Linux variant.

Dependencies

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

Resources

This cookbook provides one resource for creating an SQLite installation.

sqlite_installation

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

Actions

One action is provided.

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

Attributes

• 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. '3290000'. 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/libsqlite3.so'.
The lib path must be added to linker and runtime configurations (typically use -L and rpath, respectively) for dependents to load the custom libraries.

Recipes

This cookbook provides no recipes.

Examples

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'
end

Development

See CONTRIBUTING.md and TESTING.md.