MimerPy – Python database interface for Mimer SQL

MimerPy is an adapter for Mimer SQL in Python which implements the PEP 249 specification. It allows the user to connect to Mimer SQL through Python, gaining access of the exceptional performance and powerful features provided by a Mimer SQL database. MimerPy uses the Mimer SQL C API also known as Mimer API using ctypes.

The following documentation covers the full interface of MimerPy, demonstrating how to install and use the product through simple guides and easy to read examples.

Contents:

• 1. Introduction
• 2. Installation guide
  • 2.1. Requirements
  • 2.2. Mimer SQL C API
  • 2.3. Installing with pip
  • 2.4. Installing from source
• 3. Getting started
  • 3.1. Checking the MimerPy installation
  • 3.2. Establishing a connection
  • 3.3. Executing statements
  • 3.4. Running your first program
• 4. The MimerPy module
  • 4.1. The module
  • 4.2. Connection
  • 4.3. Connection pool
  • 4.4. Cursor
• 5. Data types
  • 5.1. BOOLEAN
  • 5.2. INTEGER, INTEGER(p), BIGINT, and SMALLINT
  • 5.3. DOUBLE PRECISION, FLOAT and REAL
  • 5.4. FLOAT(p) and DECIMAL(p,s)
  • 5.5. BINARY(n)
  • 5.6. VARBINARY(n)
  • 5.7. BLOB(n[K|M|G])
  • 5.8. CLOB(n[K|M|G])
  • 5.9. NCLOB(n)
  • 5.10. CHAR(n)
  • 5.11. VARCHAR(n)
  • 5.12. NCHAR(n)
  • 5.13. NVARCHAR(n)
  • 5.14. DATE
  • 5.15. TIME(s)
  • 5.16. TIMESTAMP(s)
  • 5.17. Universally Unique Identifier (UUID)
  • 5.18. INTERVAL
  • 5.19. GIS_LOCATION, GIS_LATITUDE, and GIS_LONGITUDE
  • 5.20. NULL
• 6. Exceptions
  • 6.1. Database Exceptions
  • 6.2. MimerPool Exceptions
  • 6.3. Messages
  • 6.4. Errorhandler
• 7. User guide
  • 7.1. Connection parameters
  • 7.2. Query structure
  • 7.3. Transaction control
• 8. Code examples
  • 8.1. Inserting a BLOB
  • 8.2. Using with
  • 8.3. Iterating a result set
  • 8.4. Scrolling
  • 8.5. Executemany
  • 8.6. Error handling
  • 8.7. Transaction loop
  • 8.8. Alternative Transaction loop
  • 8.9. Using the connection pool
• 9. Release Notes
  • 9.1. MimerPy Version 1.1
  • 9.2. MimerPy Version 1.3.0
  • 9.3. MimerPy Version 1.3.1
• 10. Legal Notice
  • 10.1. License
  • 10.2. Open source

Indices and tables

• Index

• Search Page