Integrating PostgreSQL | Discord Gophers | Page 1

pliant gate Dec 18, 2023, 6:03 PM

#

Hey guys, so I just trying to learn go and make a basic http server with some apis and I wanted to get help on how to integrate postgresql. Yeah i know noobie question but I would appreciate any help.

wind rover Dec 18, 2023, 6:20 PM

#

I like this library pgx https://github.com/jackc/pgx

GitHub

GitHub - jackc/pgx: PostgreSQL driver and toolkit for Go

PostgreSQL driver and toolkit for Go. Contribute to jackc/pgx development by creating an account on GitHub.

#

https://bitbucket.org/sudojoe/scsa/src/main/repository.go

This was a toy project I made that uses the pgx library and another library called goqu to generate sql.

I wouldn't say my code in this project is perfect. It's somewhat sloppy but it's simple enough that it might give you an idea of how you can connect with a postgres database and execute some queries

Bitbucket

pliant gate Dec 18, 2023, 6:34 PM

#

oh thank u so much!

worldly sluice Dec 19, 2023, 12:05 PM

#

If you read the README of pq, and the featureset offered by pgx, you'll probably understand why most recommend pgx.

pq only gets fixes to ensure that it remains usable in projects that import it.

This package is currently in maintenance mode, which means:
It generally does not accept new features.
It does accept bug fixes and version compatability changes provided by the community.
Maintainers usually do not resolve reported issues.
Community members are encouraged to help each other with reported issues.
For users that require new features or reliable resolution of reported bugs, we recommend using pgx which is under active development.

#Integrating PostgreSQL