SQLModel is a library that lets you interact with databases through Python code with Python objects and type annotations instead of writing direct SQL queries. Created by the same author of the extremely popular framework FastAPI, it aims to make interacting with SQL DBs in Python easier and elegant, with data validation and IDE support,… Continue reading From SQL to SQLModel: A Cleaner Way to Work with Databases in Python
Articles on SQLModel
What is the Repository Pattern and How to Use it in Python?
By Bob Belderbos on 20 June 2024
The repository pattern is a design pattern that helps you separate business logic from data access code. It does so by providing a unified interface for interacting with different data sources, bringing the following advantages to your system: A practical example Let’s use Python and sqlmodel (PyPI) to demonstrate this pattern (code here): Note: In this implementation,… Continue reading What is the Repository Pattern and How to Use it in Python?
Using Python (and FastAPI) to support PFAS research
By PyBites Team on 14 July 2023
In this podcast episode, Robert Young, the director of an analytical chemistry lab at New Mexico State University, shares his unique journey from being a lawyer to becoming a chemist and a Python programmer. Watch here: Or listen here: He explains how his passion for environmental causes led him to study chemical analysis and mass… Continue reading Using Python (and FastAPI) to support PFAS research
My experience building a FastAPI + Streamlit app
By Chris Sato on 13 February 2023
I recently finished my time in the PDM program with Bob as my coach. This post focuses on how I made a back-end read-only database using FastAPI and a front-end using Streamlit along with the challenges that came with the whole project. Project Idea and initial planning This wasn’t my first attempt. I tried making… Continue reading My experience building a FastAPI + Streamlit app
Documentation-driven development with Sebastián Ramirez
By PyBites Team on 28 July 2022
Listen here: This week Bob and Pybites Coach, Robin Beer, interview Sebastián Ramirez, the creator of FastAPI, Typer and SQLModel. We talk about:– What he is currently working on.– How to balance the large amount of opportunities in his space (open source developer productivity tips).– The process of designing new libraries that are the glue between other ones.– The feeling of… Continue reading Documentation-driven development with Sebastián Ramirez