# SQLAlchemy

Python SQL toolkit and object-relational mapper for database access.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Python REST APIs With Flask, Connexion, and SQLAlchemy - Part 2

DevFeed: [Python REST APIs With Flask, Connexion, and SQLAlchemy - Part 2](<https://devfeed.tech/articles/python-rest-apis-with-flask-connexion-and-sqlalchemy-part-2-99147.md>)

Original publisher: [Read original article](<https://realpython.com/flask-connexion-rest-api-part-2/>)

Author: Philipp Acsany

Published: 2026-10-25T14:00:00Z

Content type: tutorial

Language: en

Sources: [Real Python](<https://devfeed.tech/sources/real-python.md>)

Topics: [REST API](<https://devfeed.tech/topics/rest-api.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [Flask](<https://devfeed.tech/topics/flask.md>), [Python](<https://devfeed.tech/topics/python.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [Swagger](<https://devfeed.tech/topics/swagger.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [modules](<https://devfeed.tech/topics/modules.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [api-documentation](<https://devfeed.tech/tags/api-documentation.md>), [apis](<https://devfeed.tech/tags/apis.md>), [array](<https://devfeed.tech/tags/array.md>), [attack](<https://devfeed.tech/tags/attack.md>), [back-end](<https://devfeed.tech/tags/back-end.md>), [boolean](<https://devfeed.tech/tags/boolean.md>), [class](<https://devfeed.tech/tags/class.md>), [column](<https://devfeed.tech/tags/column.md>), [commit](<https://devfeed.tech/tags/commit.md>), [config](<https://devfeed.tech/tags/config.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [flask](<https://devfeed.tech/tags/flask.md>), [python](<https://devfeed.tech/tags/python.md>), [rest](<https://devfeed.tech/tags/rest.md>), [rest-api](<https://devfeed.tech/tags/rest-api.md>), [rest-apis](<https://devfeed.tech/tags/rest-apis.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>)

### AI overview

The tutorial replaces a Flask REST API's in-memory `PEOPLE` dictionary with a persistent SQLite database, while keeping the existing endpoints. It demonstrates direct `sqlite3` commands to create and query a `person` table, then explains how interpolating user input into SQL can enable injection attacks. It configures Flask-SQLAlchemy and models the table as a `Person` class with a unique last name, primary key, and UTC timestamps. Flask-Marshmallow schemas validate and convert between JSON and model objects. Updated handlers query, create, update, and delete database records; the home page reads from the database, and Swagger UI can exercise the API. The tutorial notes that SQLite stores the database in a single file and that data now persists across app restarts. The supplied text describes this second installment; adding related notes is reserved for part three.

### Source excerpt

Build a Flask REST API backed by a SQLite database. In part two of this series, you'll use SQLAlchemy and Marshmallow to persist and serialize data.

## Python REST APIs With Flask, Connexion, and SQLAlchemy - Part 3

DevFeed: [Python REST APIs With Flask, Connexion, and SQLAlchemy - Part 3](<https://devfeed.tech/articles/python-rest-apis-with-flask-connexion-and-sqlalchemy-part-3-99148.md>)

Original publisher: [Read original article](<https://realpython.com/flask-connexion-rest-api-part-3/>)

Author: Philipp Acsany

Published: 2026-10-25T14:00:00Z

Content type: tutorial

Language: en

Sources: [Real Python](<https://devfeed.tech/sources/real-python.md>)

Topics: [REST API](<https://devfeed.tech/topics/rest-api.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [Flask](<https://devfeed.tech/topics/flask.md>), [Python](<https://devfeed.tech/topics/python.md>), [Swagger](<https://devfeed.tech/topics/swagger.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [api-documentation](<https://devfeed.tech/tags/api-documentation.md>), [apis](<https://devfeed.tech/tags/apis.md>), [flask](<https://devfeed.tech/tags/flask.md>), [one-to-many](<https://devfeed.tech/tags/one-to-many.md>), [people](<https://devfeed.tech/tags/people.md>), [python](<https://devfeed.tech/tags/python.md>), [rest](<https://devfeed.tech/tags/rest.md>), [rest-api](<https://devfeed.tech/tags/rest-api.md>), [rest-apis](<https://devfeed.tech/tags/rest-apis.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>)

### AI overview

The tutorial extends a Flask REST API with notes linked to people through a SQLAlchemy one-to-many relationship. A `note` table stores each note's content, timestamp, and `person_id` foreign key, avoiding repeated person data; SQLAlchemy configures cascading note deletion and newest-first ordering. Marshmallow's `PersonSchema` includes a nested `NoteSchema` so people endpoints return full note objects, and the front end renders each person's notes. New API routes read, update, and delete notes by ID and create notes for an existing person; missing notes or owners produce 404 responses. The provided `build_database.py` script rebuilds `people.db` and seeds sample data, but drops existing database contents when run.

### Source excerpt

Extend your Flask REST API with a SQLAlchemy one-to-many relationship that adds notes to people, and serve them through new API endpoints.

## Python 3.15 Gets a Surprise RC3 and Other Python News for October 2026

DevFeed: [Python 3.15 Gets a Surprise RC3 and Other Python News for October 2026](<https://devfeed.tech/articles/python-3-15-gets-a-surprise-rc3-and-other-python-news-for-october-2026-64795.md>)

Original publisher: [Read original article](<https://realpython.com/python-news-october-2026/>)

Author: Bartosz Zaczyński

Published: 2026-10-05T14:00:00Z

Content type: news

Language: en

Sources: [Real Python](<https://devfeed.tech/sources/real-python.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [Wagtail](<https://devfeed.tech/topics/wagtail.md>)

Tags: [ai-apis](<https://devfeed.tech/tags/ai-apis.md>), [packaging](<https://devfeed.tech/tags/packaging.md>)

### AI overview

The October Python roundup reports that lazy-import bugs prompted Python 3.15 RC3 and delayed the final release to October 9. It covers the first Python Packaging Council, revised PyPI download counting, Polars 2.0 release candidates, SQLAlchemy 2.1 compatibility changes, and breaking AI API changes. Practical guidance includes testing encoding assumptions, checking dependency requirements, and isolating autonomous coding agents.

### Source excerpt

Python 3.15 gets a surprise RC3, the first Packaging Council is elected, Polars 2.0 and SQLAlchemy 2.1 arrive, and AI APIs break Python code again.

## SQLAlchemy 2.1 brings built-in support for mssql-python

DevFeed: [SQLAlchemy 2.1 brings built-in support for mssql-python](<https://devfeed.tech/articles/sqlalchemy-2-1-brings-built-in-support-for-mssql-python-61032.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/sqlalchemy-2-1-brings-built-in-support-for-mssql-python/>)

Author: Matt Hyon, David Levy

Published: 2026-09-28T16:02:00Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [Python Driver for SQL Server](<https://devfeed.tech/topics/python-driver-for-sql-server.md>), [Python Driver for Azure SQL](<https://devfeed.tech/topics/python-driver-for-azure-sql.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [drivers](<https://devfeed.tech/tags/drivers.md>), [python](<https://devfeed.tech/tags/python.md>), [python-driver-for-sql-server](<https://devfeed.tech/tags/python-driver-for-sql-server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>)

### AI overview

SQLAlchemy 2.1 is generally available with a built-in first-party dialect for Microsoft's mssql-python driver. It supports SQL Server and Azure SQL through SQLAlchemy's ORM and Core APIs, with simpler driver setup, Microsoft Entra authentication options, and continued use of Alembic for schema migrations.

### Source excerpt

We're pleased to share that SQLAlchemy 2.1.0 is now generally available, with built-in support for mssql-python, Microsoft's Python driver for SQL Server. You can now use it with SQLAlchemy's ORM and Core APIs through the first-party mssql+mssqlpython dialect. If SQLAlchemy is already part of how you build, we want this to feel like a natural [...] The post SQLAlchemy 2.1 brings built-in support for mssql-python appeared first on Azure SQL Dev Corner.

## Write End-to-End Tests in Your Backend's Language

DevFeed: [Write End-to-End Tests in Your Backend's Language](<https://devfeed.tech/articles/write-end-to-end-tests-in-your-backend-s-language-41361.md>)

Original publisher: [Read original article](<https://spin.atomicobject.com/write-end-to-end-tests-in-your-backends-language/>)

Author: James McConkey

Published: 2026-09-17T12:00:42Z

Content type: tutorial

Language: en

Sources: [Atomic Object](<https://devfeed.tech/sources/atomic-object.md>)

Topics: [Software Testing](<https://devfeed.tech/topics/software-testing.md>), [Playwright](<https://devfeed.tech/topics/playwright.md>), [FastAPI](<https://devfeed.tech/topics/fastapi.md>), [Python](<https://devfeed.tech/topics/python.md>), [test data](<https://devfeed.tech/topics/test-data.md>), [Pydantic](<https://devfeed.tech/topics/pydantic.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [ASP.NET Core](<https://devfeed.tech/topics/asp-net-core.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Docker Compose](<https://devfeed.tech/topics/docker-compose.md>)

Tags: [asp-net-core](<https://devfeed.tech/tags/asp-net-core.md>), [code](<https://devfeed.tech/tags/code.md>), [data](<https://devfeed.tech/tags/data.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [exploratory-testing](<https://devfeed.tech/tags/exploratory-testing.md>), [fastapi](<https://devfeed.tech/tags/fastapi.md>), [playwright](<https://devfeed.tech/tags/playwright.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [project-team-management](<https://devfeed.tech/tags/project-team-management.md>), [python](<https://devfeed.tech/tags/python.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>), [testing](<https://devfeed.tech/tags/testing.md>), [tests](<https://devfeed.tech/tags/tests.md>), [the-software-life](<https://devfeed.tech/tags/the-software-life.md>)

### AI overview

This article argues that end-to-end test-data setup is often the main design challenge, because tests must create consistent domain records while running alongside other tests. It recommends using browser-testing tools in the backend's language when possible, keeping meaningful relationships inline, and extracting small creation helpers without hiding scenario intent.

### Source excerpt

The browser is often the easiest part of an end-to-end test. Consider a test that verifies a user can complete an overdue task. The visible interaction is small: sign in, find the task, click Complete, and observe the new status. Before any of that can happen, the test needs a workspace, a user, a project, and [...] The post Write End-to-End Tests in Your Backend's Language appeared first on Atomic Spin.

## Looking at How Replit Agent Handles Databases

DevFeed: [Looking at How Replit Agent Handles Databases](<https://devfeed.tech/articles/looking-at-how-replit-agent-handles-databases-5516.md>)

Original publisher: [Read original article](<https://neon.com/blog/looking-at-how-replit-agent-handles-databases>)

Author: Sam Harrison

Published: 2024-11-08T17:59:23Z

Content type: article

Language: en

Sources: [Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Repl.it](<https://devfeed.tech/topics/replit.md>), [Database](<https://devfeed.tech/topics/database.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [Object-relational mapping](<https://devfeed.tech/topics/orm.md>), [Flask](<https://devfeed.tech/topics/flask.md>), [Python](<https://devfeed.tech/topics/python.md>), [Web app](<https://devfeed.tech/topics/webapp.md>), [API](<https://devfeed.tech/topics/api.md>), [Front end](<https://devfeed.tech/topics/frontend.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [ai](<https://devfeed.tech/tags/ai.md>), [api](<https://devfeed.tech/tags/api.md>), [applications](<https://devfeed.tech/tags/applications.md>), [code](<https://devfeed.tech/tags/code.md>), [database-migration](<https://devfeed.tech/tags/database-migration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [development](<https://devfeed.tech/tags/development.md>), [flask](<https://devfeed.tech/tags/flask.md>), [frontend](<https://devfeed.tech/tags/frontend.md>), [html](<https://devfeed.tech/tags/html.md>), [javascript](<https://devfeed.tech/tags/javascript.md>), [orm](<https://devfeed.tech/tags/orm.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [product](<https://devfeed.tech/tags/product.md>), [python](<https://devfeed.tech/tags/python.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>), [web](<https://devfeed.tech/tags/web.md>), [web-applications](<https://devfeed.tech/tags/web-applications.md>)

### AI overview

This article examines how Replit Agent uses natural-language prompts and AI to build and evolve a full-stack TODO application. It focuses on coordinating Flask, SQLAlchemy, Alembic migrations, and a managed Neon PostgreSQL database while updating the API, schema, and frontend together.

### Source excerpt

Replit Agent is a powerful tool within the Replit development environment that allows you to offload coding tasks using natural language and AI. By interacting with the Replit Agent, you can generate code, create applications, and modify existing features simply by asking for wha...

## Announcing: REST API Source toolkit from dltHub - A Python-only high level approach to pipelines

DevFeed: [Announcing: REST API Source toolkit from dltHub - A Python-only high level approach to pipelines](<https://devfeed.tech/articles/announcing-rest-api-source-toolkit-from-dlthub-a-python-only-high-level-approach-to-pipelines-80385.md>)

Original publisher: [Read original article](<https://dlthub.com/blog/rest-api-source-client>)

Author: Adrian Brudaru

Published: 2024-05-14T00:00:00Z

Content type: release

Language: en

Sources: [DLT Hub](<https://devfeed.tech/sources/dlt-hub.md>)

Topics: [REST API](<https://devfeed.tech/topics/rest-api.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [pipelines](<https://devfeed.tech/tags/pipelines.md>), [python](<https://devfeed.tech/tags/python.md>), [rest](<https://devfeed.tech/tags/rest.md>), [tutorials](<https://devfeed.tech/tags/tutorials.md>), [updates](<https://devfeed.tech/tags/updates.md>)

### AI overview

dltHub introduces a Python REST API Source and Client for building data pipelines. The Source uses declarative configuration to define API integrations, while the Client provides imperative Python helpers, including pagination support. The article walks through configuring authentication, pagination, incremental loading, and dependent requests with GitHub API examples.

### Source excerpt

## What is the REST API Source toolkit? You are probably familiar with REST APIs. - Our new **REST API Source** is a short, declarative configuration-driven way of creating sources. - Our new **REST API Client** is a collection of Python helpers used by the above source, which you can also use as a standalone, config-free, imperative high-level abstraction for building pipelines. Want to skip to docs? Links are at the bottom of the post. ### Why REST configuration pipeline?

## Trino charms Python

DevFeed: [Trino charms Python](<https://devfeed.tech/articles/trino-charms-python-8687.md>)

Original publisher: [Read original article](<https://trino.io/blog/2022/09/20/python-progress.html>)

Author: Manfred Moser, Brian Zhan, Dain Sundstrom

Published: 2022-09-20T00:00:00Z

Content type: opinion

Language: en

Sources: [Trino](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [airflow](<https://devfeed.tech/topics/airflow.md>), [SDK](<https://devfeed.tech/topics/sdk.md>), [data-processing](<https://devfeed.tech/topics/data-processing.md>)

Tags: [airflow](<https://devfeed.tech/tags/airflow.md>), [python](<https://devfeed.tech/tags/python.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>), [tooling](<https://devfeed.tech/tags/tooling.md>), [tools-and-integrations](<https://devfeed.tech/tags/tools-and-integrations.md>)

### AI overview

The article reviews the growth of Python support around Trino, highlighting the trino-python-client, SQLAlchemy, dbt-trino, Apache Airflow, Apache Superset, Airbyte, notebooks, and related integrations. It invites users to share additional use cases and problems to help improve the ecosystem.

### Source excerpt

Wow, have we ever come a long way with Python support for Trino. It feels like ages ago that we talked about DB-API, trino-python-client, SQLAlchemy, Apache Superset, and more in Trino Community Broadcast episode 12. More recently we talked about dbt in episode 21 and episode 30, but there is so much more for Pythonistas, Pythonians, Python programmers, and simply users of Python-powered tools.