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 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 teaches about Go, web development, algorithms, and anything programming. If you haven't already, you should totally check out his Go courses.

Previously, Jon worked at several statups including co-founding EasyPost, a shipping API used by several fortune 500 companies. Prior to that Jon worked at Google, competed at world finals in programming competitions, and has been programming since he was a child.

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

©2018 Jonathan Calhoun. All rights reserved.