Skip to main content

MonetDBe - the Python embedded MonetDB

Project description

MonetDBe-Python

MonetDBe-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.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


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.10.1.tar.gz (62.8 kB view details)

Uploaded Source

Built Distributions

monetdbe-0.10.1-cp39-cp39-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.9 Windows x86-64

monetdbe-0.10.1-cp39-cp39-manylinux2014_x86_64.whl (4.4 MB view details)

Uploaded CPython 3.9

monetdbe-0.10.1-cp39-cp39-macosx_10_14_x86_64.whl (4.7 MB view details)

Uploaded CPython 3.9 macOS 10.14+ x86-64

monetdbe-0.10.1-cp38-cp38-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.8 Windows x86-64

monetdbe-0.10.1-cp38-cp38-manylinux2014_x86_64.whl (4.4 MB view details)

Uploaded CPython 3.8

monetdbe-0.10.1-cp38-cp38-macosx_10_14_x86_64.whl (4.7 MB view details)

Uploaded CPython 3.8 macOS 10.14+ x86-64

monetdbe-0.10.1-cp37-cp37m-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.7m Windows x86-64

monetdbe-0.10.1-cp37-cp37m-manylinux2014_x86_64.whl (4.4 MB view details)

Uploaded CPython 3.7m

monetdbe-0.10.1-cp37-cp37m-macosx_10_14_x86_64.whl (4.7 MB view details)

Uploaded CPython 3.7m macOS 10.14+ x86-64

monetdbe-0.10.1-cp36-cp36m-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.6m Windows x86-64

monetdbe-0.10.1-cp36-cp36m-manylinux2014_x86_64.whl (4.4 MB view details)

Uploaded CPython 3.6m

monetdbe-0.10.1-cp36-cp36m-macosx_10_14_x86_64.whl (4.7 MB view details)

Uploaded CPython 3.6m macOS 10.14+ x86-64

File details

Details for the file monetdbe-0.10.1.tar.gz.

File metadata

  • Download URL: monetdbe-0.10.1.tar.gz
  • Upload date:
  • Size: 62.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.0 importlib_metadata/4.8.2 pkginfo/1.8.2 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.10.1.tar.gz
Algorithm Hash digest
SHA256 2b1a77e7cf50c385f49f64659e5e2ea37b7e2350e8a36da284ca24c846f6a4f8
MD5 4abb5a27671f248d30f1e3b730b208c7
BLAKE2b-256 fb613d004a67f2559b55596689957334ef17fdeea8e2c4b24c61ee5c1c133b81

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp39-cp39-win_amd64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 6b2add0204b72dc8b84f578091eeb40bba80d15fb56f65631af43cbc5a9e8d36
MD5 6f8c31ee9821e344c58466820a873761
BLAKE2b-256 c5fe9e4a5a0330eee978f281d212974e2f4898b591830bfbcd9f27a76bfab89a

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp39-cp39-manylinux2014_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp39-cp39-manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 7bb60923f14960e1c84b20b8807277807749f44e074b011b440943ff969f3935
MD5 2b810f3e0beb2e9799bb3db6aba82bd2
BLAKE2b-256 f7bbca98b06ca9bd57145d376536b86e3f0242ca19d2b60688b4458b47cfaee1

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp39-cp39-macosx_10_14_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-cp39-cp39-macosx_10_14_x86_64.whl
  • Upload date:
  • Size: 4.7 MB
  • Tags: CPython 3.9, macOS 10.14+ 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

Hashes for monetdbe-0.10.1-cp39-cp39-macosx_10_14_x86_64.whl
Algorithm Hash digest
SHA256 6fdb882d64ae81a122175fc75f9a95896ff1162d4566f80dca55e3efbcde8ae0
MD5 212cfb693e40b8f870953b2c01330ca5
BLAKE2b-256 f12da0a87ded3f2af7302ca91871e4b888d389438fce341d99744079e5b7e66b

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp38-cp38-win_amd64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 68e9a465dbdf8756dc6a8c3ca7644f1f3fe273100142f90e85b80a8676b68413
MD5 1dab0184e599413a6a66d7b39e8b18c1
BLAKE2b-256 5800e823cb204b525511d99a52c8073f615cbf0be0eb2b2d828bc2a6c3514721

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp38-cp38-manylinux2014_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp38-cp38-manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 917f13a382200e064446d6048e95cf4625d728aafc4a18059b07b3cd5af10e23
MD5 1b691f5ba5393330b08f9478ffb2c8b4
BLAKE2b-256 7113cae13daf8871a34ec47cda12d5ce85da6d590fc3c5466f832365588f6c98

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp38-cp38-macosx_10_14_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-cp38-cp38-macosx_10_14_x86_64.whl
  • Upload date:
  • Size: 4.7 MB
  • Tags: CPython 3.8, macOS 10.14+ 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

Hashes for monetdbe-0.10.1-cp38-cp38-macosx_10_14_x86_64.whl
Algorithm Hash digest
SHA256 a7125c5cd76ec080696e94b2abf0522e1e661060961a3d131ffc4c261c89a11b
MD5 9894aba73100fd2a592c9b98deb9412c
BLAKE2b-256 70e2cbf4350ef791390b559c9686cb7cdd8de49c9948db03547cf53582ecb3b4

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp37-cp37m-win_amd64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 90dc199e2ed4616a07f0f9e0fce4d252b631a8a0e10e9e9a4b6e2cc2aabee7f3
MD5 03bec56ea031a9cd5068bc17eddfa848
BLAKE2b-256 e0bb91c4fa7ae6dd15f57b2af537b88c06c596a1fa1d7b8e3beaae627beca4d9

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp37-cp37m-manylinux2014_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp37-cp37m-manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 c28d6acff8b67e7dfed69729eaea98c79fde2405e8e233fed8ad5b6b07b2a619
MD5 7d968b1de772d37a60b4fcd15a419007
BLAKE2b-256 bbc55b2840669ec875134dba58f9071e1fd014e09c8f6790fbc8cb618cf6f6b8

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp37-cp37m-macosx_10_14_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-cp37-cp37m-macosx_10_14_x86_64.whl
  • Upload date:
  • Size: 4.7 MB
  • Tags: CPython 3.7m, macOS 10.14+ 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

Hashes for monetdbe-0.10.1-cp37-cp37m-macosx_10_14_x86_64.whl
Algorithm Hash digest
SHA256 fafc8801a5703d90a89d1bc71270b0136bd3cdec61107866359851859194f059
MD5 0cd01f58040df81b34784f2e3280bdda
BLAKE2b-256 1e703ed6a30556ae051d4417c291a46d4c737f8d8b428b24a6e0cf4b8b3e6abb

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp36-cp36m-win_amd64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 33edba9aaf438cec05a9348bba4d2f7369bcaa2ddc26d5303de5dad8b4fd8b82
MD5 605c272e2476725a50c3ae87d738a2a2
BLAKE2b-256 49edbbd1bc839ac639f982586fe5a51a2609466d87f1d118b9f0ce25120f778c

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp36-cp36m-manylinux2014_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-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

Hashes for monetdbe-0.10.1-cp36-cp36m-manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 1e2e5ceea11ce1d363447a6d7b70fa51dc36c8fce41cef424eba1ee8634c80eb
MD5 bd10989082a4591979c4739b88143ea5
BLAKE2b-256 4aaab980bc700571b3f6e83669b352b05d64abe8ab29d732766c9b71f0099780

See more details on using hashes here.

File details

Details for the file monetdbe-0.10.1-cp36-cp36m-macosx_10_14_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.10.1-cp36-cp36m-macosx_10_14_x86_64.whl
  • Upload date:
  • Size: 4.7 MB
  • Tags: CPython 3.6m, macOS 10.14+ 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

Hashes for monetdbe-0.10.1-cp36-cp36m-macosx_10_14_x86_64.whl
Algorithm Hash digest
SHA256 f99c2caa01c6cfbc437c1dc86a213e4aae99ec60b438073ae8bf701bbb592399
MD5 93a69a6298c35cd4baa4eef8a6953040
BLAKE2b-256 18db10fb0bd66e3db2cfed15003ea1db08709a8915ee8bbe9988732f4704b725

See more details on using hashes here.

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