jupyter-xeus / Xeus Sql
Projects that are alternatives of or similar to Xeus Sql
xeus-sql
xeus-sql is a Jupyter kernel for general SQL implementations based on the native implementation of the Jupyter protocol xeus and SOCI, a database access library for C++.
Usage
Launch the Jupyter notebook with jupyter notebook or Jupyter lab with jupyter lab and launch a new SQL notebook by selecting the xsql kernel.
Note that xeus-sql support the following SQL implementations:
- DB2
- Firebird
- MySQL
- ODBC (generic backend)
- Oracle
- PostgreSQL
- SQLite3
Installation
xeus-sql has been packaged for the conda package manager.
To ensure that the installation works, it is preferable to install xeus-sql in a fresh conda environment.
To ensure that the installation works, it is preferable to install xeus in a fresh conda environment. It is also needed to use
a miniconda installation because with the full anaconda
you may have a conflict.
The safest usage is to create an environment named xeus-sql with your miniconda installation
conda create -n xeus-sql
conda activate xeus-sql
Installing from conda
To install xeus-sql with the conda package manager:
conda install xeus-sql jupyterlab -c conda-forge
With mamba:
mamba install xeus-sql jupyterlab -c conda-forge
Conda forge offers packaged versions for MySQL, PostgreSQL and SQLite and you can download them with: soci-mysql, soci-postgresql or soci-sqlite.
xeus-sql includes soci-core only. Which consists on the SOCI package with no DB extension attached.
Documentation
https://xeus-sql.readthedocs.io/en/latest/
Dependencies
xeus-sql depends on
xeus-sql |
xeus |
PostgreSQL* |
SQLite* |
MySQL* |
Tabulate |
nlohmann_json |
xvega |
soci-core |
xproperty |
xvega-bindings |
|---|---|---|---|---|---|---|---|---|---|---|
| master | >=1.0.0, <2.0 | >=3.30.1, <4 | >=3.0.0, <4 | >=1.3.0,<2.0 | >=1.4 | >=3.0.0 | >= 0.0.10 | 4.0.1 | >=0.11.0 | >=0.0.3 |
| <=0.0.8 | >=1.0.0, <2.0.0 | >=3.30.1, <4 | >=3.0.0, <4 | >=1.3.0,<2.0 | >=1.4 | >=3.0.0 | >= 0.0.10 | 4.0.1 | 0.10.4 | >=0.0.3 |
| <=0.0.6 | >=0.24.0, <0.25 | >=3.30.1, <4 | >=3.0.0, <4 | >=1.3.0,<2.0 | >=1.4 | >=3.0.0 | >= 0.0.5 | 4.0.1 | 0.10.4 | >=0.0.3 |
* These are optional dependencies that come by default with xeus-sql but may or may not be added to your project in case you're building manually. For more information check the CONTRIBUTING file.
Contributing
See CONTRIBUTING.md to know how to contribute and set up a development environment.
License
We use a shared copyright model that enables all contributors to maintain the copyright on their contributions.
This software is licensed under the BSD-3-Clause license. See the LICENSE file for details.