The application connects to your YugabyteDB instance via
Go PostgreSQL driver pgx and performs basic SQL
operations. The instructions below are provided for local deployments Yugabyte Docs for single node or Yugabyte Docs for local multi-node. If you use a different type of deployment, then update the sample-app.go
file with proper connection parameters.
This example was adapted from the pq example.
- Go version 1.19.4 or later is preferred. Earlier versions should work as well.
- Command line tool or your favorite IDE, such as VSCode.
Clone the application to your machine:
git clone https://github.com/dataindataout/yugabyte-simple-go-app.git && cd yugabyte-simple-go-app
Open the main.go
file and specify the following configuration parameters:
host
- the hostname of your instance.port
- the port number of your instance (the default is5433
).dbUser
- the username for your instance.dbPassword
- the database password.sslMode
- the SSL mode. Set toverify-full
for YugabyteDB Managed deployments.sslRootCert
- a full path to your CA root cert if used (for example,/Users/ybme/certificates/root.crt
)
-
Import the required packages:
go mod tidy
-
Run the application:
go run main.go
Upon successful execution, you will see output similar to the following:
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
Congrats! You've successfully executed a simple Go app that works with YugabyteDB.
Now, explore the source code of main.go
:
main
function - establishes a connection with your cloud instance via the Go PostgreSQL driver pgx.createDatabase
function - creates a table and populates it with sample data.selectAccounts
function - queries the data with SQLSELECT
statements.transferMoneyBetweenAccounts
function - updates records consistently with distributed transactions.
Having issues running this application or want to learn more from Yugabyte experts?
Join our Slack channel,
or raise a question on StackOverflow and tag the question with yugabytedb
!