SQLAlchemy ORM Examples

ORM Recap In one of the previous articles, we briefly went through an example database with two tables department and employee where one department can have multiple employees and one employee can belong to arbitrary number of departments. We used several code snippets to demonstrate the power of SQLAlchemy’s expression language and show how to […]

Read More

SQLAlchemy – Some Commonly Asked Questions

Common Questions Before we dive deeper into SQLAlchemy, let’s answer a possible list of questions regarding the ORM: Can you prevent SQLAlchemy from automatically creating a schema? Instead, can you bind SQLAlchemy models to an existing schema? Is there a performance overhead when using SQLAlchemy, compared to writing raw SQL? If so, how much? If […]

Read More

Overview of SQLAlchemy’s Expression Language and ORM Queries

Overview In the previous article, we made a comparison between SQLAlchemy and other Python ORMs. In this article, we are going to take a deeper look at SQLAlchemy’s ORM and Expression Language and use an example to showcase their empowering API and easy-to-understand Python structures. Not only does the SQLAlchemy ORM provide a way to […]

Read More

SQLAlchemy vs Other ORMs

Overview of Python ORMs As a wonderful language, Python has lots of ORM libraries besides SQLAlchemy. In this article, we are going to take a look at several popular alternative ORM libraries to better understand the big picture of the Python ORM landscape. By writing a script that reads and writes to a simple database […]

Read More

Python’s Django vs Ruby on Rails

Python vs Ruby Ruby is a dynamic, reflective, object-oriented general-purpose programming language which was designed and developed in the mid-1990s. Compared to Python, which treats code readability above everything else, the philosophy behind Ruby is that programmers should have the flexibility, freedom and power to write concise and compact code. The most important difference between […]

Read More

How to Install Django on Windows, Mac and Linux

In this article, we are going to learn how to install Django on Windows, Mac and Linux. Since Mac and Linux are both derived from the Unix platform, the instructions about installing Django on Mac and Linux are almost identical to each other and we will present them in the same section. Windows, however, is […]

Read More

Python for Android: Android’s Native Dialogs (SL4A)

Android has a range of built-in dialogs that allow apps to interact with users. They can be used to display things like spinners and progress bars, and can be used to prompt the user for some kind of input, like a date or string. All of the methods for creating dialogs live in SL4A’s UI […]

Read More

Using Python Django’s ModelForm in Your First Django Application

Django’s ModelForm In our previous article, How to Use Python Django Forms, we learned how to create Django form objects and use them inside templates for common tasks such as data validation and HTML generation. In this article, we are going to learn how to use Django’s ModelForm to create forms directly from models. Compared […]

Read More

How to Use Python Django Forms

Django Form What is a HTML form? What kind of use cases does it have? A webform, web form or HTML form on a web page allows a user to enter data that is sent to a server for processing. Forms can resemble paper or database forms because web users fill out the forms using […]

Read More

Package Your Python Django Application into a Reusable Component

Save Time by Writing and Using Reusable Python Django Apps It’s not trivial to design, develop and maintain a web application. Lots of features and aspects have to be handled properly in order for a web application to succeed. To name a few, the features that are common to almost every web application are user […]

Read More