Skip to content

Instantly share code, notes, and snippets.

View AlexRogalskiy's full-sized avatar
🛰️
Work on stuff that matters

Alexander AlexRogalskiy

🛰️
Work on stuff that matters
View GitHub Profile
@AlexRogalskiy
AlexRogalskiy / singlestore-to-gcs.sql
Created August 9, 2021 14:22 — forked from robrich/singlestore-to-gcs.sql
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
);

Making Kubernetes How We Build Things

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.

@AlexRogalskiy
AlexRogalskiy / singlestore-to-s3.sql
Created August 10, 2021 06:05 — forked from robrich/singlestore-to-s3.sql
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
);
@AlexRogalskiy
AlexRogalskiy / sproc-delimiter.sql
Created August 10, 2021 06:05 — forked from robrich/sproc-delimiter.sql
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
);
@AlexRogalskiy
AlexRogalskiy / select-into-var.sql
Created August 10, 2021 06:06 — forked from robrich/select-into-var.sql
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
);
@AlexRogalskiy
AlexRogalskiy / data-load.sql
Created August 10, 2021 06:06 — forked from robrich/data-load.sql
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),
@AlexRogalskiy
AlexRogalskiy / sql-to-json.sql
Created August 10, 2021 06:06 — forked from robrich/sql-to-json.sql
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 ()
@AlexRogalskiy
AlexRogalskiy / universal-storage-7.3.sql
Created August 10, 2021 06:06 — forked from robrich/universal-storage-7.3.sql
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. */
@AlexRogalskiy
AlexRogalskiy / time-series.sql
Created August 10, 2021 06:07 — forked from robrich/time-series.sql
time-series.sql
-- 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,