PackageTrack
Sign in Get early access

aim_postgres

A native PostgreSQL driver for Dart with full wire protocol implementation. Supports SSL/TLS, SCRAM-SHA-256 authentication, and parameterized queries.

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_postgres - A native PostgreSQL driver for Dart.

    Features

    • PostgreSQL Wire Protocol:

      • Full implementation of PostgreSQL protocol version 3.0
      • Simple Query Protocol for static SQL
      • Extended Query Protocol for parameterized queries
      • Message parsing for all common message types
    • SSL/TLS Support:

      • Multiple SSL modes: disable, allow, prefer, require, verify-ca, verify-full
      • CA certificate verification
      • Hostname verification (verify-full mode)
    • Authentication:

      • Cleartext password authentication
      • MD5 password authentication
      • SCRAM-SHA-256 authentication (PostgreSQL 10+)
    • Query Execution:

      • query() method for SELECT statements
      • execute() method for INSERT/UPDATE/DELETE
      • Positional parameters ($1, $2, ...)
      • Named parameters (:name, :id, ...)
      • Automatic parameter conversion (int, double, String, bool, DateTime)
    • Transactions:

      • transaction() method with callback
      • Automatic COMMIT on success
      • Automatic ROLLBACK on error
    • Notice Messages:

      • Stream-based notice/warning message handling
      • Access via connection.noticeMessage stream

    Supported

    • Dart SDK: ^3.10.0
    • PostgreSQL: 9.5+ (SCRAM-SHA-256 requires PostgreSQL 10+)

    What's Included

    • PostgresDatabase - High-level database API
    • PostgresConnection - Low-level connection handling
    • PostgresTransaction - Transaction context
    • QueryResult - Query result container
    • QueryException - Query error handling
    • SSL mode enums and authentication type enums
    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