Skip to content

Welcome to AbarORM

Logo

abarorm is a lightweight and easy-to-use Object-Relational Mapping (ORM) library for SQLite and PostgreSQL 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.
  • New in v4.0.0: Added __repr__, count, and to_dict methods for easier data manipulation and debugging.
  • New in v4.2.3: Added first(), last(), exists(), and paginate() methods to the QuerySet class for more powerful querying capabilities.
  • New in v5.0.0: Fix PostgreSQL Bugs and structure.
  • New in v5.1.0: Enhanced functionality for better usability and robustness:
  • New in v5.2.0: Introduced bulk_create for efficient batch insertions.
  • New in v5.3.0: Added filter support to the QuerySet class for in-memory filtering.
  • New in v5.4.0: PostgreSQL database creation improved, added related_name support for ForeignKeys.

Supported Databases

psql sqlite

Installation

You can install abarorm from PyPI using pip:

pip install abarorm

For PostgreSQL support, install psycopg2-binary: (Required) 

pip install psycopg2-binary

Start with abarorm