Dealing with SQL Queries in GoLang

In this post, I will share my notes on handling SQL queries in GoLang, especially complex queries. This is a work in progress, so I will continue to update my notes here.

A bit of background: I recently wrote a few straightforward microservices, such as user management, notifications, and comments, which require interaction with a PostgreSQL database for CRUD operations.

While this approach works initially, diving deeper into the code reveals raw SQL queries. This might be acceptable for now, but as requirements expand, it becomes problematic for developers to write increasingly complex and repetitive code. For example:

  • Query to get a user by ID
  • Query to get a user by email
  • Query to get a user by zip-code
  • Query to get users by creation date
  • Query to get users by password expiration date


To address this issue, the first step is to search GitHub for an ORM similar to Gorilla Mux in routing. If you have experience with Python Django or Java, you might be tempted to find something similar.

I have already explored many GitHub repositories but haven’t been convinced by the solutions offered. Many repositories provide SQL query builders, which I am still analyzing. Since I am working on a critical project, I might create my own SQL query builder and map query results to models.

In the meantime, I found this insightful post:


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s