databases
databases copied to clipboard
encode
Async database support for Python. 🗄
The `__getitem__` function does extra deserialisation that's not happening in __getattr__. As an example referencing a JSONB field with __getitem__ gets you a `dict` whereas `__getattr__` results in a `str`....
### Example Code ```python import asyncio from sqlx_engine import SQLXEngine uri = "file:./db.db" db = SQLXEngine(provider="sqlite", uri=uri) async def main(): await db.connect() rows = await db.query(query="select 1 as number") print(rows)...
* Preparing release 0.9.0 version and changelog. @encode/maintainers let me know if this is enough.
Will there be support for SQLAlchemy 2.0 or I should just use it directly?
By defining the index on the columns and as a unique key, the table is created with the CreateTable function, but the keys are not. ```py users = Table( 'users',...
Hi, Databases return `Record` class instance, and we can get column values by simply specifying column name ``` record = db.fetch_one(query=query, values=values) print(record.id) ``` mypy gives the following error: `Mypy:...
Hey everyone. After deploying my [fastapi app](https://github.com/wiseaidev/fastapi-singlestore-backend) on `Deta` and/or on `Vercel`, I got an error complaining about `DatabaseBackend` not running. However, the `connect` method is being called during the...
I see the `await database.connect()` used but is that the equivalent to sqlalchemy's orm.sessionmaker? Do I just open a new connection every time up to the defined limit and `databases`...
I've `Product` model that has a `brand` attribute which is a ForeignKey to `Brand` model. There are data in the database serving for the appropriate relationship i.e i've products in...
OS: Windows 10 Python: 3.11 databases version: 0.8.0 database backend: postgresql database driver: asyncpg Issue stacktrace: `D:\project-management-service\API\env\Scripts\python.exe -m uvicorn main:app --reload INFO: Will watch for changes in these directories: ['D:\\project-management-service\\API']...
