rinha-backend-2024

ScyllDB

Deploy

docker-compose up

docker exec -it scylla-node1 nodetool status

CQLSH

docker exec -it scylla-node1 cqlsh

Keyspace

DROP KEYSPACE rinha_db;

CREATE KEYSPACE rinha_db
WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};
       
USE rinha_db;

Table

CREATE TABLE IF NOT EXISTS conta_lock (
   id INT,
   time TIMESTAMP,
   primary key (id)
) WITH default_time_to_live = 6000;

CREATE TABLE IF NOT EXISTS conta (
    id INT,
    limite INT,
    saldo_inicial INT,
    version INT,
    primary key (id)                   
);

CREATE TABLE IF NOT EXISTS transaction_history (
    id UUID,
    account_id INT,
    amount INT,
    type TEXT,
    description TEXT,
    created_at TIMESTAMP,
    primary key ((account_id), id, created_at)
) WITH CLUSTERING ORDER BY (id DESC, created_at DESC);

Insert

INSERT INTO conta (id, limite, saldo_inicial, version) VALUES (1, 100000, 0, 1);
INSERT INTO conta (id, limite, saldo_inicial, version) VALUES (2, 80000, 0, 1);
INSERT INTO conta (id, limite, saldo_inicial, version) VALUES (3, 1000000, 0, 1);
INSERT INTO conta (id, limite, saldo_inicial, version) VALUES (4, 10000000, 0, 1);
INSERT INTO conta (id, limite, saldo_inicial, version) VALUES (5, 500000, 0, 1);


INSERT INTO conta_lock (id, time) VALUES (1, toTimestamp(now())) IF NOT EXISTS;

Select*

SELECT * FROM conta where id = 1;

SELECT * FROM conta;

Api

config fiber rota clientes transacoes
Usecase clientes transacoes
Repository clientes transacoes scyllaDB
Repository extrato e api
github actions docker
env docker para banco
implementar traefik loadbalecer
testar a aplicacao com gattling
entregar o projeto para rinha

fernandosvrosa/rinha-backend-2024

rinha-backend-2024

ScyllDB

Deploy

CQLSH

Keyspace

Table

Insert

Select*

Api