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 details)

Uploaded Source

Built Distributions

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

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 details)

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 details)

Uploaded CPython 3.10 manylinux: glibc 2.17+ ARM64

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

Uploaded CPython 3.10 macOS 12.0+ ARM64

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

Uploaded CPython 3.10 macOS 10.15+ x86-64

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

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 details)

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 details)

Uploaded CPython 3.9 manylinux: glibc 2.17+ ARM64

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

Uploaded CPython 3.9 macOS 12.0+ ARM64

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

Uploaded CPython 3.9 macOS 10.14+ x86-64

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

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 details)

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 details)

Uploaded CPython 3.8 manylinux: glibc 2.17+ ARM64

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

Uploaded CPython 3.8 macOS 12.0+ ARM64

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

Uploaded CPython 3.8 macOS 10.14+ x86-64

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

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 details)

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 details)

Uploaded CPython 3.7m manylinux: glibc 2.17+ ARM64

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

Uploaded CPython 3.7m macOS 10.14+ x86-64

File details

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

File metadata

  • Download URL: monetdbe-0.11.tar.gz
  • Upload date:
  • Size: 68.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11.tar.gz
Algorithm Hash digest
SHA256 25b7468bcf89d94183a959d1c3f63aa1d819f922e4690a79292540080e9bd7d6
MD5 c8bbb9d3b1a1340141a4b87459de28ee
BLAKE2b-256 aec2ac8ffc8ad913630d189a8a1c4cbc2b7478b834194c00a66a5ff48b01c75c

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp310-cp310-win_amd64.whl.

File metadata

  • Download URL: monetdbe-0.11-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 6.8 MB
  • Tags: CPython 3.10, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 d8260f158247a84227be3638620770677718ecfb31ad4d80f618893666ec3d64
MD5 ebc94605e857d0473ff151642cfdee36
BLAKE2b-256 a0d6ead9f054fbbc3414f8038b22ac13fa55bd42aacb107a06ce1e8830817c42

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 4f42d6328ac2ffddc6de07271671431c90c40c5560ce4790e789a24ef6dfa55d
MD5 853055ef1a06181836c09dd609ad8902
BLAKE2b-256 e835f750600fc474ad4032a5f59f096b44c195c8109f796246d0be2ff1317db5

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm Hash digest
SHA256 af768cba3d5fd408988a071bc8d99b9d4414d0741b37392fe8f4e3fde1f232cb
MD5 1317c5e2c0ae4395cabd74b11a50bd8e
BLAKE2b-256 3a0bf0564e4a06410aca56866ee3f6b9f169d917f1afc2133dbfdcd326966e55

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp310-cp310-macosx_12_0_arm64.whl.

File metadata

  • Download URL: monetdbe-0.11-cp310-cp310-macosx_12_0_arm64.whl
  • Upload date:
  • Size: 92.7 kB
  • Tags: CPython 3.10, macOS 12.0+ ARM64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp310-cp310-macosx_12_0_arm64.whl
Algorithm Hash digest
SHA256 02f0aff928de9511928ffc8afe1cac5f9b4794e03f539b41d642826928a72709
MD5 cab150432a8553979745c0a73fcc16ba
BLAKE2b-256 814b570c67d1c2fa3eba7728a62c34d1d1782134fe4e0fd91155b79f3aefebac

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp310-cp310-macosx_10_15_x86_64.whl.

File metadata

  • Download URL: monetdbe-0.11-cp310-cp310-macosx_10_15_x86_64.whl
  • Upload date:
  • Size: 4.7 MB
  • Tags: CPython 3.10, macOS 10.15+ x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp310-cp310-macosx_10_15_x86_64.whl
Algorithm Hash digest
SHA256 cb0d4194378da6467efc7ff0d77bc9a6747e4ba4d093296c45c3fbfa4417b3c6
MD5 bf16e57b54059554a1c4f1770cb7dca3
BLAKE2b-256 bc3119d4117b0218dbf6f46fb6215771fccaef5baad2e316e0672d32536ee0dd

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: monetdbe-0.11-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 6.8 MB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 fe1c47d42ee576b25297ae664039f4b72689bb5498954d62a4fa53ce2f584657
MD5 23e9df2b8f0df775f8059bb4e4d3dd72
BLAKE2b-256 56b78dff223f34c6dc68ce4bab629e7a45b8e427ca9f8b0030c4ce3dc15ef1ec

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 2d62d287f88caeb9307450315834a6a08285efc957e65ed36ac1f855178ab208
MD5 8058a21b4074a2a9b875415ff709de25
BLAKE2b-256 344f81d04b9043afb8c4f8ba0fae38ed69f451d3b3546e890624d4ff600711f9

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm Hash digest
SHA256 567fd1b4674e95259a9f51d34b61170a5874a4f717f15a20283028b8fb721923
MD5 497a691b4ef1c0df61ff1c22369344fd
BLAKE2b-256 2f8488109afca6838840ca8873d571b32aa3882d61a5b628bcb8ebb7332f1e6d

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp39-cp39-macosx_12_0_arm64.whl.

File metadata

  • Download URL: monetdbe-0.11-cp39-cp39-macosx_12_0_arm64.whl
  • Upload date:
  • Size: 92.7 kB
  • Tags: CPython 3.9, macOS 12.0+ ARM64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp39-cp39-macosx_12_0_arm64.whl
Algorithm Hash digest
SHA256 1c1d4070b2d563d17c60f6e401259d1389ddc18d44275cf0e49f4024cb3eaac7
MD5 e0094d01116f9eed06180e97ff07a68e
BLAKE2b-256 11d2b07c4a78bfe10990c0289aff3dad1fa645a7b54a72c288f42ef6dc782249

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: monetdbe-0.11-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.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp39-cp39-macosx_10_14_x86_64.whl
Algorithm Hash digest
SHA256 b87f5061bb91673ab56b57dae2368d4f2ef698df9e523fdaafdcc3b6d0a5d4d0
MD5 2bc689a2aacd5e8ead270f75f6338f41
BLAKE2b-256 7764ecf5b37c1b5b67b88745e944f2a678baea5353d912d5d70c9f3fa05ac4a8

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: monetdbe-0.11-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 6.8 MB
  • Tags: CPython 3.8, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 77a29b1ef0e882c0592f0fb1f9b5c9b0556aa944a986cb5996bb30d9aea7eb01
MD5 953a08e69d334d00de1789838841b479
BLAKE2b-256 29597ccae4fd5cfdc16700066cef4344865b1965fd61acf83c5b42fa98d33977

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 a3d53580107a04774801d1064d310836774a587eb245206ef558425bd06916bb
MD5 d54f73fe69045ce369929d781c4d656c
BLAKE2b-256 ed7fed1a218bfee493e2dfb33b5e9f8fc2b862025c8a253fb1dc5e14662dfc6e

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm Hash digest
SHA256 b83ba31b1b2370f5e29987b1faf4b7c8bff0db3c94020ceb307f21c964a9aea1
MD5 c6779d573a1deab3b54d3ac78c41f1d7
BLAKE2b-256 2843a77e046734776cf455a1157a1c51ef230faed6ae846f303f9651f48eff52

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp38-cp38-macosx_12_0_arm64.whl.

File metadata

  • Download URL: monetdbe-0.11-cp38-cp38-macosx_12_0_arm64.whl
  • Upload date:
  • Size: 92.7 kB
  • Tags: CPython 3.8, macOS 12.0+ ARM64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp38-cp38-macosx_12_0_arm64.whl
Algorithm Hash digest
SHA256 65835d16503c6e8ec2272897fd4af95a31ddebda00046943cc39fad39accd9d1
MD5 be847a2966eb1b5fe81fc66d0607cf72
BLAKE2b-256 73c85176a0906595107107196d3439b24d68faafafd04784cf4b10fd95ab48d5

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: monetdbe-0.11-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.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp38-cp38-macosx_10_14_x86_64.whl
Algorithm Hash digest
SHA256 e5c91270f415e39d7b0e5c976076a51f237796112d91f8a1dfdce991d55f03ff
MD5 520bd67caa6c3de93b5b668802007454
BLAKE2b-256 b16020625ef73404006e9610eb6dd33ab4620f42dcf37eb6ca429b1906f8996b

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: monetdbe-0.11-cp37-cp37m-win_amd64.whl
  • Upload date:
  • Size: 6.8 MB
  • Tags: CPython 3.7m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 868ca14ec6b447922035a20ab6bd9f4244c1b3c8005a2b9bf3cf9051ba31ad74
MD5 5a2ec0fdc33caecb1111b10fc634562a
BLAKE2b-256 d01e5ccb66697d36221f36b3cd3392830c95548fd7b8dad0cb808c6952e8dede

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 6b716226209fbc1aec78e83b52bc4cd06e8578fc37e13509e92d73816fd4064b
MD5 846faed9f8d04b10192f89afd4bba8ff
BLAKE2b-256 941f7ccb1f3821eae08bfc74330a9a9786cdba06c5b99817c5237e80e643e906

See more details on using hashes here.

Provenance

File details

Details for the file monetdbe-0.11-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl.

File metadata

File hashes

Hashes for monetdbe-0.11-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm Hash digest
SHA256 b40aeadda6fee2fbaa3059447978f6bef8a5c088923aa7170b34eebd3ad4ece5
MD5 d2c9b9bbf42da6bde3c15c9d05f1fb53
BLAKE2b-256 8ba11f247aa5849e8b76bc8b811b22b97c82cb64ba213554b7959fd027f2c77e

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: monetdbe-0.11-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.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.9

File hashes

Hashes for monetdbe-0.11-cp37-cp37m-macosx_10_14_x86_64.whl
Algorithm Hash digest
SHA256 77a613b911dab4183bbd90cecb79828550c2570b510edacdfbadbe6d9a032bfa
MD5 c4c627e7168d380d73116ec76e45f5b6
BLAKE2b-256 4bd722e0435992079b320b251e5cbd86dad6ed9692c67f449488296c8f457f20

See more details on using hashes here.

Provenance

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