SQLAlchemy – Python’s Database Toolkit

Abstract

With the vast amount of data that can be collected and utilized from today’s various business operations and activities, having the ability to efficiently store and manage data effectively is essential in improving data access, data security, decision making, and overall productivity. With the database language SQL, we gained the ability to transform raw data into useful information and provided end users a means of developing manageable information systems. Along with the introduction of SQLAlchemy, we are introduced to a system that provides a consistent interface between the dozens of relational database management systems that use SQL. The purpose of this project is to describe the benefits in using SQLAlchemy and displaying SQLAlchemy’s ability to create and manipulate databases through Pythonic code.