jmoiron/sqlx on Hacker News

…add iterator API for database/sql results this decade too (something like my pull request for sqlx https://github.com/jmoiron/sqlx/pull/990 but maybe more polished)

comment by nasretdinov · 2026-07-31 · in Golang proposal: container/: generic collection types

…ground is libraries that give you nicer ergonomics around SQL without hiding it (like Golangs sqlx https://github.com/jmoiron/sqlx ). Engineers should be writing SQL, period. The blog suggests that an ORM for OLAP would do exactly that

comment by oatsandsugar · 2025-08-17 · in Does OLAP Need an ORM

…ground is libraries that give you nicer ergonomics around SQL without hiding it (like Golangs sqlx https://github.com/jmoiron/sqlx ). Engineers should be writing SQL, period.

comment by ram_rar · 2025-08-17 · in Does OLAP Need an ORM

We've always used https://github.com/jmoiron/sqlx which is just the standard package + mapping to/from structs.

comment by rowanseymour · 2023-08-14 · in Python: Just Write SQL

…struct tags https://sqlc.dev/ for generated models based on SQL (skip the whole idea of an ORM) https://github.com/jmoiron/sqlx for more traditional object population from SQL https://pkg.go.dev/errors for an understanding of wrapping…

comment by Xeoncross · 2022-08-17 · in Learning a new language, or how I gained familiarity with Go

…(it's archived, but it's easy code to write) to help with sql query generation, and use github.com/jmoiron/sqlx for easier scanning. I guess it's a little trickier when trying to use postgres specific commands, but we haven't run into man

comment by ramenmeal · 2021-09-08 · in How We Went All In on sqlc/pgx for Postgres and Go

There is sqlx for that: https://github.com/jmoiron/sqlx

comment by marvinblum · 2021-03-10 · in I don't want to learn your query language (2018)

sqlx (1) is probably the closest thing to a tradition ORM that operates this way ^1: https://github.com/jmoiron/sqlx

comment by badrequest · 2019-11-08 · in Go Turns 10

I wasn't happy with the current database access packages ( https://github.com/jmoiron/sqlx , https://gorm.io ), so I wrote my own for PostgreSQL. It takes existing queries and generates type-safe Go methods (…

comment by conroy · 2019-11-08 · in Go Turns 10

…also prevent SQL Injection. sqlx seems to be quite popular but sqlz could do with some love. [1] https://github.com/jmoiron/sqlx [2] https://github.com/ido50/sqlz

comment by pritambarhate · 2019-11-08 · in Security assessment techniques for Go projects

For me it doesn't get more seamless than github.com/jmoiron/sqlx No frills, just a little reflection to tie struct fields <=> SQL params.

comment by ereyes01 · 2019-07-13 · in Show HN: Sqlkit – Golang SQL package with nested transactions

…Without going through everything in detail, why would I pick this over the very popular sqlx? https://github.com/jmoiron/sqlx

comment by dewey · 2019-07-13 · in Show HN: Sqlkit – Golang SQL package with nested transactions

…also come across squirrel[2] too, though I haven't used it, it does look rather interesting. [1] - https://github.com/jmoiron/sqlx [2] - https://github.com/masterminds/squirrel

comment by bkq · 2019-05-07 · in To ORM or Not to ORM

I believe that sqlx for go is amazing in bridging the gap between orm and plain SQL! https://github.com/jmoiron/sqlx

comment by jakoblorz · 2018-09-01 · in I don't want to learn your query language

…where you roll your own on top of tightly scoped libraries. [0]: https://echo.labstack.com/ [1]: https://github.com/jmoiron/sqlx

comment by karanbhangui · 2018-07-14 · in Ask HN: What is the current state of web frameworks in Golang?

…. I don't use ORM, I use https://github.com/Masterminds/squirrel for query building and https://github.com/jmoiron/sqlx which helps deals with row<=>struct conversion. For database migrations, I use https://github.com/rubenv/sql-migrate ,…

comment by nostalgeek · 2018-07-14 · in Ask HN: What is the current state of web frameworks in Golang?

…(see their README). For talking with my DB, I just use sqlx (and sqlmock in my unit tests). https://github.com/jmoiron/sqlx https://github.com/DATA-DOG/go-sqlmock

comment by ereyes01 · 2018-07-14 · in Ask HN: What is the current state of web frameworks in Golang?

…[1] http://www.gorillatoolkit.org/ [2] https://github.com/gobuffalo/buffalo [3] https://github.com/jmoiron/sqlx [4] https://github.com/jinzhu/gorm [5] https://github.com/golang/go/wiki/SQLDrivers

comment by programd · 2018-03-08 · in Ask HN: Considering using Golang for my main language for web development

…isn't the kind of answer you were hoping for.) [1] https://github.com/julienschmidt/httprouter [2] https://github.com/jmoiron/sqlx [3] https://github.com/gorilla/websocket

comment by nishs · 2018-01-07 · in Show HN: A simple Go web server with logging, tracing, health check

…[3] https://github.com/flosch/pongo2 [4] https://github.com/CloudyKit/jet [5] https://github.com/jmoiron/sqlx [6] https://github.com/jinzhu/gorm [7] https://github.com/volatiletech/sqlboiler [8] https://github.com/gobuffalo/buffalo

comment by mdasen · 2017-12-05 · in Ask HN: What is your Golang web-dev tech stack?

…Metrics - https://github.com/prometheus/client_golang/prometheus SQL helper - https://github.com/jmoiron/sqlx OpenTracing - https://github.com/opentracing/opentracing-go

comment by programd · 2017-09-07 · in Ask HN: What Go framework for web API are you using in production?

…use https://github.com/Masterminds/squirrel or https://github.com/elgris/sqrl with database/sql or https://github.com/jmoiron/sqlx

comment by ptman · 2017-06-20 · in Macaron: a high productive and modular web framework in Go

…level structure, while go-kit helped me better understand good project structure. https://github.com/jmoiron/sqlx https://github.com/go-kit/kit

comment by Stoids · 2017-06-01 · in Ask HN: Good Go codebases to read?

Check out https://github.com/vattle/sqlboiler . I prefer the STD lib usually. Also, look at https://github.com/jmoiron/sqlx for easier struct mapping.

comment by sethammons · 2017-02-17 · in Go 1.8 Release Notes

…Go. The only other 3rd party package I routinely use is sqlx. http://www.gorillatoolkit.org/pkg/mux https://github.com/jmoiron/sqlx

comment by transitorykris · 2016-12-24 · in Writing web applications using only the Go Standard Library

If you are doing plain SQL in your golang app, I highly encourage you to check out sqlx: https://github.com/jmoiron/sqlx It has features like directly unpacking the results of a query into a structure. Very handy.

comment by ansible · 2016-11-10 · in Seven years of Go

…having to buy into a complexity risk. It's worth a look. [1] https://github.com/markbates/pop [2] https://github.com/jmoiron/sqlx [3] https://github.com/markbates/pop/tree/master/fizz

comment by mixedCase · 2016-10-27 · in Show HN: Rambler – A simple and language-independent SQL schema migration tool

Have you looked at https://github.com/jmoiron/sqlx It's a nice little wrapper around database/sql that offers some of the things you talk about.

comment by flexd · 2015-09-26 · in Utron: Go MVC framework for fast, scalable and robust database-driven web apps

sqlx ( https://github.com/jmoiron/sqlx ) is my go-to as well. mgutz/dat ( https://github.com/mgutz/dat ) and dbr ( https://github.com/gocraft/dbr ) are also more ORM-like alternatives if that's what you need—query builders with the option…

comment by elithrar · 2015-09-03 · in Porting Flask to Go – Jinja2 to Pongo2

…have been happily using this for a few months on a personal project. I really recommend looking at https://github.com/jmoiron/sqlx which is a library extending database/sql to simplify going from query->struct/slice and it also allows for…

comment by flexd · 2014-12-19 · in Pure Go Postgres driver for database/sql

…CRUD operations / queries ( https://github.com/jinzhu/gorm ) * sqlx - for more complex queries ( https://github.com/jmoiron/sqlx ) * apns - push notifications ( https://github.com/anachronistic/apns ) * gingorelic - New Relic integration (…

comment by nathan_f77 · 2014-11-19 · in Swift and Go: Building a Fast Future

I've found that https://github.com/jmoiron/sqlx (mentioned in the slides) works very well for SQL and mapping values to structs in Go. It's not an ORM though. You still write plain parameterized SQL queries, but mapping results to structs…

comment by martinp · 2014-10-05 · in A survey of the current state of Golang ORMs

…(with a keen understanding of its current shortcomings). [0] http://gin-gonic.github.io/gin/ [1] https://github.com/jmoiron/sqlx [2] https://github.com/jmoiron/modl

comment by themartorana · 2014-09-03 · in Django 1.7 Released

…on the database driver set on parse--and leans on the stdlib. This would tie in nicely with https://github.com/jmoiron/sqlx and its struct tag/marshaling behaviour. Access could be handled by a map[string]string, with the key as the…

comment by elithrar · 2014-08-04 · in What ORMs have taught me: just learn SQL

…Writing a little SQL never hurt anyone, and Go's SQL package is pretty good. Personally, I like http://github.com/jmoiron/sqlx - you have to write SQL statements still (I consider that a good thing), but it removes the boilerplate of…

comment by NateDad · 2014-04-26 · in A quick and easy way to setup a RESTful JSON API in Go

…It should be MUCH easier to make basic queries to SQL and get out results. I can highly recommend https://github.com/jmoiron/sqlx which allows you to easily unpack results into structs/maps, or pass in a struct/map and insert it (using…

comment by elithrar · 2014-01-27 · in A RESTful Micro-Framework in Go

…but it's an extension to sql that removes some of the most annoying boilerplate nevertheless. 1 = https://github.com/jmoiron/sqlx

comment by carbocation · 2014-01-26 · in A RESTful Micro-Framework in Go