How to Retrieve CockroachDB Record using Golang Web App

Introduction

Retrieving records from a database can be challenging sometimes, but it doesn’t have to become a stressful way of life. There’s a simpler way to retrieve CockroachDB record Golang. Find cockroachDB record Golang. Try creating an uncomplicated web app that utilizes the Go Postgres (package pg) driver. This tutorial will show you how to retrieve CockroachDB record using Golang web app. Every step is important. Follow along to make your coding more efficient and stress-free.

Skip to Just the Code to review the sample script in its entirety if you want to bypass this tutorial because you already know how to search CockroachDB Golang and fetch data from CockroachDB Golang.

Prerequisites

• Download and install the latest Go language binary release for your OS.

• Download and install the CockroachDB database.

• Use the go command to verify that the correct Go language version is installed on your OS.

• Here’s an example of what the result should resemble if you installed the Go language on a Linux OS.

Begin a local cluster in CockroachDB

• Begin with a CockroachDB local cluster in order to communicate with CockroachDB.

Here’s what the different parts of the code indicate:

• The flag --insecure means unencrypted communication.

• The --listen-addr=localhost:26257 specifically states the localhost port “26257” is the only port to which the node is to listen.

• The --http-addr=localhost:8080 precisely states the localhost 8080 is for HTTP requests.

• In your terminal, the result should resemble this:

• Now you can open a new terminal to make a CockroachDB instance connection. Use the code below:

• You should see a result similar to this one:

Make a database sample to test the examples of code

• Since the connection to the CockroachDB instance was successful, you can go ahead and create a database sample to run the examples in this tutorial.

• Make a new user’s name “yeshua”.

• Call the sample database “restaurants”.

• Declare the SQL SELECT DATABASE = restaurants; statement to access and use the database.

• Give database permission to read and write to the “yeshua” user.

• Use a SQL statement and create a basic table and name it “tblerestaurants”.

• Next, add a few records to the table you just created.

• Type q to exit the SQL terminal shell when finished.

Connect the Go pq driver

You’re ready to connect the CockroachDB database and the Go pq driver.

• Add to your project directory a new file. Name it main.go. * >NOTE: Be sure the file has the extension “.go”.

Properly compile the package main

• Make as an executable program the package main. Use a script in the Go language to compile it correctly.

>NOTE: If you compile the package main as a shared library, it won’t work out right.

Download dependencies

• Import the required dependencies using the Go language.

Here’s an explanation of the code for importing dependences:

• To use SQL databases and those databases like SQL in Go, use database/sql.

• Similar to the Print() function is the fmt function. It formats as I/O.

• You’ll be able to make API calls to the HTTP server and client with the package net/http.

• The package database/sql requires the Postgres driver package "github.com/lib/pq" for Go. You can load it without the names showing up in the code by using the underscore _ at the beginning of the line of code.

>NOTE: Make your code driver nondependent by only using driver packages named within database/sql.

Use struct to create fields that match the database table

*Using Go lang’s struct is the way to create named properties or fields that are the same as the newly created table, tblrestaurants.

Connect the database

• Everything is on track. You’ve successfully imported dependencies, created matching fields using Go lang’s struct command. Next, let’s connect to the CockroachDB database.

• Obtain global usage inside the package by making the “db” global package level variable.

• A fast way to make database connections seamlessly is to use the init() function. You just need to call it one time.

• Use sql.open to access a connection.

• Next, check for any raised errors with db.

• The func main() verifies if the database connection worked. You can learn more about that script later in this tutorial.

• Save your project.

• Open a new terminal window.

• Locate your project directory.

• Run the Go lang main.go command.

• You should see a similar result like this one:

Retrieve CockroachDB record Golang

• The code below starts with restoIndex. You’ll be writing a long script that requires a few steps to search CockroachDB Golang and fetch data from CockroachDB Golang, but in the end, it will be worth it. Take your time to read the script and then continue to the explanation that follows for a clearer understanding.

Here’s an explanation of the above code:

• Verified that GET is not the r.Method.

• A “Method Not Allowed” error or 405 error is returned.

• Took db.Query("SELECT * FROM tblrestaurants") and assigned rows.

• Checked for errors

• An “Internal Server Error” is returned.

• Deallocated resources by deferring rows.Close().

• Made a slice and assigned the restos := make([]Restaurant, 0) variable.

• Completed iterations with rows.Next().

• Copied the current row’s column with rows.Scan().

>NOTE: See the example table below for referencing the order of the database table.

Details of the func main() function

• The point of entry of the script is func main(). Let’s dive into the details of this important function.

• The first parameter is the string and the second parameter is the function when you use http.HandleFunc() method in the above script.

>NOTE: You can just pass the function’s name when using the method http.HandleFunc() to pass a second parameter to it. You’ll want to pass the function as a callback function by eliminating the parentheses.

(1) It states that “/restaurants” prefixed URLS is what it will only handle. The name of the function in the HTTP request is restoIndex.

(2) The port “9090” is the assigned port.

• It’s time to go to a window terminal and retest the code. Locate your project directory folder. Use the main.go command.

• Open a browser window and enter this URL in the address bar: localhost:9090/restaurants

• The results should look similar to this:

Conclusion

Congratulations! You’ve successfully finished this tutorial on how to retrieve CockroachDB record using Golang via web app. Today, you created a test database and table with retrievable records. You also connected the Go Postgres driver that enables communication between applications. Now you’re ready to fetch data from CockroachDB Golang correctly and confidently. Use the process outlined in this tutorial in your projects often.

Just The Code

Here’s the complete sample code for your reference on how to retrieve CockroachDB record Golang. Find cockroachDB record Golang.