PackageTrack
Sign in Get early access

aim_orm_postgres

PostgreSQL ORM implementation for Dart with Record syntax table definitions and type-safe query builders.

0.1.1 aim-dart/aim

What this package is like to depend on

Last release 7 months ago

20 Jan 2026

Too new to tell

only 1 release windows

Nearly every release is documented

notes for 3 of 3 stable releases

Nothing withdrawn

no release was ever pulled

7 months old

3 releases · first in 2026

3 releases in the last 12 months

see the full history below

Release timeline

3 releases · Jan 2026 to Jan 2026
Release Pre-release

Releases

latest 3
  1. 0.1.1 20 Jan 2026
    Release notes

    Internal fixes. No functional changes.

    Open source →
    Release notes

    Internal fixes. No functional changes.

    Open source →
    Release notes Open source →
  2. 0.1.0 20 Jan 2026
    Release notes

    Changelog

    0.1.0

    First beta release of Aim Framework - a modular ecosystem for Dart.

    Highlights

    • Lightweight, fast web server framework
    • Native PostgreSQL driver (no external dependencies)
    • Type-safe ORM with Record syntax
    • CLI tools with hot reload and database migrations

    Web Server (aim_server)

    • HTTP server built on Dart's native HttpServer
    • Path-based routing with parameter support (/users/:id)
    • Composable middleware chain
    • JSON, text, HTML response handling
    • Real-time SSE streaming support
    • Custom error handlers (404, global)

    Middleware Packages

    • aim_server_cors: CORS configuration
    • aim_server_cookie: Secure cookie management
    • aim_server_form: Form data parsing
    • aim_server_multipart: File upload handling
    • aim_server_static: Static file serving
    • aim_server_logger: HTTP request logging
    • aim_server_sse: Server-Sent Events
    • aim_server_jwt: JWT authentication
    • aim_server_basic_auth: Basic authentication

    Testing (aim_server_testing)

    • Test helpers and matchers
    • Mock objects for unit testing
    • Integration test utilities

    Database (aim_database + aim_postgres)

    • Database abstraction layer
    • Native PostgreSQL Wire Protocol implementation
    • SSL/TLS support (disable, allow, prefer, require, verify-ca, verify-full)
    • Authentication: cleartext, MD5, SCRAM-SHA-256
    • Named parameters (:name) and positional parameters ($1)
    • Transaction support with automatic commit/rollback

    ORM (aim_orm + aim_orm_postgres + aim_orm_codegen)

    • Type-safe table definitions using Dart Record syntax
    • Column types: integer, bigint, varchar, text, boolean, timestamp, uuid, json
    • Column modifiers: primaryKey, unique, nullable, withDefault, indexed
    • Query builders: SELECT, INSERT, UPDATE, DELETE
    • Condition operators: eq, gt, lt, gte, lte, inList
    • Code generation with build_runner

    CLI (aim_cli)

    • aim create <name>: Project scaffolding
    • aim dev: Development server with hot reload
    • aim build: Production build with native compilation
    • aim db:generate: Migration SQL generation from schema diff
    • aim db:migrate: Apply pending migrations
    • aim db:rollback: Rollback migrations
    • aim db:status: Show migration status

    Known Limitations

    • ORM Relations (1:1, 1:N, N:N) not yet supported
    • SQLite driver not yet available
    • db:reset command not yet implemented

    Requirements

    • Dart SDK: ^3.10.0
    • PostgreSQL: 9.5+ (SCRAM-SHA-256 requires 10+)
    Open source →
    Release notes

    First beta release of Aim Framework - a modular ecosystem for Dart.

    Highlights

    • Lightweight, fast web server framework
    • Native PostgreSQL driver (no external dependencies)
    • Type-safe ORM with Record syntax
    • CLI tools with hot reload and database migrations

    Web Server (aim_server)

    • HTTP server built on Dart's native HttpServer
    • Path-based routing with parameter support (/users/:id)
    • Composable middleware chain
    • JSON, text, HTML response handling
    • Real-time SSE streaming support
    • Custom error handlers (404, global)

    Middleware Packages

    • aim_server_cors: CORS configuration
    • aim_server_cookie: Secure cookie management
    • aim_server_form: Form data parsing
    • aim_server_multipart: File upload handling
    • aim_server_static: Static file serving
    • aim_server_logger: HTTP request logging
    • aim_server_sse: Server-Sent Events
    • aim_server_jwt: JWT authentication
    • aim_server_basic_auth: Basic authentication

    Testing (aim_server_testing)

    • Test helpers and matchers
    • Mock objects for unit testing
    • Integration test utilities

    Database (aim_database + aim_postgres)

    • Database abstraction layer
    • Native PostgreSQL Wire Protocol implementation
    • SSL/TLS support (disable, allow, prefer, require, verify-ca, verify-full)
    • Authentication: cleartext, MD5, SCRAM-SHA-256
    • Named parameters (:name) and positional parameters ($1)
    • Transaction support with automatic commit/rollback

    ORM (aim_orm + aim_orm_postgres + aim_orm_codegen)

    • Type-safe table definitions using Dart Record syntax
    • Column types: integer, bigint, varchar, text, boolean, timestamp, uuid, json
    • Column modifiers: primaryKey, unique, nullable, withDefault, indexed
    • Query builders: SELECT, INSERT, UPDATE, DELETE
    • Condition operators: eq, gt, lt, gte, lte, inList
    • Code generation with build_runner

    CLI (aim_cli)

    • aim create <name>: Project scaffolding
    • aim dev: Development server with hot reload
    • aim build: Production build with native compilation
    • aim db:generate: Migration SQL generation from schema diff
    • aim db:migrate: Apply pending migrations
    • aim db:rollback: Rollback migrations
    • aim db:status: Show migration status

    Known Limitations

    • ORM Relations (1:1, 1:N, N:N) not yet supported
    • SQLite driver not yet available
    • db:reset command not yet implemented

    Requirements

    • Dart SDK: ^3.10.0
    • PostgreSQL: 9.5+ (SCRAM-SHA-256 requires 10+)
    Open source →
    Release notes Open source →
  3. 0.0.1 20 Jan 2026
    Release notes

    Initial release of aim_orm_postgres - PostgreSQL ORM implementation for Dart.

    Features

    • Record Syntax Table Definitions:
      • @PgTable annotation for table declaration
      • Type-safe column definitions using Dart Records
    • PostgreSQL Column Types:
      • uuid() - UUID type
      • serial() - Auto-increment integer
      • jsonb<T>() - JSONB with generic type support
    • Foreign Key Support:
      • references() - Define foreign key relationships
      • OnDeleteAction - CASCADE, SET NULL, RESTRICT, NO ACTION
    • Code Generation:
      • Automatic query builder generation
      • Type-safe Row typedefs
      • PostgresDatabase extension methods
      • PostgresTransaction extension methods

    CRUD Operations

    • SELECT with WHERE, LIMIT, OFFSET
    • INSERT with type-safe values
    • UPDATE with SET and WHERE
    • DELETE with WHERE

    Supported

    • Dart SDK: ^3.10.0
    • PostgreSQL: All versions supported by aim_postgres

    What's Included

    • PgTable annotation class
    • PostgreSQL-specific column types (SerialColumn, UuidColumn, JsonbColumn)
    • Column builder functions (serial, uuid, jsonb)
    • Integration with aim_orm_codegen for code generation
    Open source →

Every package, every release, already written down.

The archive is open and free. Watching your own project is what we are building next.

Browse the archive