|1 day ago||3 days ago|
|MIT License||Mozilla Public License 2.0|
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.
Can anyone help me on how you are using golang with databases in production systems?
6 projects | reddit.com/r/golang | 18 Dec 2022
Is it better to use tools like [pgx](https://github.com/jackc/pgx) or stick with a ORM like GORM.
One Million Database Connections
2 projects | news.ycombinator.com | 1 Nov 2022
Go and PostgreSQL
6 projects | reddit.com/r/golang | 28 Oct 2022
Dapper-like ORM, Mapping
9 projects | reddit.com/r/golang | 6 Oct 2022
If your schema/migrations are not part of the go project then it might not be a great fit. It does support pgx which is a huge advantage imo vs plain database/sql.
Looking for some PgSQL infos
3 projects | reddit.com/r/golang | 3 Oct 2022
The Wiki doesn't help to get you started?
Is this a proper setup in Go for a postgres api?
2 projects | reddit.com/r/golang | 28 Sep 2022
Regarding postgres setup, it looks ok, I recommend considering pgx instead of libpq; reason being maintainability, libpq even recommends using pgx instead see README.
Building a Simple TODO App with Gin-gonic in Zerops: A step-by-step Guide
5 projects | dev.to | 23 Sep 2022
pgx is awesome: introducing pg_idkit
3 projects | reddit.com/r/rust | 9 Sep 2022
Is it related to https://github.com/jackc/pgx somehow?
Go EventSourcing and CQRS with PostgreSQL, Kafka, MongoDB and ElasticSearch 👋✨💫
16 projects | dev.to | 18 Jul 2022
PostgeSQL as event store database Kafka as messages broker gRPC Go implementation of gRPC Jaeger open source, end-to-end distributed tracing Prometheus monitoring and alerting Grafana for to compose observability dashboards with everything from Prometheus MongoDB MongoDB database Elasticsearch Elasticsearch client for Go. Echo web framework Kibana Kibana is data visualization dashboard software for Elasticsearch Migrate for migrations
How learn backend for frontend dev?
2 projects | reddit.com/r/golang | 5 Jul 2022
I'd stick with this approach rather than trying to learn Gorm as well. Simple is really your friend at this point. Note that because you aren't using Gorm you will need some other way of creating your tables. The simplest way of doing this is just to execute SQL table creation DDL statements manually using `psql`. There are separate migration packages for Go, but all that can come later I think. Note also that the old `pq` driver for Postgres is in maintenance mode, so maybe look at https://github.com/jackc/pgx which seems to be the recommended way of connecting to Postgres going forward.
Make Deno MySQL driver works better
3 projects | dev.to | 1 Dec 2022
Authentication method mismatch is not allowed to occur more than once. It is not a part of MySQL protocol. go-sql-driver also has the same rule.
Golang future web frameworks!
13 projects | reddit.com/r/golang | 24 Apr 2022
go-sql-driver/mysql 12.1k Stars, Used by 72.4k
Finding an Authorization Bypass on My Own Website
8 projects | news.ycombinator.com | 5 Mar 2022
> mysql_real_escape_string is still vulnerable when being used with some exotic character sets
Indeed -- mysql_real_escape_string "mostly" fixes this problem by requiring a connection as one of its args, and since it's usually aware of the connection state, it can check that to see if one of those exotic charsets is in-use. But the problem is that there are multiple ways to change the connection charset, some of which the driver is aware of (e.g. in PHP mysqli set_charset) but some it is not (running textual statements like SET NAMES or SET CHARACTER SET).
But generally an attacker won't ever have the ability to set an arbitrary exotic character set for the connection, unless they already have some other sql injection mechanism, in which case it's a moot point :)
Driver documentation also typically mentions this problem. For example, here's the doc for doing client-side param interpolation in the most popular MySQL driver for Golang: https://github.com/go-sql-driver/mysql#interpolateparams
It also explicitly detects if your initial connection settings attempt to use one of those charsets along with param interpolation, and throws an error if so: https://github.com/go-sql-driver/mysql/blob/21f789cd/dsn.go#...
> Couldn't one just save the extra round-trip with length-prefixed strings by sending the query together with the parameters in a single message?
AFAIK, no, not with the traditional MySQL binary protocol. The newer "X protocol" introduced in MySQL 5.7 does allow this, but it is not widely implemented in drivers.
[Question] Working with databases/storing data in Go applications.
4 projects | reddit.com/r/golang | 29 Jan 2022
However, you can use something like this https://github.com/go-reform/reform to help you with, I will call it automating the code writing. But I have always opted to one of the supported drivers and written a queries myself using for example this https://github.com/go-sql-driver/mysql.
Help a Go Lang neophyte become a veteran
2 projects | reddit.com/r/golang | 1 Dec 2021
For DB connection, you'll need something like https://github.com/Go-SQL-Driver/MySQL/ for mysql
Which SQL driver to use with Postgres
7 projects | reddit.com/r/golang | 27 Nov 2021
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?
6 projects | reddit.com/r/golang | 8 Nov 2021
go-sql-driver/mysql is the main pure golang implementation and is the most feature complete. Very happy with the result that it provides.6 projects | reddit.com/r/golang | 8 Nov 2021
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?
3 projects | reddit.com/r/mysql | 13 Aug 2021
Missing support: - Go go-sql-driver/mysql - PHP
6 projects | dev.to | 8 Jun 2021
Go MySQL driver Link
What are some alternatives?
sqlx - general purpose extensions to golang's database/sql
pq - Pure Go Postgres driver for 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.
sqlc - Generate type-safe code from SQL
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.
go-sqlite3 - sqlite3 driver for go using database/sql
retry-go - Simple golang library for retry mechanism