Gorav Bhootra goravbhootra

Factors Influencing Index Scan Costs

IO Cost: Costs related to reading pages from disk into memory. Parameters like random_page_cost and seq_page_cost are relevant here.
CPU Cost: Overhead of computation, usually represented by cpu_tuple_cost and cpu_index_tuple_cost.
Predicate Evaluation: Costs of evaluating WHERE clause conditions.
Sort Cost: If the query involves sorting not covered by the index.

for f in `find . -iname '*.eex' -type f -print`;do  mv "$f" ${f%.eex}.heex; done

postgres# Select setval('zones_id_seq', (SELECT max(id) from zones));

https://www.youtube.com/watch?v=vUOA5GgYg9I

Prelude

I. Preface and Motivation

This guide was written because I don't particularly enjoy deploying Phoenix (or Elixir for that matter) applications. It's not easy. Primarily, I don't have a lot of money to spend on a nice, fancy VPS so compiling my Phoenix apps on my VPS often isn't an option. For that, we have Distillery releases. However, that requires me to either have a separate server for staging to use as a build server, or to keep a particular version of Erlang installed on my VPS, neither of which sound like great options to me and they all have the possibilities of version mismatches with ERTS. In addition to all this, theres a whole lot of configuration which needs to be done to setup a Phoenix app for deployment, and it's hard to remember.

For that reason, I wanted to use Docker so that all of my deployments would be automated and reproducable. In addition, Docker would allow me to have reproducable builds for my releases. I could build my releases on any machine that I wanted in a contai

	http://stackoverflow.com/questions/22667401/postgres-json-data-type-rails-query
	http://stackoverflow.com/questions/40702813/query-on-postgres-json-array-field-in-rails

	#payload: [{"kind"=>"person"}]
	Segment.where("payload @> ?", [{kind: "person"}].to_json)

	#data: {"interest"=>["music", "movies", "programming"]}
	Segment.where("data @> ?", {"interest": ["music", "movies", "programming"]}.to_json)
	Segment.where("data #>> '{interest, 1}' = 'movies' ")
	Segment.where("jsonb_array_length(data->'interest') > 1")

	import "phoenix_html"
	import "bootstrap"
	import "jquery"
	import "toastr"

	// ...

	FactoryGirl.definition_file_paths = ['spec/factories']
	FactoryGirl.find_definitions
	# You can use this line to see what factories are loaded
	FactoryGirl.factories

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE