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.

Files for monetdbe, version 0.10.1
Filename, size File type Python version Upload date Hashes
Filename, size monetdbe-0.10.1-cp36-cp36m-macosx_10_14_x86_64.whl (4.7 MB) File type Wheel Python version cp36 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp36-cp36m-manylinux2014_x86_64.whl (4.4 MB) File type Wheel Python version cp36 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp36-cp36m-win_amd64.whl (5.8 MB) File type Wheel Python version cp36 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp37-cp37m-macosx_10_14_x86_64.whl (4.7 MB) File type Wheel Python version cp37 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp37-cp37m-manylinux2014_x86_64.whl (4.4 MB) File type Wheel Python version cp37 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp37-cp37m-win_amd64.whl (5.8 MB) File type Wheel Python version cp37 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp38-cp38-macosx_10_14_x86_64.whl (4.7 MB) File type Wheel Python version cp38 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp38-cp38-manylinux2014_x86_64.whl (4.4 MB) File type Wheel Python version cp38 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp38-cp38-win_amd64.whl (5.8 MB) File type Wheel Python version cp38 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp39-cp39-macosx_10_14_x86_64.whl (4.7 MB) File type Wheel Python version cp39 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp39-cp39-manylinux2014_x86_64.whl (4.4 MB) File type Wheel Python version cp39 Upload date Hashes View
Filename, size monetdbe-0.10.1-cp39-cp39-win_amd64.whl (5.8 MB) File type Wheel Python version cp39 Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page