Working with PostgreSQL in Python

Introduction PostgreSQL is one of the most advanced and widely used relational database management systems. It’s extremely popular for many reasons, a few of which include it being open source, its extensibility, and its ability to handle many different types of applications and varying loads. With Python, you can easily establish a connection to your PostgreSQL database. There are many Python drivers for PostgreSQL, with “psycopg” being the most popular one. Its current version is psycopg2. In this article, we’ll […]

Using SQLAlchemy with Flask and PostgreSQL

Introduction Databases are a crucial part of modern applications since they store the data used to power them. Generally, we use the Structured Query Language (SQL) to perform queries on the database and manipulate the data inside of it. Though initially done via dedicated SQL tools, we’ve quickly moved to using SQL from within applications to perform queries. Naturally, as time passed, Object Relational Mappers (ORMs) came to be – which enable us to safely, easily and conveniently connect to […]