This tutorial explains how to connect to a Postgres DB using the database/sql and lib/pq packages. It also covers potential errors and solutions.
When I first started writing Go code I was working on a relatively simple web application backed by an SQL database, so the first thing I did was Google “golang sql” which lead me to to the database/sql package. While reading those docs I notice this line in particular. The sql package must be used in conjunction with a database driver. See https://golang.org/s/sqldrivers for a list of drivers.
This tutorial explains how to use the SELECT and WHERE statement to query data from a single SQL table.
A tutorial covering how to create records in a PostgreSQL database using the INSERT and VALUES commands in SQL.
Creating your first database and tables using raw SQL and PostgreSQL. You will also use some basic types and constraints like int, NOT NULL, and UNIQUE.
In this guide we walk through installing PostgreSQL 9.6 along with the command line tools on Mac OS X (10.7 or later).
Jon Calhoun is a full stack web developer who also teaches about Go, web development, algorithms, and anything programming related. He also consults for other companies who have development needs. (If you need some development work done, get in touch!)
Jon is a co-founder of EasyPost, a shipping API that many fortune 500 companies use to power their shipping infrastructure, and prior to founding EasyPost he worked at google as a software engineer.
Jon's latest progress update: Writing Course Notes
©2018 Jonathan Calhoun. All rights reserved.