I’m updating a table with query

I’m updating a table with query

I am currently making a REST API with Go and PostgreSQL for a web forum project for school. I have currently already supported pagination in my get forum posts endpoint by using a simple sql query:
SELECT * FROM posts ORDER BY created_at DESC OFFSET $1 LIMIT $2 where $1 is (page-1)*count and $2 is count. However I am currently not returning the total number of posts which will be useful for me once I starting implementing pagination in React for the frontend. I was wondering what the general approach for getting the total number of rows in a table are?
I do know that it is possible to query for all my posts and the total row count together in the same query using SELECT count(*) FROM posts but this comes at performance costs. I know this is just a small project so the effects are not that severe but I was thinking in a scenario with large amounts of data what would the actual, more efficient solution be?

I am currently making a REST API with Go and PostgreSQL for a web forum project for school. I have currently already supported pagination in my get forum posts endpoint by using a simple sql query:
SELECT * FROM posts ORDER BY created_at DESC OFFSET $1 LIMIT $2 where $1 is (page-1)*count and $2 is count. However I am currently not returning the total number of posts which will be useful for me once I starting implementing pagination in React for the frontend. I was wondering what the general approach for getting the total number of rows in a table are?
I do know that it is possible to query for all my posts and the total row count together in the same query using SELECT count(*) FROM posts but this comes at performance costs. I know this is just a small project so the effects are not that severe but I was thinking in a scenario with large amounts of data what would the actual, more efficient solution be?

I am currently making a REST API with Go and PostgreSQL for a web forum project for school. I have currently already supported pagination in my get forum posts endpoint by using a simple sql query:
SELECT * FROM posts ORDER BY created_at DESC OFFSET $1 LIMIT $2 where $1 is (page-1)*count and $2 is count. However I am currently not returning the total number of posts which will be useful for me once I starting implementing pagination in React for the frontend. I was wondering what the general approach for getting the total number of rows in a table are?
I do know that it is possible to query for all my posts and the total row count together in the same query using SELECT count(*) FROM posts but this comes at performance costs. I know this is just a small project so the effects are not that severe but I was thinking in a scenario with large amounts of data what would the actual, more efficient solution be?

I am currently making a REST API with Go and PostgreSQL for a web forum project for school. I have currently already supported pagination in my get forum posts endpoint by using a simple sql query:
SELECT * FROM posts ORDER BY created_at DESC OFFSET $1 LIMIT $2 where $1 is (page-1)*count and $2 is count. However I am currently not returning the total number of posts which will be useful for me once I starting implementing pagination in React for the frontend. I was wondering what the general approach for getting the total number of rows in a table are?
I do know that it is possible to query for all my posts and the total row count together in the same query using SELECT count(*) FROM posts but this comes at performance costs. I know this is just a small project so the effects are not that severe but I was thinking in a scenario with large amounts of data what would the actual, more efficient solution be?

I am currently making a REST API with Go and PostgreSQL for a web forum project for school. I have currently already supported pagination in my get forum posts endpoint by using a simple sql query:
SELECT * FROM posts ORDER BY created_at DESC OFFSET $1 LIMIT $2 where $1 is (page-1)*count and $2 is count. However I am currently not returning the total number of posts which will be useful for me once I starting implementing pagination in React for the frontend. I was wondering what the general approach for getting the total number of rows in a table are?
I do know that it is possible to query for all my posts and the total row count together in the same query using SELECT count(*) FROM posts but this comes at performance costs. I know this is just a small project so the effects are not that severe but I was thinking in a scenario with large amounts of data what would the actual, more efficient solution be?

For below code:

I’m developing a gRPC server in Go using rookie-ninja/rk-boot, rookie-ninja/rk-db/postgres, and rookie-ninja/rk-grpc/boot. I’m trying to connect to a Postgres database, but I’m encountering the error: “failed to get Postgres entry”.

I have a problem with correct parsing of JSONB to []string in golang