GoLang Tutorial - SQLite
Among many database drivers for SQLite in Go, in this post, we'll use github.com/mattn/go-sqlite3 which supports database/sql interface standards in its SQLite driver.
The package can be installed with the go get command:
$ go get github.com/mattn/go-sqlite3 $ export CGO_ENABLED=1
Because it is a CGO enabled package we are required to set the environment variable CGO_ENABLED=1 and have a gcc compile present within our path. Note CGO enables the creation of Go packages that call C code.
We're going to create and open a local database (bogo.db) using the sqlite3 driver for Go. As mentioned earlier, we are using the database/sql API with the go-sqlite3 driver.
Here is the code:
The code: sql-1.go
In the code, we use the Prepare(), Exec(), and Query() functions to interact with the database.
We're creating a new SQLite table with three columns if it doesn't already exist. Then, we are using a parameterized query to insert hard-coded data into the database. Once we have data in the database, we can query for it and loop through the results.
Go Tutorial
- GoLang Tutorial - HelloWorld
- Calling code in an external package & go.mod / go.sum files
- Workspaces
- Workspaces II
- Visual Studio Code
- Data Types and Variables
- byte and rune
- Packages
- Functions
- Arrays and Slices
- A function taking and returning a slice
- Conditionals
- Loops
- Maps
- Range
- Pointers
- Closures and Anonymous Functions
- Structs and receiver methods
- Value or Pointer Receivers
- Interfaces
- Web Application Part 0 (Introduction)
- Web Application Part 1 (Basic)
- Web Application Part 2 (Using net/http)
- Web Application Part 3 (Adding "edit" capability)
- Web Application Part 4 (Handling non-existent pages and saving pages)
- Web Application Part 5 (Error handling and template caching)
- Web Application Part 6 (Validating the title with a regular expression)
- Web Application Part 7 (Function Literals and Closures)
- Building Docker image and deploying Go application to a Kubernetes cluster (minikube)
- Serverless Framework (Serverless Application Model-SAM)
- Serverless Web API with AWS Lambda
- Arrays vs Slices with an array left rotation sample
- Variadic Functions
- Goroutines
- Channels ("<-")
- Channels ("<-") with Select
- Channels ("<-") with worker pools
- Defer
- GoLang Panic and Recover
- String Formatting
- JSON
- SQLite
- Modules 0: Using External Go Modules from GitHub
- Modules 1 (Creating a new module)
- Modules 2 (Adding Dependencies)
- AWS SDK for Go (S3 listing)
- Linked List
- Binary Search Tree (BST) Part 1 (Tree/Node structs with insert and print functions)
- Go Application Authentication I (BasicAuth, Bearer-Token-Based Authentication)
- Go Application Authentication II (JWT Authentication)
Ph.D. / Golden Gate Ave, San Francisco / Seoul National Univ / Carnegie Mellon / UC Berkeley / DevOps / Deep Learning / Visualization
My YouTube channel