.. image:: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/workflows/Tests/badge.svg
:target: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/actions?workflow=Tests
.. image:: https://codecov.io/gh/pyveci/sqlalchemy-postgresql-relaxed/branch/main/graph/badge.svg
:target: https://codecov.io/gh/pyveci/sqlalchemy-postgresql-relaxed
:alt: Test suite code coverage
.. image:: https://pepy.tech/badge/sqlalchemy-postgresql-relaxed/month
:target: https://pepy.tech/project/sqlalchemy-postgresql-relaxed
.. image:: https://img.shields.io/pypi/v/sqlalchemy-postgresql-relaxed.svg
:target: https://pypi.org/project/sqlalchemy-postgresql-relaxed/
.. image:: https://img.shields.io/pypi/status/sqlalchemy-postgresql-relaxed.svg
:target: https://pypi.org/project/sqlalchemy-postgresql-relaxed/
.. image:: https://img.shields.io/pypi/pyversions/sqlalchemy-postgresql-relaxed.svg
:target: https://pypi.org/project/sqlalchemy-postgresql-relaxed/
.. image:: https://img.shields.io/pypi/l/sqlalchemy-postgresql-relaxed.svg
:target: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/LICENSE
|
##########################################
Relaxed PostgreSQL dialects for SQLAlchemy
##########################################
*****
About
*****
The vanilla dialects for connecting to PostgreSQL with SQLAlchemy will employ
a few behaviors that strictly expect a PostgreSQL server on the other end.
However, some operations may croak on databases which only offer
wire-compatibility with PostgreSQL.
The dialects provided by ``sqlalchemy-postgresql-relaxed`` are building upon
the vanilla SQLAlchemy dialects, but will disable a few PostgreSQL specifics.
- ``postgresql+psycopg``: Accept non-conforming server version responses.
- ``postgresql+psycopg``: Don't issue ``SHOW STANDARD_CONFORMING_STRINGS`` inquiry.
- ``postgresql+asyncpg``: Don't strictly expect JSON and JSONB codecs.
*****
Usage
*****
The corresponding dialect identifiers are:
- ``postgresql+psycopg_relaxed``
- ``postgresql+asyncpg_relaxed``
They can be used within SQLAlchemy database URL identifiers as usual.
.. code-block:: python
# psycopg synchronous
create_engine(
url="postgresql+psycopg_relaxed://crate@localhost/acme",
isolation_level="AUTOCOMMIT",
use_native_hstore=False)
# psycopg asynchronous
create_async_engine(
url="postgresql+psycopg_relaxed://crate@localhost/acme",
isolation_level="AUTOCOMMIT",
use_native_hstore=False)
# asyncpg
create_async_engine(
url="postgresql+asyncpg_relaxed://crate@localhost/acme",
isolation_level="AUTOCOMMIT")
*****
Setup
*****
::
pip install --upgrade sqlalchemy-postgresql-relaxed
To install the latest development version from the repository, invoke::
pip install --upgrade git+https://github.com/pyveci/sqlalchemy-postgresql-relaxed
*******************
Project information
*******************
Contributions
=============
Every kind of contribution, feedback, or patch, is much welcome. `Create an
issue`_ or submit a patch if you think we should include a new feature, or to
report or fix a bug.
Development
===========
In order to setup a development environment on your workstation, please head over
to the `development sandbox`_ documentation. When you see the software tests succeed,
you should be ready to start hacking.
Resources
=========
- `Source code repository <https://github.com/pyveci/sqlalchemy-postgresql-relaxed>`_
- `Documentation <https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/README.rst>`_
- `Python Package Index (PyPI) <https://pypi.org/project/sqlalchemy-postgresql-relaxed/>`_
License and warranty
====================
The project is licensed under the terms of the MIT license, see `LICENSE`_.
.. _Create an issue: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/issues/new
.. _development sandbox: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/DEVELOP.rst
.. _LICENSE: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/LICENSE
Raw data
{
"_id": null,
"home_page": "",
"name": "sqlalchemy-postgresql-relaxed",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "dialect,postgresql,sqlalchemy",
"author": "",
"author_email": "Andreas Motl <andreas.motl@panodata.org>",
"download_url": "https://files.pythonhosted.org/packages/f2/f8/a6a47a72bf900ee7c932dbfb550b56008511e3ac7659a6dc890d4a904c10/sqlalchemy-postgresql-relaxed-0.1.1.tar.gz",
"platform": null,
"description": ".. image:: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/workflows/Tests/badge.svg\n :target: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/actions?workflow=Tests\n\n.. image:: https://codecov.io/gh/pyveci/sqlalchemy-postgresql-relaxed/branch/main/graph/badge.svg\n :target: https://codecov.io/gh/pyveci/sqlalchemy-postgresql-relaxed\n :alt: Test suite code coverage\n\n.. image:: https://pepy.tech/badge/sqlalchemy-postgresql-relaxed/month\n :target: https://pepy.tech/project/sqlalchemy-postgresql-relaxed\n\n.. image:: https://img.shields.io/pypi/v/sqlalchemy-postgresql-relaxed.svg\n :target: https://pypi.org/project/sqlalchemy-postgresql-relaxed/\n\n.. image:: https://img.shields.io/pypi/status/sqlalchemy-postgresql-relaxed.svg\n :target: https://pypi.org/project/sqlalchemy-postgresql-relaxed/\n\n.. image:: https://img.shields.io/pypi/pyversions/sqlalchemy-postgresql-relaxed.svg\n :target: https://pypi.org/project/sqlalchemy-postgresql-relaxed/\n\n.. image:: https://img.shields.io/pypi/l/sqlalchemy-postgresql-relaxed.svg\n :target: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/LICENSE\n\n|\n\n##########################################\nRelaxed PostgreSQL dialects for SQLAlchemy\n##########################################\n\n\n*****\nAbout\n*****\n\nThe vanilla dialects for connecting to PostgreSQL with SQLAlchemy will employ\na few behaviors that strictly expect a PostgreSQL server on the other end.\nHowever, some operations may croak on databases which only offer\nwire-compatibility with PostgreSQL.\n\nThe dialects provided by ``sqlalchemy-postgresql-relaxed`` are building upon\nthe vanilla SQLAlchemy dialects, but will disable a few PostgreSQL specifics.\n\n- ``postgresql+psycopg``: Accept non-conforming server version responses.\n- ``postgresql+psycopg``: Don't issue ``SHOW STANDARD_CONFORMING_STRINGS`` inquiry.\n- ``postgresql+asyncpg``: Don't strictly expect JSON and JSONB codecs.\n\n\n*****\nUsage\n*****\n\nThe corresponding dialect identifiers are:\n\n- ``postgresql+psycopg_relaxed``\n- ``postgresql+asyncpg_relaxed``\n\nThey can be used within SQLAlchemy database URL identifiers as usual.\n\n.. code-block:: python\n\n # psycopg synchronous\n create_engine(\n url=\"postgresql+psycopg_relaxed://crate@localhost/acme\",\n isolation_level=\"AUTOCOMMIT\",\n use_native_hstore=False)\n\n # psycopg asynchronous\n create_async_engine(\n url=\"postgresql+psycopg_relaxed://crate@localhost/acme\",\n isolation_level=\"AUTOCOMMIT\",\n use_native_hstore=False)\n\n # asyncpg\n create_async_engine(\n url=\"postgresql+asyncpg_relaxed://crate@localhost/acme\",\n isolation_level=\"AUTOCOMMIT\")\n\n\n*****\nSetup\n*****\n::\n\n pip install --upgrade sqlalchemy-postgresql-relaxed\n\nTo install the latest development version from the repository, invoke::\n\n pip install --upgrade git+https://github.com/pyveci/sqlalchemy-postgresql-relaxed\n\n\n*******************\nProject information\n*******************\n\nContributions\n=============\n\nEvery kind of contribution, feedback, or patch, is much welcome. `Create an\nissue`_ or submit a patch if you think we should include a new feature, or to\nreport or fix a bug.\n\nDevelopment\n===========\n\nIn order to setup a development environment on your workstation, please head over\nto the `development sandbox`_ documentation. When you see the software tests succeed,\nyou should be ready to start hacking.\n\nResources\n=========\n\n- `Source code repository <https://github.com/pyveci/sqlalchemy-postgresql-relaxed>`_\n- `Documentation <https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/README.rst>`_\n- `Python Package Index (PyPI) <https://pypi.org/project/sqlalchemy-postgresql-relaxed/>`_\n\nLicense and warranty\n====================\n\nThe project is licensed under the terms of the MIT license, see `LICENSE`_.\n\n\n.. _Create an issue: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/issues/new\n.. _development sandbox: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/DEVELOP.rst\n.. _LICENSE: https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/LICENSE\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Relaxed PostgreSQL dialects for SQLAlchemy",
"version": "0.1.1",
"project_urls": {
"changelog": "https://github.com/pyveci/sqlalchemy-postgresql-relaxed/blob/main/CHANGES.rst",
"documentation": "https://github.com/pyveci/sqlalchemy-postgresql-relaxed",
"homepage": "https://github.com/pyveci/sqlalchemy-postgresql-relaxed",
"repository": "https://github.com/pyveci/sqlalchemy-postgresql-relaxed"
},
"split_keywords": [
"dialect",
"postgresql",
"sqlalchemy"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "2e8e80439fa7fd6b1d743d09b132cfde8e7cd26f1540e52bec39b04d3871e0d3",
"md5": "2294e2956db559c7d7b93f1524ef799a",
"sha256": "9dcc15dbfe67d36e1924934a012ad1ca6025a5e861e1eab3316c78ad1ee6a2ff"
},
"downloads": -1,
"filename": "sqlalchemy_postgresql_relaxed-0.1.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "2294e2956db559c7d7b93f1524ef799a",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 6633,
"upload_time": "2023-12-22T20:34:08",
"upload_time_iso_8601": "2023-12-22T20:34:08.912629Z",
"url": "https://files.pythonhosted.org/packages/2e/8e/80439fa7fd6b1d743d09b132cfde8e7cd26f1540e52bec39b04d3871e0d3/sqlalchemy_postgresql_relaxed-0.1.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "f2f8a6a47a72bf900ee7c932dbfb550b56008511e3ac7659a6dc890d4a904c10",
"md5": "ecd90062448fb426e4accf9edc0bd6d2",
"sha256": "e553c022fcddada45b433373544e0ca658fae7d8efcbda7b3763281143b31a51"
},
"downloads": -1,
"filename": "sqlalchemy-postgresql-relaxed-0.1.1.tar.gz",
"has_sig": false,
"md5_digest": "ecd90062448fb426e4accf9edc0bd6d2",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 7075,
"upload_time": "2023-12-22T20:34:10",
"upload_time_iso_8601": "2023-12-22T20:34:10.792280Z",
"url": "https://files.pythonhosted.org/packages/f2/f8/a6a47a72bf900ee7c932dbfb550b56008511e3ac7659a6dc890d4a904c10/sqlalchemy-postgresql-relaxed-0.1.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-12-22 20:34:10",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "pyveci",
"github_project": "sqlalchemy-postgresql-relaxed",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "sqlalchemy-postgresql-relaxed"
}
JSON
