Articles with the tag "PostgreSQL"

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).