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
sqlite3shell 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 ?
