svilensabev

search argo.svc.cluster.local svc.cluster.local cluster.local
nameserver 8.8.8.8
options ndots:5

svilensabev

-- First create schema/data data for tests

DROP  TABLE api.slot CASCADE;

CREATE TABLE api.slot (
  id          UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  name        TEXT,
  latitude    NUMERIC,
  longitude   NUMERIC,
  geog        geography(Point, 4326) DEFAULT NULL

svilensabev

BEGIN;

CREATE OR REPLACE FUNCTION api.geog_points_in_distance(latitude NUMERIC, longitude NUMERIC, distance NUMERIC)
  RETURNS JSON
  SECURITY DEFINER
  LANGUAGE PLPGSQL STABLE
  SET search_path TO PUBLIC, api
  AS $$
DECLARE
  _lat        NUMERIC DEFAULT latitude::NUMERIC;

svilensabev

DROP  TABLE api.geog_point;

CREATE TABLE api.geog_point (
  id          UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  name        TEXT,
  latitude    NUMERIC,
  longitude   NUMERIC,
  geog        geography(Point, 4326) DEFAULT NULL
);

svilensabev

DROP  TABLE api.geom_point;

CREATE TABLE api.geom_point (
  id          UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  name        TEXT,
  latitude    NUMERIC,
  longitude   NUMERIC,
  geom        geometry(Point, 4326) DEFAULT NULL
);

svilensabev

DevOps

---

1. Provisioning staging VPS

Secure server

• Firewall
• SSH configuration

svilensabev

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)