Accessing SQL Databases

Examine how to connect, access, and edit SQL and Postgres databases in Go.

We'll cover the following

Connecting to a Postgres database
Querying a Postgres database
Null values
Writing data to Postgres
Transactions
Postgres-specific types
Other options
Storage abstractions

DevOps engineers commonly have a need to access data stored in database systems. SQL is a standard for communicating with database systems that a DevOps engineer will encounter in their day-to-day lives.

Go provides a standard library for interacting with SQL-based systems called database/sql. The interfaces provided by that package, with the addition of a database driver, allow a user to work with several different SQL databases. In this lesson, we’ll look at how we can access a Postgres database to perform basic SQL operations using Go.

Get hands-on with 1400+ tech skills courses.

Introduction to the Course

Go Language Basics

Go Language Essentials

Filesystem Interactions

Using Common Data Formats

Interacting with Remote Data Sources

Writing Command-Line Tooling

Automating Command-Line Tasks

Observability with OpenTelemetry

Automating Workflows with GitHub Actions

Using ChatOps to Increase Efficiency

Creating Immutable Infrastructure Using Packer

Infrastructure as Code with Terraform

Deploying and Building Applications in Kubernetes

Programming the Cloud

Designing for Chaos

Appendix

Conclusion

Accessing SQL Databases