databases

SqlAlchemy and Microsoft Access

4 Comments / Python, SqlAlchemy, Windows / / / , , ,

Update (10/12/2010) – One of my alert readers told me that SqlAlchemy 0.6.x currently does NOT support the Access dialect. Read here for more info. A year or two ago, I was asked to transfer some data from some old Microsoft Access files to our Microsoft SQL Server. Since I enjoy using SqlAlchemy, I decided […]

SqlAlchemy and Microsoft Access Read More »

SqlAlchemy: Connecting to pre-existing databases

1 Comment / Cross-Platform, Python, SqlAlchemy / / / , , ,

Accessing databases with Python is a simple process. Python even provides a sqlite database library that’s built into the main distribution (since 2.5). My favorite way to access databases with Python is to use the 3rd party package, SqlAlchemy. SqlAlchemy is an object-relational mapper (ORM), which means that it takes SQL constructs and makes them

SqlAlchemy: Connecting to pre-existing databases Read More »