VirtualTam's bookmarks

1. jackc/pgx - PostgreSQL Driver and Toolkit 2023-07-04

   tags: concurrency, database/postgresql, programming/go

   [ permalink ]

   • Getting started with pgx
   • https://donchev.is/post/working-with-postgresql-in-go-using-pgx/
   • jackc/pgx/v5/pgtype - Map between all common base types directly between Go and PostgreSQL
   • jackc/pgx/v5/pgxpool - Concurrency-safe connection pool for pgx
   • scany/v2/pgxscan - Scan data into Go structs and other composite types
   • Bulk INSERT in Postgres in GO using pgx
   • Postgres table batch updates using golang pgxpool not reflected in database
   • pgx.Conn can see uncommitted changes made from a pgx.Tx - TL;DR use pgxpool for concurrency-safe transactions
   • Not clear if caller is required to close in case of QueryRow or if QueryRow properly closes in case of error