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, |