Repository files navigation

This is a fork ofmysqlclient-python.

This project is designed to be used with TileDB-SQL which is a reduced build of MariaDB with support for usingtheMyTile storage engine for accessing TileDB Arrays.

This is not meant to be used a general purpose MariaDB Client, it is only meant to be used with linking againstthe embedded version of MariaDB. This has been tested only with MariaDB 10.4 and the MyTile storage engine.

A docker image is available on dockerhub undertiledb/tiledb-sql-py.This docker image will drop you into a python shell and has tiledb, tiledb-sql-py, pandas and numpy preinstalled.

docker run -it --rm tiledb/tiledb-sql-py

Conda packages will be available on conda forge soon.

conda install -c conda-forge tiledb-sql

A pypi package will be build from conda using conda-press

pip install tiledb-sql

You may need to install the Python development headers and compile MariaDB from source

• sudo apt-get install python-dev default-libmysqlclient-dev # Debian / Ubuntu
• sudo yum install python-devel mysql-devel # Red Hat / CentOS
• brew install mysql-connector-c # macOS (Homebrew) (Currently, it has bug. See below)

On Windows, there are binary wheels you can install without MySQLConnector/C or MSVC.

Please follow theMyTile compilation instructions

If you've installed mytile into$HOME/mytile_server simply build the python package with:

PATH="$HOME/mytile_server/bin:${PATH}" python setup.py build_ext --inplace

Now you can use it with

import tiledb.sqlimport pandasdb = tiledb.sql.connect(db="test")pd.read_sql(sql="select * from `s3://my_bucket/my_array`, con=db)

Documentation is hosted onTileDB Developer Docs