Skip to content

Connect a Go App to ReadySet

Once you have a ReadySet instance up and running, you connect your application to ReadySet exactly as you would to the upstream database.

This page gives you an example for the Go pgx driver.

Step 1. Start ReadySet

  1. Install and start Docker Compose for your OS.

  2. Download our Docker Compose and sample data files and start up Postgres and ReadySet locally:

    curl -O "{docker-compose-postgres.yml,imdb-postgres.sql}"
    docker-compose -f docker-compose-postgres.yml up -d

    This also imports two tables from the IMDb dataset that you'll query from your app.

Step 2. Get the code

  1. Create a directory for the code and move into it:

    mkdir readyset-pgx && cd readyset-pgx
  2. Download the sample code:

    curl -O ""

    Or create the following file yourself:

    package main
    import (
    func main() {
        ctx := context.Background()
        connStr := os.Getenv("DATABASE_URL")
        conn, err := pgx.Connect(ctx, connStr)
        if err != nil {
        defer conn.Close(ctx)
        var (
            year int = 1980
            title string
            rating float32
        rows, err := conn.Query(ctx, 
            `SELECT title_basics.originaltitle, title_ratings.averagerating
            FROM title_basics
            JOIN title_ratings ON title_basics.tconst = title_ratings.tconst
            WHERE title_basics.startyear = $1
            AND title_basics.titletype = $2
            AND title_ratings.numvotes > $3
            ORDER BY title_ratings.averagerating DESC LIMIT 10`, 
            year, "movie", 50000)
        if err != nil {
        defer rows.Close()
        log.Println("Year:", year)
        for rows.Next() {
            err := rows.Scan(&title, &rating)
            if err != nil {
            log.Println(title, rating)
        err = rows.Err()
        if err != nil {

Step 3. Install dependencies

Initialize the module:

go mod init basic-sample && go mod tidy

Step 4. Connect and query

  1. Set the DATABASE_URL environment variable to the connection string for ReadySet:

    export DATABASE_URL="postgresql://postgres:readyset@"


    ReadySet takes the same standard-format connection string as Postgres.

    In this case, since both ReadySet and Postgres are running locally, only the port portion is different (5433 for ReadySet, 5432 for Postgres).

  2. Run the code:

    go run main.go

    The code connects to ReadySet and then executes a query that joins results from two tables to get the title and average rating of the 10 top-rated movies with over 50,000 votes from 1980.

    Year: 1980
    The Empire Strikes Back 8.7
    The Shining 8.4
    Raging Bull 8.2
    The Elephant Man 8.2
    The Blues Brothers 7.9
    Airplane! 7.7
    Ordinary People 7.7
    The Gods Must Be Crazy 7.3
    Caddyshack 7.2
    Superman II 6.8


    Since the query has not been cached in ReadySet, ReadySet proxies the query and returns the results from Postgres. After the query is cached, ReadySet returns the results directly and blazing fast!

Next steps