Object Relational Mapper
In bioinformatics, we are familiar with Python and SQL. Python is a general coding language used to problem solve and create programs. SQL is a specific language used to store and retrieve specific information from databases. Then you have SQLAlchemy which is the bridge between both languages. This presents a method to use Python to create databases and facilitates the communication between Python programs and the databases.
Object Relational Mapper (ORM) tool translates Python classes to tables on relational databases and automatically converts function calls to SQL statements.
draft
References
-
SQLAlchemy overview: Philipp Luong University of Hawai course
-
Adam Lambert, Fundamentals of Python: First Programs | 2nd Edition, 2019
-
Carlos Coronel and Steven Morris, Database Systems: Design, Implementation, & Management | 13th Edition, JAN 2018
-
SQLAlchemy authors and contributors, https://www.sqlalchemy.org/
-
Xiaonuo Gantan, https://www.pythoncentral.io/introductory-tutorial-python-sqlalchemy/, APR 2013
Relevant Tags
About the Author
Latest Articles
-
Research Tax Credit
The Research Activities Tax Credit is a tax credit that incentivizes private companies to increase their Research and Development (R&D). Within my company, I have been tasked with writing the Research Tax Credit (CIR) justification report for France. Here, the method for writing such a report.OCT 2025 · PIERRE-EDOUARD GUERIN -
Turing Complete: From Logical Gates to CPU Architecture
In 2021, LevelHead published Turing Complete, a game about computer science. My friend Christophe Georgescu recommended me to play it. Unfortunately, I took his advice and now I can not stop to play this game! The game challenges you to design an entire computer from scratch. You start with basic logic gates, then move on to components, memory, CPU architecture, and finally assembly programming. By the way, the game is neat and present all these concepts in a playful and intuitive way.SEP 2025 · PIERRE-EDOUARD GUERIN -
How to Manage a Project?
In any company, every task is part of a project. I am responsible for managing multiple projects each year. I have to present deliverables to stakeholders, meet deadlines, allocate mandays and coordinate everyone’s actions. This is a meticulous work that requires a strong methodology.JUN 2025 · PIERRE-EDOUARD GUERIN