The MonetDB Python API

pymonetdb is the native Python client API for monetDB. It is cross-platform and does not depend on any MonetDB libraries. It supports Python 3.6+ and PyPy and is Python DBAPI 2.0 compatible.

Besides the functionality required by DBAPI 2.0, pymonetdb also provides some MonetDB-specific functionality, in particular file transfers. These are detailed in the API section.

Contents

• Getting Started
  • Installation
  • Connecting
• Examples
  • Example session
  • MAPI Connection
  • CSV Upload
• File Transfers
  • Make up data as you go
  • Skip amount
  • Cancellation
  • Copying data from or to a file-like object
  • Security considerations
• Result set batch size
  • Batching behavior
  • New result set format
  • Tweaking the behavior
  • Arraysize
• API
  • Basic SQL usage
  • Type conversion
  • MAPI
  • File Uploads and Downloads
  • MonetDB remote control
  • pymonetdb Exceptions
• Development
  • Github
  • Test suite

Indices and tables

• Index
• Module Index
• Search Page