Skip to main content

MonetDBe - the Python embedded MonetDB

Project description

MonetDB/e-Python

MonetDB/e-Python - the serverless Python embedded MonetDB

alt text

Want to store and search a massive amount of numbers? You don't want to run a database service? Is SQLite too slow for what you want to do? Search no further! MonetDBe-Python is here. Just pip install the binary wheel on your Windows, Linux or OS X system and you are ready to go, no compilation needed.

MonetDBe-Python internally relies on a serverless and trimmed-down version of the blazingly fast MonetDB, the open-source column-store database.

The documentation can be found at: https://monetdbe.readthedocs.io/

The source code can be found at: https://github.com/monetdBSolutions/MonetDBe-Python/

install

you need:

  • An up-to-date Linux, OSX or Windows
  • pip >= 19.3
  • Python >= 3.7

to make sure you have a recent pip first upgrade pip:

$ pip install --upgrade pip

now you can install MonetDBe-Python with:

$ pip install monetdbe

usage

Just import and get started, no running a server required. Connecting without an argument starts an in-memory storage instance:

>>> from monetdbe import connect
>>> con = connect()
>>> con.execute('select * from tables').fetchdf()
      id               name  schema_id                                              query  type  system  commit_action  access  temporary
0   2001            schemas       2000                                               None    10    True              0       0          0
1   2007              types       2000                                               None    10    True              0       0          0
2   2016          functions       2000                                               None    10    True              0       0          0
3   2029               args       2000                                               None    10    True              0       0          0
4   2038          sequences       2000                                               None    10    True              0       0          0
..   ...                ...        ...                                                ...   ...     ...            ...     ...        ...
81  6650       storagemodel       2000  create view sys.storagemodel as\nselect "schem...    11    True              0       0          0
82  6661  tablestoragemodel       2000  create view sys.tablestoragemodel as\nselect "...    11    True              0       0          0
83  6675         statistics       2000                                               None    10    True              0       0          0
84  6734           compinfo       6698  create view logging.compinfo as select * from ...    11    True              0       0          0
85  6739    systemfunctions       2000  create view sys.systemfunctions as select id a...    11    True              0       0          0

See a another simple example illustrating the Pandas support in this notebook:

https://github.com/MonetDBSolutions/MonetDBe-Python/blob/master/notebooks/basic_example.ipynb

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

monetdbe-0.11.tar.gz (68.2 kB view hashes)

Uploaded Source

Built Distributions

monetdbe-0.11-cp310-cp310-win_amd64.whl (6.8 MB view hashes)

Uploaded CPython 3.10 Windows x86-64

monetdbe-0.11-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.1 MB view hashes)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

monetdbe-0.11-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (4.6 MB view hashes)

Uploaded CPython 3.10 manylinux: glibc 2.17+ ARM64

monetdbe-0.11-cp310-cp310-macosx_12_0_arm64.whl (92.7 kB view hashes)

Uploaded CPython 3.10 macOS 12.0+ ARM64

monetdbe-0.11-cp310-cp310-macosx_10_15_x86_64.whl (4.7 MB view hashes)

Uploaded CPython 3.10 macOS 10.15+ x86-64

monetdbe-0.11-cp39-cp39-win_amd64.whl (6.8 MB view hashes)

Uploaded CPython 3.9 Windows x86-64

monetdbe-0.11-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.1 MB view hashes)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

monetdbe-0.11-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (4.6 MB view hashes)

Uploaded CPython 3.9 manylinux: glibc 2.17+ ARM64

monetdbe-0.11-cp39-cp39-macosx_12_0_arm64.whl (92.7 kB view hashes)

Uploaded CPython 3.9 macOS 12.0+ ARM64

monetdbe-0.11-cp39-cp39-macosx_10_14_x86_64.whl (4.7 MB view hashes)

Uploaded CPython 3.9 macOS 10.14+ x86-64

monetdbe-0.11-cp38-cp38-win_amd64.whl (6.8 MB view hashes)

Uploaded CPython 3.8 Windows x86-64

monetdbe-0.11-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.1 MB view hashes)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

monetdbe-0.11-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (4.6 MB view hashes)

Uploaded CPython 3.8 manylinux: glibc 2.17+ ARM64

monetdbe-0.11-cp38-cp38-macosx_12_0_arm64.whl (92.7 kB view hashes)

Uploaded CPython 3.8 macOS 12.0+ ARM64

monetdbe-0.11-cp38-cp38-macosx_10_14_x86_64.whl (4.7 MB view hashes)

Uploaded CPython 3.8 macOS 10.14+ x86-64

monetdbe-0.11-cp37-cp37m-win_amd64.whl (6.8 MB view hashes)

Uploaded CPython 3.7m Windows x86-64

monetdbe-0.11-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.1 MB view hashes)

Uploaded CPython 3.7m manylinux: glibc 2.17+ x86-64

monetdbe-0.11-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (4.6 MB view hashes)

Uploaded CPython 3.7m manylinux: glibc 2.17+ ARM64

monetdbe-0.11-cp37-cp37m-macosx_10_14_x86_64.whl (4.7 MB view hashes)

Uploaded CPython 3.7m macOS 10.14+ x86-64

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page