mention pgxpool in go and pgx guide (#4047)

seriousben · web-flow · commit 85e64dafef26 · 2025-08-08T09:29:22.000-07:00
diff --git a/docs/guides/using-go-and-pgx.rst b/docs/guides/using-go-and-pgx.rst
@@ -109,3 +109,25 @@ pgx types directly.
     
     	fmt.Println(author.Name)
     }
+
+.. note::
+   For production applications, consider using pgxpool for connection pooling:
+
+   .. code-block:: go
+
+       import (
+           "github.com/jackc/pgx/v5/pgxpool"
+           "example.com/sqlc-tutorial/db"
+       )
+
+       func main() {
+           pool, err := pgxpool.New(context.Background(), os.Getenv("DATABASE_URL"))
+           if err != nil {
+               fmt.Fprintf(os.Stderr, "Unable to create connection pool: %v\n", err)
+               os.Exit(1)
+           }
+           defer pool.Close()
+
+           q := db.New(pool)
+           // Use q the same way as with single connections
+       }
