This talk is all live demos of tools developers can use in their inner-loop, at development time to be more productive with containers.
Docker Compose captures the build arguments and run arguments so we can focus on our coding.
| CREATE DATABASE IF NOT EXISTS acme; | |
| USE acme; | |
| CREATE TABLE IF NOT EXISTS messages ( | |
| id BIGINT AUTO_INCREMENT PRIMARY KEY, | |
| content varchar(300) NOT NULL, | |
| createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP | |
| ); |
| CREATE DATABASE IF NOT EXISTS acme; | |
| USE acme; | |
| CREATE TABLE IF NOT EXISTS messages ( | |
| id BIGINT AUTO_INCREMENT PRIMARY KEY, | |
| content varchar(300) NOT NULL, | |
| createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP | |
| ); |
| CREATE DATABASE IF NOT EXISTS acme; | |
| USE acme; | |
| CREATE TABLE IF NOT EXISTS messages ( | |
| id BIGINT AUTO_INCREMENT PRIMARY KEY, | |
| content varchar(300) NOT NULL, | |
| createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP | |
| ); |
| CREATE DATABASE IF NOT EXISTS acme; | |
| USE acme; | |
| CREATE TABLE IF NOT EXISTS messages ( | |
| id BIGINT AUTO_INCREMENT PRIMARY KEY, | |
| content varchar(300) NOT NULL, | |
| createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP | |
| ); |
| create database maps; | |
| use maps; | |
| create table countries ( | |
| boundary geography, | |
| name_short varchar(3), | |
| name varchar(50), | |
| name_long varchar(50), | |
| abbrev varchar(10), | |
| postal varchar(4), |
| -- Create database | |
| create database if not exists acme; | |
| use acme; | |
| -- Create table | |
| create rowstore table `record` ( | |
| `name` varchar(100) DEFAULT NULL, | |
| `type` varchar(100) DEFAULT NULL, | |
| `amount` int(11) DEFAULT NULL, | |
| SHARD KEY () |
| create database db1; | |
| use db1; | |
| create table t(a int not null, shard(a), sort key()); | |
| insert t values(1); | |
| delimiter // | |
| /* Fill table t with n or more rows, doubling the size until | |
| the goal is reached. */ |
| -- TIME SERIES | |
| -- =========== | |
| -- setup schema | |
| CREATE DATABASE temp_history; | |
| USE temp_history; | |
| CREATE TABLE temperatures ( | |
| location VARCHAR(200) NOT NULL, |
| -- FULL TEXT SEARCH | |
| -- ================ | |
| -- setup schema | |
| CREATE DATABASE library; | |
| USE library; | |
| CREATE TABLE books ( | |
| title VARCHAR(200) not null, |