VeryFatBoy

CREATE DATABASE IF NOT EXISTS rcte_demo;

USE rcte_demo;

CREATE TABLE IF NOT EXISTS stations_route (
    station_from VARCHAR(22),
    station_to   VARCHAR(22),
    distance     NUMERIC(4,2)
);

VeryFatBoy

DROP DATABASE IF EXISTS e_store;

CREATE DATABASE IF NOT EXISTS e_store
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;

USE e_store;

CREATE TABLE brands (
     id INT UNSIGNED NOT NULL AUTO_INCREMENT,

VeryFatBoy

CREATE DATABASE iris_db;

USE iris_db;

CREATE TABLE iris (
    sepal_length FLOAT,
    sepal_width FLOAT,
    petal_length FLOAT,
    petal_width FLOAT,
    species VARCHAR(20)

VeryFatBoy

VeryFatBoy

CREATE DATABASE IF NOT EXISTS iris_db;

USE iris_db;

CREATE TABLE IF NOT EXISTS iris (
     vector BLOB,
     species VARCHAR(20)
);

INSERT INTO iris VALUES

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