databases
databases copied to clipboard
encode
Async database support for Python. 🗄
Current implementation has different class for each Row/Record/RowProxy. Any chance a common interface can be used / monkey patched into each of these so they behave more similarly. Something as...
Hi, I have been this library intensively for a project that I am working on. Initially we are using postgres but had to switch to Sql Server. Will there be...
I am doing an insert into two tables using CTE and Returning. In sqlalchemy core: ``` obj_to_insert = {'a': 4, 'b': 22} q = db.event.insert( ).values( event_type="blah" ).returning( db.event.c.id )...
See #198, #204 When a release is made, the {release} placeholder in the docs needs updating.
I am playing around with this project (making a wrapper around it) and came across an odd behavior. Using the example on the README: The following two queries do not...
slqlalchemy supports `"*"` as a returning value, however when I'm using it with postgres backend ```python row = await db.fetch_one(table.insert().values(**values).returning(literal_column('*'))) ``` and then try to get row data `KeyError` shows...
# Scrambled data in simultaneous SQL requests _*The following has been anonymized*_ in our **sanic** app we have the following three pieces of db logic. All of them are wrapped...
Minimal reproduce script with comments ```python import asyncio import databases import sqlalchemy as sa # import logging # logging.basicConfig(level=logging.DEBUG) DB_URL = "sqlite:////tmp/test.db" metadata = sa.MetaData() table = sa.Table( "t1", metadata,...
I would like to be able to monitor database queries via [opentracing](https://opentracing.io/). This is relatively straightforward to do with SQLAlchemy which provides events one can listen and react to, when...
Currently we support 4 back-end: - postgres with asyncpg - postgres with aiopg - mysql with aiomysql - sqlite with aoisqlite There's an open PR for MSSQL that utilizes `aioodbc`,...
