Struct Postgres

pkg/database/postgres/postgres.go:22–52

Postgres - Structure for Postresql instance

// Postgres - Structure for Postresql instance
type Postgres struct {
	ReadPool  *pgxpool.Pool
	WritePool *pgxpool.Pool

	Builder squirrel.StatementBuilderType
	// options
	// maxDataPerWrite sets the maximum amount of data per write operation to the database
	maxDataPerWrite int
	// maxRetries defines the maximum number of retries for database operations in case of failure
	maxRetries int
	// watchBufferSize specifies the buffer size for database watch operations, impacting how many changes can be queued
	watchBufferSize int
	// maxConnectionLifeTime determines the maximum lifetime of a connection in the pool
	maxConnectionLifeTime time.Duration
	// maxConnectionIdleTime determines the maximum time a connection can remain idle before being closed
	maxConnectionIdleTime time.Duration
	// maxConnections is the maximum number of connections in the pool (maps to pgxpool MaxConns)
	maxConnections int
	// maxIdleConnections is deprecated: Use MinConnections instead. Kept for backward compatibility (maps to MinConnections if MinConnections is not set).
	maxIdleConnections int
	// minConnections is the minimum number of connections in the pool (maps to pgxpool MinConns)
	minConnections int
	// minIdleConnections is the minimum number of idle connections in the pool (maps to pgxpool MinIdleConns)
	minIdleConnections int
	// healthCheckPeriod is the period between health checks on idle connections
	healthCheckPeriod time.Duration
	// maxConnectionLifetimeJitter is jitter added to MaxConnLifetime to prevent all connections from expiring at once
	maxConnectionLifetimeJitter time.Duration
	// connectTimeout is the maximum time to wait when establishing a new connection
	connectTimeout time.Duration
}

// New -
func New(uri string, opts ...Option) (*Postgres, error) {