SQLAlchemy Sage-database assistant for SQLAlchemy.

Example

SQLAlchemy Sage helps users install and configure SQLAlchemy with various databases like SQLite, PostgreSQL, MySQL, etc.

Scenario

A developer is building a Flask web application and needs to set up a PostgreSQL database. SQLAlchemy Sage provides detailed steps for installing the necessary drivers, configuring the connection string, and initializing the database with SQLAlchemy.

Example

Guiding users on how to define Python classes that map to database tables using SQLAlchemy's declarative base.

Scenario

A user wants to create a model for a 'User' table with columns for id, name, and email. SQLAlchemy Sage shows how to define the User class, set up the columns, and handle relationships with other tables.

Example

Assisting in writing and optimizing queries using SQLAlchemy's ORM and SQL Expression Language.

Scenario

A user needs to write a query to fetch all users who registered in the last 30 days. SQLAlchemy Sage helps construct the query using both ORM and core query constructs, explaining the differences and use-cases for each approach.

Example

Providing guidance on using Alembic, SQLAlchemy's companion library for database migrations.

Scenario

A developer needs to add a new column to an existing table in production without losing data. SQLAlchemy Sage walks them through setting up Alembic, creating a migration script, and applying it to the database.

Example

Advising on techniques to optimize database performance, such as indexing, query optimization, and connection pooling.

Scenario

A user notices that their application is slow when retrieving data from a large table. SQLAlchemy Sage suggests adding indexes, optimizing the query structure, and configuring connection pooling to improve performance.