v3.2.1

Release 3.2.1: Database Compatibility Update for SQLite, PostgreSQL, and MySQL

Release Date: 2024-11-12

What's New

This release introduces compatibility enhancements across SQLite, PostgreSQL, and MySQL databases, focusing on data type adjustments, constraint handling, and primary key definitions. These improvements ensure consistent behavior across all supported databases.

Key Updates

1. Primary Key Adjustments

   • Replaced PostgreSQL-specific SERIAL with cross-compatible primary key configurations:
     • SQLite: INTEGER PRIMARY KEY AUTOINCREMENT
     • MySQL & PostgreSQL: Adapted for native auto-increment behaviors.

2. DecimalField Data Type Changes

   • Standardized DecimalField across databases:
     • SQLite: Uses REAL due to precision limitations.
     • PostgreSQL & MySQL: Maintains precision handling with appropriate constraints.

3. Improved Constraint Handling

   • Enhanced NOT NULL constraint management during table creation to prevent issues, especially in SQLite where constraints can't be altered post-creation.
   • Default values added for consistency.

4. Cross-Database Testing

   • Verified functionality for table creation, data insertion, querying, and filtering across SQLite, PostgreSQL, and MySQL.

Impact

This update enhances stability and performance for projects requiring multi-database support, allowing easy switching between databases without changing model definitions.

For feedback or issues, please refer to Issue #18.