
:kill-pane

cargo build

cargo test


rm -rf db_demo

cargo run --bin server -- 

cargo run --bin server -- --folder db_demo

rlwrap cargo run --bin client --


======================Games Table========================================

SELECT * FROM games;


REATE TABLE games (id UUID PRIMARY KEY, name STRING, year INT, price NUMBER);

INSERT INTO games (id, name, year, price) VALUES (u1, "skyrim", 2011, 1024.5);

INSERT INTO games (id, name, year, price) VALUES (u2, "DOOM 2", 1994, 350.0);

DELETE FROM games;

WHERE name = "Christina";

SELECT * FROM games;

SELECT * FROM games WHERE id=u2;

SELECT * FROM games WHERE name="skyrim";

SELECT name, year, year, year, name FROM games;


SELECT * FROM games WHERE id=u3;

===================Users Table======================
// Optionals


CREATE TABLE users (id UUID PRIMARY KEY, name STRING, surname STRING, email Option(STRING));


INSERT INTO users (id, name, surname, email) VALUES (u1, "Hero", "Protagonist 😊", Some("snow_crash@gmail.com"));



INSERT INTO users (id, name, surname, email) VALUES (u26, "Arnold", "schwarzenegger", Some("gettothechoppa@yahoo.com"));

INSERT INTO users (id, name, surname, email) VALUES (u27, "Arnold", "Vosloo", None);


INSERT INTO users (id, name, surname, email) VALUES (u29, "New", "Guy", None);


"hello" : String

Some("hello") : Option(String)

None : Option(String)


SELECT * FROM users;


SELECT * FROM users WHERE email=None;

SELECT * FROM users WHERE email=Some("gettothechoppa@yahoo.com");



DELETE FROM users WHERE id=u1;

DELETE FROM users WHERE id=u27;


CREATE TABLE users1 (id UUID PRIMARY KEY, name STRING, surname STRING, email Option(Option(STRING)));

INSERT INTO users1 (id, name, surname, email) VALUES (u1, "Hero", "Protagonist 😊", None);

INSERT INTO users1 (id, name, surname, email) VALUES (u26, "Arnold", "schwarzenegger", Some(Some("gettothechoppa@yahoo.com")));

SELECT * FROM users1;

SELECT * FROM users1 WHERE email=None;

DELETE FROM users;

// ==============Indexes, Concurrency, Garbage Collection================



CREATE INDEX CarsYear ON cars (year);



