Getting started
Use the SQLite Cloud Client SDK in your Go code
Import the package in your Go source code:
import sqlitecloud "github.com/sqlitecloud/go-sdk"
Download the package, and run the
go mod tidy
command to synchronize your module's dependencies:$ go mod tidy go: downloading github.com/sqlitecloud/go-sdk v1.0.0
Connect to a SQLite Cloud database with a valid connection string:
db, err := sqlitecloud.Connect("sqlitecloud://user:pass@host.sqlite.cloud:port/dbname")
Execute queries using a method defined on the
SQCloud
struct, for exampleSelect
:result, _ := db.Select("SELECT * FROM table1;")
The following example shows how to print the content of the table table1
:
package main
import (
"fmt"
"strings"
sqlitecloud "github.com/sqlitecloud/go-sdk"
)
const connectionString = "sqlitecloud://admin:password@host.sqlite.cloud:8860/dbname.sqlite"
func main() {
db, err := sqlitecloud.Connect(connectionString)
if err != nil {
fmt.Println("Connect error: ", err)
}
tables, _ := db.ListTables()
fmt.Printf("Tables:\n\t%s\n", strings.Join(tables, "\n\t"))
fmt.Printf("Table1:\n")
result, _ := db.Select("SELECT * FROM t1;")
for r := uint64(0); r < result.GetNumberOfRows(); r++ {
id, _ := result.GetInt64Value(r, 0)
value, _ := result.GetStringValue(r, 1)
fmt.Printf("\t%d: %s\n", id, value)
}
}
Get a connection string
You can connect to any cloud database using a special connection string in the form:
sqlitecloud://user:pass@host.com:port/dbname?timeout=10&key2=value2&key3=value3
To get a valid connection string, follow these instructions:
- Get a SQLite Cloud account. See the documentation for details.
- Create a SQLite Cloud project
- Create a SQLite Cloud database
- Get the connection string by clicking on the node address in the Dashboard Nodes section. A valid connection string will be copied to your clipboard.
- Add the database name to your connection string.
API Documentation
The complete documentation of the sqlitecloud/go-sdk library is available at: https://pkg.go.dev/github.com/sqlitecloud/go-sdk