MonetDBe - the Python embedded MonetDB
Project description
MonetDBe-Python
MonetDBe-Python - the serverless Python embedded MonetDB
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.6
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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
File details
Details for the file monetdbe-0.10.tar.gz
.
File metadata
- Download URL: monetdbe-0.10.tar.gz
- Upload date:
- Size: 5.8 MB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 27361a1e37a6426c3a2f08615dd8ae65e06a908597fb66ceaac35047e366265c |
|
MD5 | 17acdba07e713a8be2b9a64b5fb9ba4b |
|
BLAKE2b-256 | 142f9e1a0b4f05c558429808cc92d7bc366be8e7cb9b6b4327aa39e53d1cc8e7 |
File details
Details for the file monetdbe-0.10-cp39-cp39-win_amd64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp39-cp39-win_amd64.whl
- Upload date:
- Size: 5.8 MB
- Tags: CPython 3.9, Windows x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 84361c3b8aa3ac3144e6d1dee9d679c1c643585fbef2fee9f4d4ff2c4f4efa6f |
|
MD5 | 465d04ee4055a07ce4e242da18dfc19c |
|
BLAKE2b-256 | 0ce5b1a6aa9b279d63f470f4b0e3542b01125deb6b223c23d6abd58f31db94d1 |
File details
Details for the file monetdbe-0.10-cp39-cp39-manylinux2014_x86_64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp39-cp39-manylinux2014_x86_64.whl
- Upload date:
- Size: 4.4 MB
- Tags: CPython 3.9
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | e3de8aed7b85e011e238dc3267b7ad0745570af0cf510d424b4bdd8138e02c88 |
|
MD5 | 4788d19e19a6bcba57a45562646693cd |
|
BLAKE2b-256 | 8a1cfc48726149ec9f50535e3069c502ac6200313f08f9dac56fada521fd7d15 |
File details
Details for the file monetdbe-0.10-cp38-cp38-win_amd64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp38-cp38-win_amd64.whl
- Upload date:
- Size: 5.8 MB
- Tags: CPython 3.8, Windows x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | a6a0b52648b6c1ab8ca7f433d6e25f652903de6cb6ae2ff8993e8e0172c11fd8 |
|
MD5 | 5a0929ca5d6b799bd78f2d4c7d8f4695 |
|
BLAKE2b-256 | f8346c3a8a140b24021732ad8ad0eaebea0d83ebf5a49d41012a3a0e6d5e0313 |
File details
Details for the file monetdbe-0.10-cp38-cp38-manylinux2014_x86_64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp38-cp38-manylinux2014_x86_64.whl
- Upload date:
- Size: 4.4 MB
- Tags: CPython 3.8
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8e4df7c5eaeb8927ef869cf9398a102a20f05b029a63a0ef0725f3334f14cff0 |
|
MD5 | 9aafbc3547fc1dcb499c6aaf644e529d |
|
BLAKE2b-256 | 5e161e927a447040a6400db30edcf63cbf7752f322c01c3d98a9b56d4ed6f1c7 |
File details
Details for the file monetdbe-0.10-cp37-cp37m-win_amd64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp37-cp37m-win_amd64.whl
- Upload date:
- Size: 5.8 MB
- Tags: CPython 3.7m, Windows x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7a8e7a47340c814b92eab98b62bdf03ca36f33c523da758f15a12d6ecee4a11 |
|
MD5 | 8c60d9842eca29bc35d32622ce51724e |
|
BLAKE2b-256 | c895eb002149d085ed047ac62c784a186724685390a839eb71aacbbccbb8a4fb |
File details
Details for the file monetdbe-0.10-cp37-cp37m-manylinux2014_x86_64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp37-cp37m-manylinux2014_x86_64.whl
- Upload date:
- Size: 4.4 MB
- Tags: CPython 3.7m
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 339f49dc9f89aa45574e424a30049162c7de21f27c6a416784298ac34876b10b |
|
MD5 | 09706ecec89c28adc54fb0de5437c7cd |
|
BLAKE2b-256 | 08c822b7e2ea17cc63cd73e53e4f2ea2926691a9e7a0b886e9360b24ca22e029 |
File details
Details for the file monetdbe-0.10-cp36-cp36m-win_amd64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp36-cp36m-win_amd64.whl
- Upload date:
- Size: 5.8 MB
- Tags: CPython 3.6m, Windows x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | e7b376dde6749b9a506328351dc29b425392e8b1cdbf128585843f9b282c2165 |
|
MD5 | dc04eaa2fbf2f17e21136d38d25dfbcd |
|
BLAKE2b-256 | 290bb76d57ee04cc2d8fea879e6a822bbacf4d449928ae7ec2b86c463afcae7c |
File details
Details for the file monetdbe-0.10-cp36-cp36m-manylinux2014_x86_64.whl
.
File metadata
- Download URL: monetdbe-0.10-cp36-cp36m-manylinux2014_x86_64.whl
- Upload date:
- Size: 4.4 MB
- Tags: CPython 3.6m
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 807a6147646b580bcb6a5debc7b690e6f451abe81c26dfeaf1dfb0c9e52fbba5 |
|
MD5 | 26ad9b2d3a796409b0bb4bb37a9e713b |
|
BLAKE2b-256 | 40e48ea30330d94e43c566309950db686472f51bb77a354efa05d4c500d08daf |