November 20, 2018 by
Mike 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 […]
December 12, 2017 by
Mike Last time we learned how to get Flask set up. In this article we will learn how to add a database to our music data website. As you might recall, Flask is a micro-web-framework. That means it doesn't come with an Object Relational Mapper (ORM) like Django does. If you want to add database interactivity, […]
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 […]
I was recently contacted about whether or not there were any wxPython applications out here that could present a SQLite database. As I understood it, they wanted to be able to introspect the database and view the tables, probably using the wx.grid.Grid widget. I find the Grid widget to be very powerful and also rather […]
November 30, 2011 by
Mike 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 […]
November 10, 2011 by
Mike In this article, we will be creating a program to store our personal books or perhaps just the books you've read. It will demonstrate how to combine wxPython and SqlAlchemy, a SQL Object Relational Mapper (ORM). This program will also give you an introduction to the model-view-controller (MVC) and "create, read, update and destroy" (CRUD) […]
