Are you using github.com/jackc/pgx/v5? Do you need to Scan/insert protobuf Timestamps? Then this is the library for you!
You will need to add this to your project of course:
go get github.com/manniwood/pgx-protobuf-timestamp
Then, if you are using a single connection to postgres, do this:
import (
"github.com/jackc/pgx/v5"
"github.com/manniwood/pgx-protobuf-timestamp/pgxpbts"
)
...
config, err := pgx.ParseConfig(dbURL)
if err != nil {
return nil, err
}
conn, err := pgx.ConnectConfig(context.Background(), config)
if err != nil {
return nil, err
}
pgxpbts.Register(conn.TypeMap())
pgxpbts.RegisterTZ(conn.TypeMap())
or, if you are using pgxpool:
import (
"github.com/jackc/pgx/v5"
"github.com/jackc/pgx/v5/pgxpool"
"github.com/manniwood/pgx-protobuf-timestamp/pgxpbts"
)
...
config, err := pgxpool.ParseConfig(dbURL)
if err != nil {
return nil, err
}
config.AfterConnect = func(ctx context.Context, conn *pgx.Conn) error {
pgxpbts.Register(conn.TypeMap())
pgxpbts.RegisterTZ(conn.TypeMap())
return nil
}
pool, err := pgxpool.NewWithConfig(context.Background(), config)
if err != nil {
return nil, err
}
Now, you will be able to serialize/deserialize Go protobuf *timestamppb.Timestamp types
to/from Postgres timestamp and timestamptz types.
See the tests for examples.
See https://github.com/jackc/pgx-gofrs-uuid and https://github.com/jackc/pgx-shopspring-decimal for more examples of how to write type serializers/deserializers for pgx.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent