Metadata-Version: 2.1
Name: RelStorage
Version: 3.1.2
Summary: A backend for ZODB that stores pickles in a relational database.
Home-page: https://relstorage.readthedocs.io/
Author: Shane Hathaway with Zope Foundation and Contributors
Author-email: shane@willowrise.com
Maintainer: Jason Madden
Maintainer-email: jason@nextthought.com
License: ZPL 2.1
Project-URL: Bug Tracker, https://github.com/zodb/relstorage/issues
Project-URL: Source Code, https://github.com/zodb/relstorage/
Project-URL: Documentation, https://relstorage.readthedocs.io
Keywords: ZODB SQL RDBMS MySQL PostgreSQL Oracle
Platform: any
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: Zope Public License
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: Implementation :: CPython
Classifier: Programming Language :: Python :: Implementation :: PyPy
Classifier: Topic :: Database
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Operating System :: Microsoft :: Windows
Classifier: Operating System :: Unix
Classifier: Development Status :: 4 - Beta
Requires-Dist: perfmetrics (>=3.0.0)
Requires-Dist: zope.interface
Requires-Dist: zope.dottedname
Requires-Dist: zc.lockfile
Requires-Dist: BTrees (>=4.7.2)
Requires-Dist: ZODB (>=5.5)
Requires-Dist: transaction (>=2.4.0)
Provides-Extra: all_tested_drivers
Requires-Dist: psycopg2 (>=2.8.3) ; (platform_python_implementation == "CPython") and extra == 'all_tested_drivers'
Requires-Dist: mysqlclient (!=2.0.0,>=1.4) ; (platform_python_implementation == "CPython" and sys_platform != "win32") and extra == 'all_tested_drivers'
Requires-Dist: pg8000 (>=1.11.0) ; (python_version == "2.7" or platform_python_implementation == "PyPy") and extra == 'all_tested_drivers'
Requires-Dist: psycopg2cffi (>=2.7.4) ; (python_version == "3.5" or platform_python_implementation == "PyPy") and extra == 'all_tested_drivers'
Requires-Dist: PyMySQL (>=0.6.6) ; (python_version == "3.6" or platform_python_implementation == "PyPy" or sys_platform == "win32") and extra == 'all_tested_drivers'
Requires-Dist: mysql-connector-python (>=8.0.16) ; (python_version == "3.7" or platform_python_implementation == "PyPy") and extra == 'all_tested_drivers'
Provides-Extra: docs
Requires-Dist: sphinxcontrib-programoutput ; extra == 'docs'
Requires-Dist: repoze.sphinx.autointerface ; extra == 'docs'
Requires-Dist: sphinx-rtd-theme ; extra == 'docs'
Provides-Extra: memcache
Requires-Dist: pylibmc ; (platform_python_implementation == "CPython" and sys_platform != "win32") and extra == 'memcache'
Requires-Dist: python-memcached ; (platform_python_implementation == "PyPy" or sys_platform == "win32") and extra == 'memcache'
Provides-Extra: mysql
Requires-Dist: mysqlclient (!=2.0.0,>=1.4) ; (platform_python_implementation=="CPython" and (sys_platform != "win32")) and extra == 'mysql'
Requires-Dist: PyMySQL (>=0.6.6) ; (platform_python_implementation=="PyPy" or (sys_platform == "win32")) and extra == 'mysql'
Provides-Extra: oracle
Requires-Dist: cx-Oracle (>=6.0) ; extra == 'oracle'
Provides-Extra: postgresql
Requires-Dist: psycopg2 (>=2.8.3) ; ( platform_python_implementation == "CPython") and extra == 'postgresql'
Requires-Dist: psycopg2cffi (>=2.8.1) ; ( platform_python_implementation == "PyPy") and extra == 'postgresql'
Provides-Extra: test
Requires-Dist: random2 ; extra == 'test'
Requires-Dist: zope.testing ; extra == 'test'
Requires-Dist: ZODB[test] ; extra == 'test'
Requires-Dist: zc.zlibstorage ; extra == 'test'
Requires-Dist: zope.testrunner ; extra == 'test'
Requires-Dist: nti.testing ; extra == 'test'
Requires-Dist: pyperf ; extra == 'test'
Requires-Dist: pylibmc ; (platform_python_implementation == "CPython" and sys_platform != "win32") and extra == 'test'
Requires-Dist: psutil ; (platform_python_implementation == "CPython" or python_version != "2.7") and extra == 'test'
Requires-Dist: psutil (==5.6.3) ; (platform_python_implementation == "PyPy" and python_version == "2.7") and extra == 'test'
Requires-Dist: python-memcached ; (platform_python_implementation == "PyPy" or sys_platform == "win32") and extra == 'test'
Requires-Dist: mock ; (python_version == "2.7") and extra == 'test'
Requires-Dist: ZEO (>=5.2) ; (python_version > "2.7") and extra == 'test'
Requires-Dist: gevent (>=1.5a1) ; (sys_platform != "win32") and extra == 'test'


..
  This file is the long-description for PyPI so it can only use plain
  ReST, no sphinx extensions.

RelStorage is a storage implementation for ZODB that stores pickles in
a relational database (`RDBMS`_). PostgreSQL 9.6 and above, MySQL
5.7.19 / 8.0, Oracle 10g and above, and SQLite 3.8.3 and above are
currently supported. RelStorage replaced the PGStorage project.

.. _RDBMS: https://en.wikipedia.org/wiki/Relational_database_

==========
 Features
==========

* It is a drop-in replacement for FileStorage and ZEO, with several
  enhancements:

  * Supports undo, packing, and object history preservation just like
    FileStorage.
  * RelStorage can be configured *not* to keep object histories for
    reduced disk space usage and improved performance.
  * Multiple processes on a single machine can read and write a local
    ZODB database using SQLite without needing to start and manage
    another process (i.e., ZEO).
  * Blobs can be stored on a shared filesystem, or (recommended) in
    the relational database and only cached locally.
  * Multiple threads in the same process share a high-performance
    in-memory pickle cache to reduce the number of queries to the
    RDBMS. This is similar to ZEO, and the ZEO cache trace tools are
    supported.
  * The in-memory pickle cache can be saved to disk and read when a
    process starts up. This can dramatically speed up site warmup time
    by eliminating a flood of RDBMS queries. Unlike ZEO, this cache
    is automatically shared by all processes on the machine (no need
    to configure separate client identifiers.)

* Ideal for large, high volume sites.

  * Multiple Python processes on multiple machines can read and write
    the same ZODB database concurrently. This is similar to ZEO, but
    RelStorage does not require ZEO.
  * Supports ZODB 5's parallel commit feature: Database writers only
    block each other when they would conflict (except for a small
    window at the end of the twophase commit protocol when the
    transaction ID is allocated; that still requires a global database
    lock).
  * According to some tests, RelStorage handles concurrency better than
    the standard combination of ZEO and FileStorage.
  * Whereas FileStorage takes longer to start as the database grows
    due to an in-memory index of all objects, RelStorage starts
    quickly regardless of database size.
  * Capable of failover to replicated SQL databases.
* Tested integration with `gevent`_ for PostgreSQL and MySQL.
* There is a simple way (`zodbconvert`_) to (incrementally) convert
  FileStorage to RelStorage and back again. You can also convert a
  RelStorage instance to a different relational database. This is a
  general tool that can be used to convert between any two ZODB
  storage implementations.
* There is a simple way (`zodbpack`_) to pack databases.
* Supports `zodburi`_ .
* Free, open source (ZPL 2.1)

.. _gevent: http://gevent.org_
.. _zodbconvert: https://relstorage.readthedocs.io/en/latest/zodbconvert.html_
.. _zodbpack: https://relstorage.readthedocs.io/en/latest/zodbpack.html_
.. _zodburi: https://relstorage.readthedocs.io/en/latest/zodburi.html

Features Supported by Databases
===============================

Some of RelStorage's features are only supported on certain versions
of certain databases. If the database doesn't support the feature,
RelStorage will still work, but possibly with a performance penalty.


.. list-table:: Supported Features
   :widths: auto
   :header-rows: 1
   :stub-columns: 1

   * -
     - Parallel Commit
     - Shared readCurrent locks
     - Non-blocking readCurrent locks
     - Streaming blobs
     - Central transaction ID allocation
     - Atomic lock and commit without Python involvement
   * - PostgreSQL
     - Yes
     - Yes
     - Yes
     - With psycopg2 driver
     - Yes
     - Yes, except with PG8000 driver
   * - MySQL
     - Yes
     - Yes
     - Native on MySQL 8.0, emulated on MySQL 5.7
     - No, emulated via chunking
     - Yes
     - Yes
   * - Oracle
     - Yes
     - No
     - Yes
     - Yes
     - No (could probably be implemented)
     - No (could probably be implemented)
   * - SQLite
     - No
     - No
     - N/A (there is no distinction in lock types)
     - No, consider using a shared-blob-dir
     - N/A (essentially yes because it happens on one machine)
     - No


===============
 Documentation
===============

Documentation including `installation instructions`_ is hosted on `readthedocs`_.

The complete `changelog`_ is also there.

.. image:: https://readthedocs.org/projects/relstorage/badge/?version=latest
     :target: http://relstorage.readthedocs.io/en/latest/?badge=latest


.. _`installation instructions`: http://relstorage.readthedocs.io/en/latest/install.html
.. _`readthedocs`: http://relstorage.readthedocs.io/en/latest/
.. _`changelog`: http://relstorage.readthedocs.io/en/latest/changelog.html


=============
 Development
=============

RelStorage is hosted at GitHub:

    https://github.com/zodb/relstorage

Continuous integration
======================

A test suite is run for every push and pull request submitted. Travis
CI is used to test on Linux, and AppVeyor runs the builds on
Windows.

.. image:: https://travis-ci.org/zodb/relstorage.svg?branch=master
    :target: https://travis-ci.org/zodb/relstorage

.. image:: https://ci.appveyor.com/api/projects/status/pccddlgujdoqvl83?svg=true
   :target: https://ci.appveyor.com/project/jamadden/relstorage/branch/master

Builds on Travis CI automatically submit updates to `coveralls.io`_ to
monitor test coverage.

.. image:: https://coveralls.io/repos/zodb/relstorage/badge.svg?branch=master&service=github
   :target: https://coveralls.io/github/zodb/relstorage?branch=master

.. _coveralls.io: https://coveralls.io/github/zodb/relstorage


