VeryFatBoy

import pandas as pd
import geopandas as gpd
from shapely import wkt
import time

# Read pub points from CSV to a pandas dataframe
pubs = pd.read_csv('~/Documents/pub_points.csv',
                   header=None, names=['name', 'coordinates'])

# Parse the WKT coordinate format from PostGIS

VeryFatBoy

version: '2'

services:
  memsql:
    image: 'memsql/cluster-in-a-box'
    ports:
      - 3306:3306
      - 8080:8080
    environment:
      LICENSE_KEY: ${LICENSE_KEY}

VeryFatBoy

# A deployment ensures pod(s) are restarted on failure
apiVersion: apps/v1
kind: Deployment
metadata:
  name: memsql
spec:
  replicas: 1 # only create one pod (container)
  selector:
    matchLabels:
      app: memsql

VeryFatBoy

CREATE DATABASE hellomemsql;

USE hellomemsql;

CREATE TABLE test (
  message text NOT NULL
);

INSERT INTO test (message) VALUES ('this is a sample message');
 

VeryFatBoy

Vagrant.configure("2") do |config|
  config.vm.box = "generic/ubuntu1904"

  # set the provider
  config.vm.provider "virtualbox"
  # configure the provider
  config.vm.provider "virtualbox" do |v|
    v.cpus = 4
    v.memory = 4096
  end

VeryFatBoy

apiVersion: apps/v1
kind: Deployment
metadata:
  name: myapp
  labels:
    app: myapp
spec:
  replicas: 3
  template:
    metadata:

VeryFatBoy

apiVersion: apps/v1
kind: Deployment
metadata:
  name: memsql-operator-envvar
  namespace: memsql
spec:
  replicas: 1
  selector:
    matchLabels:
      name: memsql-operator-envvar

VeryFatBoy

VeryFatBoy

VeryFatBoy

-- create a database
create database cosmeticshop;

-- create a table
use cosmeticshop;
create table cosmeticshopfunnel
(
    event_time TIMESTAMP,
    event_type CHAR(18),
    product_id CHAR(10),