datapod_postgres #

The PostgreSQL database plugin for the Datapod ORM.

✨ Features #

• Fully integrates PostgreSQL into the Datapod ecosystem.
• Supports transactions, connection pooling, and automated schema management.
• Handles advanced data types like JSONB and Arrays via Datapod's mapping system.

📖 Usage #

Add to your pubspec.yaml:

dependencies:
  datapod_postgres: any

databases:
  - name: main_db
    plugin: datapod_postgres

In your connections.yaml, provide the credentials (supports environment variables):

connections:
  - name: main_db
    host: ${DB_HOST:-localhost}
    port: 5432
    username: my_user
    password: ${DB_PASSWORD}
    database: my_app

  # Optional: Separate connection for migrations (e.g. admin user)
  - name: migration_db
    host: localhost
    port: 5432
    username: admin_user
    password: admin_password
    database: my_app

Then link it in databases.yaml:

databases:
  - name: main_db
    plugin: datapod_postgres
    connection: main_db
    migrationConnection: migration_db # Optional

For full documentation, see the root README.