sq
gqlgen
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.
sq
-
How to use prepared queries wisely - postgres & pgx & squirell
You can use my library sq which handles this exact use case with the PreparedQuery type. It allows you to build a query programmatically, prepare it and optionally rebind parameters by name.
-
How to Work with SQL Databases in Go
Have you seen my library https://github.com/bokwoon95/sq? You can use it like database/sql and write plain SQL strings, only needing to provide a function that maps an database row to a struct and generics returns a slice of those structs at the end.
-
DRY pgx / database/sql?
Also consider my library sq which handles dynamic query generation as well as data mapping. You may find it simpler than bun because it's a lot closer to database/sql (it doesn't require a special DB object, it uses a plain *sql.DB).
-
Ent: An Entity Framework for Go
> I didn't see anything to help me build back graphs
Hmm you've certainly given me something to think about. Thanks.
BTW joins are not challenging, but you made me realize I didn't show any joins in my basic examples. Here is UPDATE with JOIN example: https://bokwoon.neocities.org/sq.html#postgres-update-with-j....
-
scan rows into types powered by generics
How does it compare to https://github.com/bokwoon95/sq?
- Show HN: An SQL data mapper using Go generics
- A type-safe struct mapper and query builder for Go (using generics)
- A struct mapper, query builder and migration tool for Go.
gqlgen
-
Who moved my error codes? Adding error types to your GoLang GraphQL Server
GraphQL’s spec, as it turns out, does not specify how servers should handle internal errors at all, leaving it entirely to the choice of the frameworks’ creators. Take for example our GoLang GraphQL framework of choice - gqlgen. It makes no distinction between intentional and unexpected errors: all errors are returned as-is to the client within the error message. Internal errors, which often contain sensitive information like network details and internal URIs, would leak to clients easily if not caught manually by the programmer.
-
“Go is hard to justify unless at massive scale”
Better look into this one: https://github.com/99designs/gqlgen for GraphQL powered by Go. It's spec first approach and requires the least boilerplate code to write. It also incorporates seamlessly with Apollo Federation.
-
Go with PHP
I left PHP for Go.
- with http://sqlc.dev I don't have to write ORM or model code anymore.
- with http://goa.design I can have well-documented API's that any team can generate a client for in any language. It also generates the HTTP JSON and gRPC servers for me so I can focus on my logic.
- with https://github.com/99designs/gqlgen I can define GraphQL revolvers that play well with sqlc (any RDBMS) or I can use a key-value store.
- speaking of key-value stores, Go allows them to be embedded! Even SQLite now has the https://litestream.io/ project to make it super simple to use a durable, always backed-up SQLite database even in a serverless context.
Go is faster, uses less memory, and has really-well designed stdlib without all the bugs I used to face trying to use the PHP stdlib.
-
Golang tech stack
Gqlgen if I need GraphQL
-
Scalable APIs with GraphQL Server Codegen Preset
Some of these features are inspired by gqlgen so check it out if you need a Golang GraphQL server implementation.
-
How to develop a Web app in go
If you want to use GraphQL: https://github.com/99designs/gqlgen
-
Libraries you use most of your projects?
In addition to the ones you mentioned, I also always use: + sqlc - Compile SQL to type-safe code + gqlgen - generate GraphQL server from schema + oapi-codegen - Go client and server boilerplate from OpenAPI 3 specifications + pester - Go http calls with retries and backoff + backoff - exponential backoff algorithm in Go
-
Ent: An Entity Framework for Go
I have no experience in Django but in Ent with GraphQL.
Ent is not a full-featured web framework so you need to implement many of features by your own or use other libraries (e.g. http server and session management).
If you are only looking for ORM + GraphQL then I highly recommend trying Entgql, an Ent extension for GraphQL with Gqlgen library [1]. Once you define an ORM schema, it will generate GraphQL Query for Relay server. Still you need to implement GraphQL Mutations by your own but at least it will create Input types for you (both for Create/Update).
[1]: https://github.com/99designs/gqlgen
-
Best packages?
gqlgen for GraphQL services. It's well documented and maintained.
-
Decent examples querying models from Postgres
For me sqlc work wonders. If you are developing a user facing api and are fine to go with graphql, with gqlgen you can even autobind (search the page for @goModel) the models that sqlc generates from your queries. A glorious match
What are some alternatives?
vlcn-orm - Develop with your data model anywhere. Query and load data reactively. Replicate between peers without a central server.
graphql-go - GraphQL server with a focus on ease of use
scan - scan sql rows into any type powered by generics
Fiber - ⚡️ Express inspired web framework written in Go
korm - KORM, an elegant and lightning-fast ORM for all your concurrent and async needs. Inspired by the highly popular Django Framework, KORM offers similar functionality with the added bonus of performance
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.
typed-graphql-builder - A fully type-safe graphql query builder, inspired by tql
Echo - High performance, minimalist Go web framework
node-sql - SQL generation for node.js
go-kit - A standard library for microservices.
sqddl - sqddl is a zero-configuration database migration tool.
fasthttprouter - A high performance fasthttp request router that scales well