Roman Parashchenko 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

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;

Helm cheatsheet

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

Types of index scans

Indexes

Sequential Scan:

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

	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

	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)