How to configure pgxpool to use google uuid library?

[soasada]

Hi, I'm trying to migrate a project to google uuid library. I'm using pgxv4 and have the configuration of uuid type with github.com/jackc/pgtype/ext/gofrs-uuid, how can I change it now in order to use google library?

import (
  "github.com/jackc/pgtype"
  pgtypeuuid "github.com/jackc/pgtype/ext/gofrs-uuid"
  "github.com/jackc/pgx/v4"
  "github.com/jackc/pgx/v4/pgxpool"
)

config, err := pgxpool.ParseConfig(dbUrlWithMaxConnections)
if err != nil {
	log.Fatal().Err(err).Msg("Unable to open config connection pool")
}
config.AfterConnect = func(ctx context.Context, conn *pgx.Conn) error {
	conn.ConnInfo().RegisterDataType(pgtype.DataType{
		Value: &pgtypeuuid.UUID{},
		Name:  "uuid",
		OID:   pgtype.UUIDOID,
	})
	return nil
}

dbPool, err := pgxpool.ConnectConfig(context.Background(), config)

[jackc]

pgx v4 does not have a built-in adapter for the Google UUID library. It still work though (albeit a little slower) -- pgx v4 is compatible with database/sql Scanner and Valuer.

And there is a 3rd party adapter for pgx v5 https://github.com/vgarvardt/pgx-google-uuid.

[soasada]

Thanks for your reply I used it successfully, here is a quick example code:

import (
	"context"
	"github.com/jackc/pgtype"
	"github.com/jackc/pgx/v4"
	"github.com/jackc/pgx/v4/pgxpool"
	pgxUUID "github.com/vgarvardt/pgx-google-uuid/v4"
)

config, err := pgxpool.ParseConfig("url")
if err != nil {
	panic("Unable to open config connection pool")
}
config.AfterConnect = func(ctx context.Context, conn *pgx.Conn) error {
	conn.ConnInfo().RegisterDataType(pgtype.DataType{
		Value: &pgxUUID.UUID{},
		Name:  "uuid",
		OID:   pgtype.UUIDOID,
	})
	return nil
}

dbPool, err := pgxpool.ConnectConfig(context.Background(), config)