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.

✨ Key Features

  • Define database models using clean and simple Python classes
  • Automatic table creation and schema synchronization
  • Unified and predictable CRUD behavior across SQLite & PostgreSQL
  • Powerful and expressive QuerySet API
  • Built-in ForeignKey relationship handling
  • Custom field types with validation and constraints
  • Optimized for clarity, safety, and long-term maintainability

🛡️ What’s New in v5.5.2 (Latest)

AbarORM v5.5.2 — Security, Stability & Unified Behavior

This release focuses on security hardening, behavior consistency, and internal robustness across both supported database engines.

🚀 Highlights

  • SQL Injection Protection All CRUD operations are now fully protected against SQL injection using strict field validation and parameterized queries for both SQLite and PostgreSQL.

  • Unified CRUD Behavior Methods such as create, bulk_create, update, delete, and save now behave identically across databases—no surprises, fewer bugs.

  • Improved save() Logic

  • Existing objects are always updated

  • Newly created objects always receive their id

  • Refined bulk_create & ForeignKey Handling Batch inserts and ForeignKey relations are now consistent, reliable, and engine-agnostic.

  • Enhanced QuerySet.contains() Improved filtering support for date and datetime fields.

  • Better Debugging Experience Clearer and more informative __repr__ output for models and QuerySets.

  • Improved Field Architecture SQLite and PostgreSQL field implementations are now more complete, structured, and future-proof.

  • Performance & Reliability Improvements Core methods have been rewritten for faster execution and safer operations.

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