Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@robrich
robrich / README.md
Last active July 24, 2023 12:06
the definitive deep dive into the .git folder

the definitive deep dive into the .git folder

Thanks for joining us for "the definitive deep dive into the .git folder". It's an incredible live-demo where we open every file in the .git folder and show what it does.

Links

Here's the links we saw:

Local Development Techniques with Kubernetes

This talk is all live demos of tools developers can use in their inner-loop, at development time to be more productive with containers.

Start Easier

Docker Compose captures the build arguments and run arguments so we can focus on our coding.

@robrich
robrich / singlestore-to-gcs.sql
Created March 25, 2021 02:05
SingleStore to Google Cloud Storage
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
);
@robrich
robrich / singlestore-to-s3.sql
Created March 23, 2021 04:45
SingleStore to AWS S3
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
);
@robrich
robrich / sproc-delimiter.sql
Created February 17, 2021 21:19
SingleStore Stored Procedures
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
);
@robrich
robrich / select-into-var.sql
Created February 16, 2021 00:13
SQL Programmability with variables in SingleStore
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
);
@robrich
robrich / data-load.sql
Created January 22, 2021 19:21
Loading Geography Data into SingleStore
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),
@robrich
robrich / sql-to-json.sql
Created January 5, 2021 01:07
Select relational data into JSON with SingleStore: to_json() and json_agg()
-- 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 ()
@robrich
robrich / universal-storage-7.3.sql
Created December 15, 2020 23:22
Universal Storage in 7.3
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. */
@robrich
robrich / time-series.sql
Created October 12, 2020 19:34
time-series.sql
-- TIME SERIES
-- ===========
-- setup schema
CREATE DATABASE temp_history;
USE temp_history;
CREATE TABLE temperatures (
location VARCHAR(200) NOT NULL,