Articles with the tag "PostgreSQL"

What is SQL injection and how do I avoid it in Go?

SQL injection is a method used by hackers to attempt to trick your code into running arbitrary (read - REALLY BAD) queries on your database.

Querying for multiple records with Go's sql package

Learn how to query for multiple records using Go's database/sql package by querying for several users in a users table.

Querying for a single record using Go's database/sql package

In this article we cover how to query for a single record using Go's database/sql package, including handling the ErrNoRows error.

Updating and Deleting records stored in a PostgreSQL table using SQL

A short tutorial that teaches how to update and delete records stored in an SQL database table using raw SQL statements.

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.

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.