Posts tagged with "SQLAlchemy"

SQLAlchemy is a library that provides access to SQL databases from Python through a unified interface.

The library contains a powerful Object Relational Mapper (ORM) and a variety of tools for dealing with raw SQL which it refers to as "Core".

This toolkit is a powerful way to specify SQL from your Python code as it has compatibility with many SQL dialects and implementations.

1 Post

Enforcing foreign key constraints with SQLite

There was a perplexing issue we ran into when testing the Persephone web API. There was a foreign key constraint specified in SQLAlchemy but you could add in new entries with bogus foreign keys without the DB engine raising an . Why did this happen?

Published on May 7th, 2018 by Janis Lesinskis.