SQLite
======

.. toctree::
   :maxdepth: 1
   :caption: Contents:

About
-----

`SQLite`_ is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.

Supported versions
------------------

To check which SQLite versions and build types are currently supported on Discoverer, execute on the login node:

.. code-block:: bash

 module avail sqlite

.. note:: The builds available in the public software repository are linked against the latest optimized version of :doc:`zlib`.

The compilation process adopted is based on the following published recipes:

https://gitlab.discoverer.bg/vkolev/recipes/-/tree/main/sqlite

Compiler affinity
-----------------

Each version of SQLite installed in the public software repository is built against four compiler collections: (i) :doc:`llvm`, (ii) :doc:`oneapi`, (iii) :doc:`nvidia_hpc_sdk`, (iv) :doc:`aocc`, (v) :doc:`gcc`. The name of the environmental module contains the name of the compiler set employed for compiling the SQLite source code.

LLVM build (preferred)
......................

.. code:: bash

 module avail sqlite/*/*llvm

Intel oneAPI build (optional)
.............................

.. warning:: Will be retired soon.

.. code:: bash

 module avail sqlite/*/*intel

NVIDIA HPC SDK build (optional)
...............................

.. warning:: Will be retired soon.

.. code:: bash

 module avail sqlite/*/*nvidia

AMD AOCC build (optional)
.........................

.. warning:: Will be retired soon.

.. code:: bash

 module avail sqlite/*/*aocc

GNU GCC build (optional)
........................

.. code:: bash

 module avail sqlite/*/*gcc

Getting help
------------

See :doc:`help`

.. _`SQLite`: https://sqlite.org