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.1-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6b2add0204b72dc8b84f578091eeb40bba80d15fb56f65631af43cbc5a9e8d36 |
|
MD5 | 6f8c31ee9821e344c58466820a873761 |
|
BLAKE2b-256 | c5fe9e4a5a0330eee978f281d212974e2f4898b591830bfbcd9f27a76bfab89a |
Hashes for monetdbe-0.10.1-cp39-cp39-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7bb60923f14960e1c84b20b8807277807749f44e074b011b440943ff969f3935 |
|
MD5 | 2b810f3e0beb2e9799bb3db6aba82bd2 |
|
BLAKE2b-256 | f7bbca98b06ca9bd57145d376536b86e3f0242ca19d2b60688b4458b47cfaee1 |
Hashes for monetdbe-0.10.1-cp39-cp39-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6fdb882d64ae81a122175fc75f9a95896ff1162d4566f80dca55e3efbcde8ae0 |
|
MD5 | 212cfb693e40b8f870953b2c01330ca5 |
|
BLAKE2b-256 | f12da0a87ded3f2af7302ca91871e4b888d389438fce341d99744079e5b7e66b |
Hashes for monetdbe-0.10.1-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 68e9a465dbdf8756dc6a8c3ca7644f1f3fe273100142f90e85b80a8676b68413 |
|
MD5 | 1dab0184e599413a6a66d7b39e8b18c1 |
|
BLAKE2b-256 | 5800e823cb204b525511d99a52c8073f615cbf0be0eb2b2d828bc2a6c3514721 |
Hashes for monetdbe-0.10.1-cp38-cp38-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 917f13a382200e064446d6048e95cf4625d728aafc4a18059b07b3cd5af10e23 |
|
MD5 | 1b691f5ba5393330b08f9478ffb2c8b4 |
|
BLAKE2b-256 | 7113cae13daf8871a34ec47cda12d5ce85da6d590fc3c5466f832365588f6c98 |
Hashes for monetdbe-0.10.1-cp38-cp38-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a7125c5cd76ec080696e94b2abf0522e1e661060961a3d131ffc4c261c89a11b |
|
MD5 | 9894aba73100fd2a592c9b98deb9412c |
|
BLAKE2b-256 | 70e2cbf4350ef791390b559c9686cb7cdd8de49c9948db03547cf53582ecb3b4 |
Hashes for monetdbe-0.10.1-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 90dc199e2ed4616a07f0f9e0fce4d252b631a8a0e10e9e9a4b6e2cc2aabee7f3 |
|
MD5 | 03bec56ea031a9cd5068bc17eddfa848 |
|
BLAKE2b-256 | e0bb91c4fa7ae6dd15f57b2af537b88c06c596a1fa1d7b8e3beaae627beca4d9 |
Hashes for monetdbe-0.10.1-cp37-cp37m-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c28d6acff8b67e7dfed69729eaea98c79fde2405e8e233fed8ad5b6b07b2a619 |
|
MD5 | 7d968b1de772d37a60b4fcd15a419007 |
|
BLAKE2b-256 | bbc55b2840669ec875134dba58f9071e1fd014e09c8f6790fbc8cb618cf6f6b8 |
Hashes for monetdbe-0.10.1-cp37-cp37m-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fafc8801a5703d90a89d1bc71270b0136bd3cdec61107866359851859194f059 |
|
MD5 | 0cd01f58040df81b34784f2e3280bdda |
|
BLAKE2b-256 | 1e703ed6a30556ae051d4417c291a46d4c737f8d8b428b24a6e0cf4b8b3e6abb |
Hashes for monetdbe-0.10.1-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 33edba9aaf438cec05a9348bba4d2f7369bcaa2ddc26d5303de5dad8b4fd8b82 |
|
MD5 | 605c272e2476725a50c3ae87d738a2a2 |
|
BLAKE2b-256 | 49edbbd1bc839ac639f982586fe5a51a2609466d87f1d118b9f0ce25120f778c |
Hashes for monetdbe-0.10.1-cp36-cp36m-manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1e2e5ceea11ce1d363447a6d7b70fa51dc36c8fce41cef424eba1ee8634c80eb |
|
MD5 | bd10989082a4591979c4739b88143ea5 |
|
BLAKE2b-256 | 4aaab980bc700571b3f6e83669b352b05d64abe8ab29d732766c9b71f0099780 |
Hashes for monetdbe-0.10.1-cp36-cp36m-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f99c2caa01c6cfbc437c1dc86a213e4aae99ec60b438073ae8bf701bbb592399 |
|
MD5 | 93a69a6298c35cd4baa4eef8a6953040 |
|
BLAKE2b-256 | 18db10fb0bd66e3db2cfed15003ea1db08709a8915ee8bbe9988732f4704b725 |