[Question] Suggested way to update a database row using gRPC/PostgreSQL (pgx) ?

• flipt

  19 3,301 9.9 Go

  Enterprise-ready, GitOps enabled, CloudNative feature management solution

  

If you want to look at some example code, I do this same thing in my project Flipt which uses GRPC, Postgres (and optionally MySQL and Sqlite).

• go-grpc-middleware

  7 6,043 7.3 Go

  Golang gRPC Middlewares: interceptor chaining, auth, logging, retries and more.

  

I do some basic validation at the server layer using a GRPC interceptor.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• pgx

  71 9,414 9.2 Go

  PostgreSQL driver and toolkit for Go

String manipulation could lead to nasty SQL injections and really because you're using pgx there's no need to do that either, see the Conn.SendBatch method, it should allow you to achieve what you're trying to do: execute multiple queries in a transaction and still get their results. (test example)

Suggest a related project