Firebird

Linux

Installation

Install Firebird using your preferred method. You will likely need the developer’s version of Firebird for it to be picked up by SOCI.

If you’re using a system’s package manager, your Firebird installation won’t be picked up by the SOCI package available on conda-forge, meaning that you will either have to install SOCI from source or download it from SOCI downloads page.

Make sure you’re installing SOCI after you have Firebird in your system.

You can still get xeus-sql from conda with:

conda install xeus-sql jupyterlab -c conda-forge

From source

To install SOCI from source use the following flags when building:

cmake -DCMAKE_INSTALL_PREFIX=$CONDA_PREFIX -G "Unix Makefiles" -DWITH_BOOST=OFF -DSOCI_CXX11=ON -DCMAKE_BUILD_TYPE=Release -DSOCI_LIBDIR=lib ..

make install

Just make sure to do that in the same environment as the rest of your installation.

Usage

Either way you decide to conduct your installation process you have to make sure that the directory where your database is is accessible by JupyterLab. To do that, you can add the user of the machine to the firebird group:

sudo chown firebird:firebird $DATABASE_NAME
sudo usermod -a -G firebird $USER_NAME

That’s all there’s to it. You can now run the example contained in examples/Firebird.ipynb.

More information about Firebird can be found in the SOCI documentation.