pgx
PostgreSQL driver and toolkit for Go (by jackc)
go-sql-driver/mysql
Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)
Our great sponsors
| pgx | go-sql-driver/mysql | |
|---|---|---|
| 28 | 9 | |
| 4,917 | 11,797 | |
| - | 0.9% | |
| 8.0 | 5.2 | |
| 7 days ago | 8 days ago | |
| Go | Go | |
| MIT License | Mozilla Public License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgx
Posts with mentions or reviews of pgx.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-11-27.
-
The proper way to deal with unique constraints using std "database/sql"
I'm using github.com/jackc/pgx/stdlib to connect on Postgres.
-
Shared db connection pool in lambdas - do you ever close the connection explicitly?
Just doing some testing with Golang postgres library pgx's connection pools, and I figure I could set this up outside of the main() function to share the connection pool with concurrent lambda executions. One thing I can't figure out though is I don't think I can safely, and explicitly call a close() on the connection. Is this normal to just let the connection time out if the lambda is not being used? If the connection times out before the lambda shuts off, then how can I re-establish a globally available connection pool? I imagine this is a potential problem for any db that's not accessible over HTTP(s)?
-
Why does my go.sum list unreferenced packages?
Someone correct me if I'm wrong here, but I believe Go 1.17 with "Pruned module graphs in go 1.17 modules" fixes this issue, but for pgx, it won't take effect until both your own and their go.mod only support go 1.17 or above.
-
Is there any Go library to backup and restore PostgreSQL?
I don't think so, but you should look at https://github.com/jackc/pgx which have low level features maybe for replication ?
- Which SQL driver to use with Postgres
-
Back to basics: Writing an application using Go and PostgreSQL
The way it parses dates using Unix time causes issues when you compare the values returned due to Go setting the location property:
https://github.com/jackc/pgx/issues/863
pgx doesn't seem to handle reconnects the same way lib/pg does, but I haven't tested this recently: https://github.com/jackc/pgx/issues/672
-
[Question] Suggested way to update a database row using gRPC/PostgreSQL (pgx) ?
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)
-
How do the database drivers communicate with the database? Is it just through some type of protocol at a certain port?
pgx
-
Problem trying to insert data received from Colly web scraper lib into DB via pgx library
In the process of trying to get better with Go, I have been trying to create a program that will scrape a subreddit and then save some info into a Postgres table. In this case, I decided to use r/frugalmalefashion and save the title and flair of recent posts into the table. I am using Colly to scrape data, and pgx as the database driver.
-
psql slow intial connection?
Connecting from my golang app via pgx database driver inside Docker (Alpine linux image) on my windows dev system: < 1s -> fast
go-sql-driver/mysql
Posts with mentions or reviews of go-sql-driver/mysql.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-12-01.
-
Connecting to mysql returns Acces denied. Can only connect to the DB through dbeaver using a specific driver properties configuration.
I am using this driver https://github.com/go-sql-driver/mysql
-
Help a Go Lang neophyte become a veteran
For DB connection, you'll need something like https://github.com/Go-SQL-Driver/MySQL/ for mysql
-
Which SQL driver to use with Postgres
I'm following Alex Edwards web dev book, he uses MySQL with go-sql-driver/mysql , i want to use Postgres, which one should I use?
-
Are both MySQL and Postgres drivers similar in quality?
go-sql-driver/mysql is the main pure golang implementation and is the most feature complete. Very happy with the result that it provides.
https://github.com/go-sql-driver/mysql/issues/561 , and it's not coming anytime soon
-
Do you use connection attributes and assign a name to your clients when connecting to MySQL?
Missing support: - Go go-sql-driver/mysql - PHP
-
Food-app
Go MySQL driver Link
-
Web Development in Go: Middleware, Templating, Databases & Beyond
For example, here's how to use the MySQL driver package with database/sql:
-
Gopher Gold #10 - Wed Sep 09 2020
go-sql-driver/mysql (Go): Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package
What are some alternatives?
When comparing pgx and go-sql-driver/mysql you can also consider the following projects:
pq - Pure Go Postgres driver for database/sql
sqlx - general purpose extensions to golang's database/sql
GORM - The fantastic ORM library for Golang, aims to be developer friendly
gomock - GoMock is a mocking framework for the Go programming language.
migrate - Database migrations. CLI and Golang library.
goqu - SQL builder and query library for golang
Gin - Gin is a HTTP web framework written in Go (Golang). It features a Martini-like API with much better performance -- up to 40 times faster. If you need smashing performance, get yourself some Gin.
opentelemetry-collector - OpenTelemetry Collector
sqlc - Generate type-safe code from SQL
go-sqlite3 - sqlite3 driver for go using database/sql