Skip to content

Welcome to AbarORM

Logo

abarorm is a lightweight and easy-to-use Object-Relational Mapping (ORM) library for SQLite, PostgreSQL and MySQL databases in Python. It aims to provide a simple and intuitive interface for managing database models and interactions.

Features

  • Define models using Python classes.
  • Automatically handle database schema creation and management.
  • Support for basic CRUD (Create, Read, Update, Delete) operations.
  • Manage foreign key relationships effortlessly.
  • Custom field types with validation and constraints.
  • New in v1.0.0: Automatic table creation and updates.
  • New in v2.0.0: Added support for PostgreSQL databases.
  • New in v2.0.0: Ordering by fields in the all() method.
  • New in v3.0.0: Fixed table naming bugs to ensure consistent naming conventions.
  • New in v3.0.0: Updated return values for methods to improve clarity and usability.
  • New in v3.0.0: Enhanced filter method now supports order_by for ordering.
  • New in v3.2.0: Added __gte and __lte functionality in the filter section.

Supported Databases

psql mysql sqlite

Installation

You can install abarorm from PyPI using pip:

pip install abarorm

For MySQL support, you also need to install mysql-connector-python: (Required)

pip install mysql-connector-python
For PostgreSQL support, install psycopg2-binary: (Required) 
pip install psycopg2-binary

Start with abarorm