Home » SQLite Go

SQLite Go

You organize your data. Now organize your savings.

Set savings goals, track your progress, and stay on course.

Get Savigo for iPhone

This tutorial series guides you on interacting with SQLite databases using the Go (Golang) programming language.

Prerequisites #

Basic Go Programming Language. Check out this Go tutorial if you need a refresher.
SQLite operations include creating tables, inserting, updating, deleting, and querying data.
The sqlite3 shell to connect to SQLite databases.

Section 1. Getting Started #

In this section, you’ll start by connecting to an SQLite database from a Go app and learn how to create new tables.

Connecting to an SQLite database – Create a new SQLite database or connect to an existing one in Go.
Creating tables – Create a new table in SQLite databases from Go.

Section 2. Performing Database Operations #

This section shows you how to insert, update, retrieve, and delete data from SQLite databases in Go.

Inserting data into a table – Insert one or more rows into a table from a Go app.
Updating data in a table – Update data in a table in Go.
Deleting data from a table – Delete data from a table from a Go app.
Import CSV file into a table – Read a CSV file and load data into a table in Go
Selecting data from a table – Show you how to select data from a table using Go.

Section 3. Managing Transactions #

This section shows you how to manage transactions in SQLite in Go.

Transaction – Perform a database transaction in SQLite database from Go apps.

Was this tutorial helpful?