pgsql

Bun ORM PostgreSQL provider

PostgreSQL provider module for Bun ORM integration with Melody.

This module implements bunorm.Provider and produces a Bun database handle configured with the PostgreSQL dialect.

Import

• github.com/precision-soft/melody/integrations/bunorm/v2
• github.com/precision-soft/melody/integrations/bunorm/pgsql/v2

Provider

pgsql.Provider reads configuration values from Melody config using the parameter names passed to NewProvider.

Common parameter names:

• DB_HOST
• DB_PORT
• DB_DATABASE
• DB_USER
• DB_PASSWORD

Pool and timeout defaults can be overridden via WithPoolConfig and WithTimeoutConfig using PoolConfig and TimeoutConfig.

Advanced connector customization

If you need driver options that are not exposed by TimeoutConfig or other typed configs, use a post-build hook.

Provider constructors accept optional provider options:

• pgsql.NewProvider
• pgsql.NewProviderWithConfig

Configure a hook via pgsql.WithPostBuildHook using the pgsql.PostBuildHook signature.

The hook is executed during open, after Melody defaults and typed configs are applied, and before opening the SQL database.

Example:

package main

func main() {
	provider := pgsql.NewProvider(
		"DB_HOST",
		"DB_PORT",
		"DB_DATABASE",
		"DB_USER",
		"DB_PASSWORD",
		pgsql.WithPostBuildHook(func(ctx context.Context, resolver containercontract.Resolver, connector *pgdriver.Connector) error {
			_ = ctx
			_ = resolver
			connector.Config().TLSConfig.InsecureSkipVerify = true
			return nil
		}),
	)
}