anvk

--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192

-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.

------------
-- Basics --
------------

-- Get indexes of tables

spk

diff --git a/app/models/version.rb b/app/models/version.rb
index e8eed16..a3a4ba1 100644
--- a/app/models/version.rb
+++ b/app/models/version.rb
@@ -36,10 +36,10 @@ class Version < ActiveRecord::Base
     GemDownload.create!(count: 0, rubygem_id: rubygem_id, version_id: id)
   end
 
-  def self.reverse_dependencies(name)
+  def self.reverse_dependencies_by(**kwargs)

mgoodness

AWS Service annotations

• service.beta.kubernetes.io/aws-load-balancer-access-log-emit-interval (in minutes)
• service.beta.kubernetes.io/aws-load-balancer-access-log-enabled (true|false)
• service.beta.kubernetes.io/aws-load-balancer-access-log-s3-bucket-name
• service.beta.kubernetes.io/aws-load-balancer-access-log-s3-bucket-prefix
• service.beta.kubernetes.io/aws-load-balancer-additional-resource-tags (comma-separated list of key=value)
• service.beta.kubernetes.io/aws-load-balancer-backend-protocol (http|https|ssl|tcp)
• service.beta.kubernetes.io/aws-load-balancer-connection-draining-enabled (true|false)

dteoh

In Rails 5, the preferred base class for testing controllers is ActionDispatch::IntegrationTest.

If you have an API that receives parameters as JSON request bodies, here are some helper methods to facilitate testing:

class ActionDispatch::IntegrationTest
  def put_json(path, obj)
    put path, params: obj.to_json, headers: { 'CONTENT_TYPE' => 'application/json' }
  end

ssmythe

======
Videos
======

DevOps

  What is DevOps? by Rackspace - Really great introduction to DevOps
    https://www.youtube.com/watch?v=_I94-tJlovg

  Sanjeev Sharma series on DevOps (great repetition to really get the DevOps concept)

tsiege

ANNOUNCEMENT

I have moved this over to the Tech Interview Cheat Sheet Repo and has been expanded and even has code challenges you can run and practice against!






\

karmi

require 'tire'

# Tire.configure { logger STDERR, level: 'debug' }

Tire.index('movie-titles') do
  delete
  create \
    settings: {
      index: {
        analysis: {

hakanensari

require 'active_record'
require 'activerecord-import'
require 'benchmark'
require 'pg'

include ActiveRecord

Base.establish_connection adapter: 'postgresql',
                          encoding: 'unicode',
                          pool:     5,