romikoops

SELECT
	t0. "id",
	t0. "inserted_at"::timestamp AT TIME ZONE 'Etc/UTC' AT TIME ZONE 'Europe/Amsterdam',
	o1. "inserted_at"::timestamp AT TIME ZONE 'Etc/UTC' AT TIME ZONE 'Europe/Amsterdam',
	o1. "id",
	o3. "id" AS "client_order_id",
	o4. "id" AS "hedge_order_id",
	o1. "source",
	c2. "slug",
	t0. "position",

romikoops

Types of index scans

Indexes

Sequential Scan:

• Read every row in the table
• No reading of index. Reading from indexes is also expensive.

romikoops

---
apiVersion: rbac.authorization.k8s.io/v1
kind: ClusterRole
metadata:
  name: system:aggregated-metrics-reader
  labels:
    rbac.authorization.k8s.io/aggregate-to-view: "true"
    rbac.authorization.k8s.io/aggregate-to-edit: "true"
    rbac.authorization.k8s.io/aggregate-to-admin: "true"
rules:

romikoops

Helm cheatsheet

• Helm cheatsheet
  • Get started
  • Struture
  • General Usage
  • Template
  • Hooks

romikoops

romikoops

romikoops

defmodule MyAppAPI.ReleaseTasks do
  alias Ecto.Migrator

  @otp_app :myapp_api
  @start_apps [:logger, :ssl, :postgrex, :ecto]

  def migrate do
    init(@otp_app, @start_apps)

    run_migrations_for(@otp_app)

romikoops

The standard names for indexes in PostgreSQL are:

{tablename}_{columnname(s)}_{suffix}

where the suffix is one of the following:

• pkey for a Primary Key constraint;
• key for a Unique constraint;
• excl for an Exclusion constraint;
• idx for any other kind of index;

romikoops

Preperation

Installation

• Install Elixir: http://elixir-lang.org/install.html
• Install Phoenix http://www.phoenixframework.org/docs/installation

sudo apt-get install inotify-tools #ubuntu
sudo apt-get install postgresql #Ubuntu

mix local.hex #install hex
mix archive.install https://github.com/phoenixframework/archives/raw/master/phoenix_new.ez #phoenix archive

romikoops

use Mix.Config

# We don't run a server during test. If one is required,
# you can enable the server option below.
config :hello_phoenix, HelloPhoenix.Endpoint,
  http: [port: 4001],
  server: false

# Print only warnings and errors during test
config :logger, level: :warn