A pydantic powered universal ORM wrapper for databases.
- Execute queries on a database.
- Read a database table as a dataframe.
- Write a dataframe to a database table (still under development).
- Flatten and normalize a dataframe with nested structure.
- Serialize a dataframe as a list of pydantic models.
- Deserialize a list of pydantic models as a dataframe.
The primary backend for parsing dataframes is polars due to it's superior performance. Xin supports pandas dataframes as well, however, they are internally converted to polars dataframes first to not compromise performance.
The backend for interacting with SQL databases is sqlalchemy because it supports async features and is the de-facto standard for communicating with SQL databases.
- MySQL
- PostgreSQL
- SQL Server
- Mongodb
Xin is async first. It means that if an async driver is available for a database dialect, it will leverage the async driver for better performance when applicable. SQL Server driver PyMSSQL does not have an async variation yet.