About SQLModel¶

As the website of SQLModel mentions:

How and why do we use SQLModel¶

SQLModel is used to create a simple and robust ORM for SQL databases. It is used to create models and interact with the database. It is a framework based on Pydantic and SQLAlchemy.

Install SQLModel¶

SQLModel can be installed using pip:

1

pip install sqlmodel

Configuration¶

The configuration of SQLModel is done through the models and the database connection.

1
2
3
4
5
6
7

from sqlmodel import SQLModel, create_engine

# Define the database URL
DATABASE_URL = "sqlite:///./test.db"

# Create the database engine
engine = create_engine(DATABASE_URL, echo=True)

Resources and alternatives¶

These resources and alternatives are related to the current item (in alphabetical order).

• PostgreSQL
• Pydantic
• Python pitfalls
• SQLite
• SQLModel