Articles with the tag "PostgreSQL"

Connecting to a PostgreSQL database with Go's database/sql package

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.

Why we import SQL drivers as the blank identifier ( _ ) in Go

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.

Querying for records stored in a PostgreSQL table using SQL

This tutorial explains how to use the SELECT and WHERE statement to query data from a single SQL table.

Inserting records into a PostgreSQL database using SQL

A tutorial covering how to create records in a PostgreSQL database using the INSERT and VALUES commands in SQL.

Creating PostgreSQL databases and tables with raw 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.

How to install PostgreSQL 9.6 on Mac OS X (10.7 or later)

In this guide we walk through installing PostgreSQL 9.6 along with the command line tools on Mac OS X (10.7 or later).

Avatar of Jon Calhoun
Articles and Tutorials by
Jon Calhoun

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

Recent Articles All Articles Mini-Series Progress Updates Tags About Me Go Courses

©2018 Jonathan Calhoun. All rights reserved.