dmagda

"Movies Recommendations"

client.sql(
    "SELECT id, title, overview, vote_average " +
    "FROM movie WHERE vote_average >= 7 " +
    "AND genres @> \'[{\"name\": \"Science Fiction\"}]\'" +
    "AND 1 - (overview_vector <=> :prompt_vector::vector) >= 0.7 " +
    "ORDER BY overview_vector <=> :prompt_vector::vector LIMIT 3")
 .param("prompt_vector", promptEmbedding.toString())

dmagda

Create a custom Docker network:

docker network create custom-network

Start YugabyteDB:

rm -r ~/yb_docker_data
mkdir ~/yb_docker_data

dmagda

orders = jdbcTemplate.query(
    "SELECT * FROM pizza_order WHERE id = ? and location = ?::store_location",
    (prepStmt) -> {
        prepStmt.setInt(1, id);
        prepStmt.setString(2, location);
    },
    new OrderRowMapper());

dmagda

1. Stop all the K3s processes:

   sudo kill $(ps aux | grep 'k3s' | awk '{print $2}')

2. Create the k3s_uninstall.sh script with the following content and execute it:

   #!/bin/sh
   set -x
   systemctl stop k3s

systemctl disable k3s

dmagda

Start YugabyteDB Instance

rm -r ~/yb_docker_data
mkdir ~/yb_docker_data

docker network create custom-network

docker run -d --name yugabytedb_node1 --net custom-network \
  -p 15433:15433 -p 7001:7000 -p 9000:9000 -p 5433:5433 \

dmagda

                StringBuilder queryString = "insert into test (id, f1) values ";
                
                // add placeholder for values
                for (int counter = 0; counter <= 100; counter += 1) 
                    queryString.append("(?, ?),");

                // replace the trailing ',' with a ';'
                queryString.replace(queryString.length() - 1, queryString.length(), ";");

dmagda

/*******************************************************************************
   Chinook Database - Version 1.4
   Script: Chinook_PostgreSql.sql
   Description: Creates and populates the Chinook database.
   DB Server: PostgreSql
   Author: Luis Rocha
   License: http://www.codeplex.com/ChinookDatabase/license
********************************************************************************/

dmagda

Nested Loop Join

// Loading records that satisfy the WHERE predicate.
// Can be an index or full table scan.
var subsetTable1 = getData(table1, wherePredicate);
var subsetTable2 = getData(table2, wherePredicate);

var resultSet = new LinkedList();

dmagda

YugabyteDB Outage Demo

Use this demo to showcase how YugabyteDB handles failures.

Start Cluster

Create the custom network:

docker network create custom-network

dmagda

Mock data generation with built-in database capabilities

Relational databases such as PostgreSQL can do much more than store and return your application records. Those databases usually come with comprehensive compute capabitilies.

In this short note, let's review the generate_series function of PostgreSQL, then can generate mock data of various complexity.

1. Create a sample table for time-series data:

   create table sensor (
     id int,