SqlAlchemy

An article including information about SQLAlchemy, a popular Python Object Relational Mapper (ORM)

Python 101: Episode #34 – The SQLAlchemy Package

In this screencast, we learn about the popular SQLAlchemy package. SQLAlchemy is an Object Relational Mapper for Python that allows you to interface with databases in a “Pythonic” manner. You can also read the chapter this video is based on here or get the book on Leanpub Note: This video was recorded a couple of …

Python 101: Episode #34 – The SQLAlchemy Package Read More »

A Simple SqlAlchemy 0.7 / 0.8 Tutorial

A couple years ago I wrote a rather flawed tutorial about SQLAlchemy. I decided it was about time for me to re-do that tutorial from scratch and hopefully do a better job of it this time around. Since I’m a music nut, we’ll be creating a simple database to store album information. A database isn’t …

A Simple SqlAlchemy 0.7 / 0.8 Tutorial Read More »

Improving MediaLocker: wxPython, SQLAlchemy, and MVC

This blog ran an article about wxPython, SQLAlchemy, CRUD and MVC earlier this month. The program that we created in that post was dubbed “MediaLocker”, whether or not it was explicitly stated as such. Anyway, since then, I have received a couple comments about improving the program. One came from Michael Bayer, one of the …

Improving MediaLocker: wxPython, SQLAlchemy, and MVC Read More »

SqlAlchemy ProgrammingError 42000 and MS SQL

I have been working on a software inventory script lately using SqlAlchemy on Windows XP to connect to a newly created table in a Microsoft SQL Server 2005 database. I created the table using Aqua Data Studio, logging in as the SQL Administrator (sa) and thought all was well until I tried to commit some …

SqlAlchemy ProgrammingError 42000 and MS SQL Read More »

Top Ten Articles of 2010

A lot of websites are doing year-end retrospectives this week, so I thought you might find it interesting to know which articles on this blog were the most popular this year. Below you will find links to each article along with the page view count I got from Google Analytics: A Simple Step-by-Step Reportlab Tutorial, …

Top Ten Articles of 2010 Read More »

SqlAlchemy and Microsoft Access

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 »