SQLAlchemy – Dialects SQLAlchemy uses system of dialects to communicate with various types of databases. Each database has a corresponding DBAPI wrapper. All dialects require that an appropriate DBAPI driver is installed. Following dialects are included in SQLAlchemy API − Firebird Microsoft SQL Server MySQL Oracle PostgreSQL SQL Sybase An Engine object based on a […]
Category Archives: sqlalchemy
Many to Many Relationships Many to Many relationship between two tables is achieved by adding an association table such that it has two foreign keys – one from each table’s primary key. Moreover, classes mapping to the two tables have an attribute with a collection of objects of other association tables assigned as secondary attribute […]
SQLAlchemy – Quick Guide SQLAlchemy – Introduction SQLAlchemy is a popular SQL toolkit and Object Relational Mapper. It is written in Python and gives full power and flexibility of SQL to an application developer. It is an open source and cross-platform software released under MIT license. SQLAlchemy is famous for its object-relational mapper (ORM), using […]