Category: Go

Written by Ian

Go: Storing Database Credentials in Environment Variables

A sensible default is not to hard code Database credentials in your source code. One alternative is to use Environment Variables which provide a low-friction method for managing sensitive data. In this post I will walk through the process of creating Environment Variables to store Postgres Database connection details and accessing them from Go. Version […]

Written by Ian

Go with Oracle Database – SQL Queries

This post will demonstrate how to connect to an Oracle database from Go using the Go DRiver for ORacle (godror) and execute SQL Queries. The code in this post is up on GitHub and was developed using Go 1.20.6 & VS Code running on Windows 10. I used a local version of the Oracle Database […]

Written by Ian

Go: Excel to CSV

In this post I will demonstrate how to save all the worksheets within a Microsoft Excel file into individual CSV files using Excelize and the CSV functionality in the Standard Library. The code shown in this post can be found on GitHub and was developed using Go 1.20.5, Visual Studio Code with the Go Extension. […]

Written by Ian

First Unit Test in Go with VS Code

This post will show you how to write a Unit Test in Go using VS Code. All the code examples can be found up on GitHub. Setup Create a new directory using a name of your choice and then open the directory in VS Code. Start the Integrated Terminal and create a new module using […]