Question 1

How to use databases with FastAPI for async database queries?

Accepted Answer

Integrate databases by creating a Database instance in FastAPI lifespan events and using await methods like database.fetch_all() in route handlers. The documentation provides examples with FastAPI for seamless async database access.

Question 2

Does databases support SQLAlchemy ORM or just Core?

Accepted Answer

Databases only supports SQLAlchemy Core, not the full ORM. You can build queries with Core expressions, but features like ORM models and relationships are not included, so for ORM functionality, you'd need sync SQLAlchemy or other libraries.

Question 3

What's the difference between databases and using asyncpg directly?

Accepted Answer

Databases provides a higher-level abstraction with SQLAlchemy Core integration, while asyncpg is a low-level driver. Databases is better for SQLAlchemy query building and framework compatibility, but asyncpg might offer more control and raw performance for specific SQL tasks.

Question 4

How to handle database migrations with databases and Alembic?

Accepted Answer

Since databases is async, for Alembic migrations which are synchronous, install synchronous drivers like psycopg2 and use a sync SQLAlchemy engine with Alembic, while keeping async operations in your app code with databases, as mentioned in the README.

Question 5

Is encode/databases suitable for large-scale production applications?

Accepted Answer

Yes, databases is used in production and supports features like connection pooling, but ensure you test performance with your workload and are comfortable with limitations like no ORM support. It's stable but requires async proficiency.

Question 6

Can I use databases with Django async?

Accepted Answer

Databases is framework agnostic and can be integrated, but Django's async support is evolving and has its own ORM. Using databases might require custom integration and not leverage Django's built-in async features directly.

Databases

What is Databases?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions