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
Hashes for monetdbe-0.10-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 84361c3b8aa3ac3144e6d1dee9d679c1c643585fbef2fee9f4d4ff2c4f4efa6f |
|
MD5 | 465d04ee4055a07ce4e242da18dfc19c |
|
BLAKE2b-256 | 0ce5b1a6aa9b279d63f470f4b0e3542b01125deb6b223c23d6abd58f31db94d1 |
Hashes for monetdbe-0.10-cp39-cp39-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e3de8aed7b85e011e238dc3267b7ad0745570af0cf510d424b4bdd8138e02c88 |
|
MD5 | 4788d19e19a6bcba57a45562646693cd |
|
BLAKE2b-256 | 8a1cfc48726149ec9f50535e3069c502ac6200313f08f9dac56fada521fd7d15 |
Hashes for monetdbe-0.10-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a6a0b52648b6c1ab8ca7f433d6e25f652903de6cb6ae2ff8993e8e0172c11fd8 |
|
MD5 | 5a0929ca5d6b799bd78f2d4c7d8f4695 |
|
BLAKE2b-256 | f8346c3a8a140b24021732ad8ad0eaebea0d83ebf5a49d41012a3a0e6d5e0313 |
Hashes for monetdbe-0.10-cp38-cp38-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8e4df7c5eaeb8927ef869cf9398a102a20f05b029a63a0ef0725f3334f14cff0 |
|
MD5 | 9aafbc3547fc1dcb499c6aaf644e529d |
|
BLAKE2b-256 | 5e161e927a447040a6400db30edcf63cbf7752f322c01c3d98a9b56d4ed6f1c7 |
Hashes for monetdbe-0.10-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7a8e7a47340c814b92eab98b62bdf03ca36f33c523da758f15a12d6ecee4a11 |
|
MD5 | 8c60d9842eca29bc35d32622ce51724e |
|
BLAKE2b-256 | c895eb002149d085ed047ac62c784a186724685390a839eb71aacbbccbb8a4fb |
Hashes for monetdbe-0.10-cp37-cp37m-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 339f49dc9f89aa45574e424a30049162c7de21f27c6a416784298ac34876b10b |
|
MD5 | 09706ecec89c28adc54fb0de5437c7cd |
|
BLAKE2b-256 | 08c822b7e2ea17cc63cd73e53e4f2ea2926691a9e7a0b886e9360b24ca22e029 |
Hashes for monetdbe-0.10-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e7b376dde6749b9a506328351dc29b425392e8b1cdbf128585843f9b282c2165 |
|
MD5 | dc04eaa2fbf2f17e21136d38d25dfbcd |
|
BLAKE2b-256 | 290bb76d57ee04cc2d8fea879e6a822bbacf4d449928ae7ec2b86c463afcae7c |
Hashes for monetdbe-0.10-cp36-cp36m-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 807a6147646b580bcb6a5debc7b690e6f451abe81c26dfeaf1dfb0c9e52fbba5 |
|
MD5 | 26ad9b2d3a796409b0bb4bb37a9e713b |
|
BLAKE2b-256 | 40e48ea30330d94e43c566309950db686472f51bb77a354efa05d4c500d08daf |