ruckus

-- SELECT * FROM streaming_slave_check()

CREATE OR REPLACE FUNCTION streaming_slave_check() RETURNS TABLE (client_hostname text, client_addr inet, byte_lag float)
LANGUAGE SQL SECURITY DEFINER
AS $$
    SELECT
        client_hostname,
        client_addr,
        sent_offset - (replay_offset - (sent_xlog - replay_xlog) * 255 * 16 ^ 6 ) AS byte_lag
    FROM (

ruckus

# Block POSTS to /
RewriteBase /
RewriteCond %{REQUEST_METHOD} POST [NC]
RewriteRule ^$ - [F]

ruckus

location ~* ^/proxy_private_file/(.*) {
  set $s3_bucket        'your_bucket.s3.amazonaws.com';
  set $aws_access_key   'AWSAccessKeyId=YOUR_ONLY_ACCESS_KEY';
  set $url_expires      'Expires=$arg_e';
  set $url_signature    'Signature=$arg_st';
  set $url_full         '$1?$aws_access_key&$url_expires&$url_signature';

  proxy_http_version     1.1;
  proxy_set_header       Host $s3_bucket;
  proxy_set_header       Authorization '';

ruckus

module HstoreAccessor
  def self.included(base)
    base.extend(ClassMethods)
  end

  module ClassMethods
    def hstore_accessor(hstore_attribute, *keys)
      Array(keys).flatten.each do |key|
        define_method("#{key}=") do |value|
          send("#{hstore_attribute}=", (send(hstore_attribute) || {}).merge(key.to_s => value))

ruckus

<?php

class RecommendationsController extends AppController {

    private $recommendation;
    private $actions_that_require_a_recommendation = array('show', 'edit');
    private $actions_that_require_ownership = array('show', 'edit');

    function beforeFilter() {
      if (in_array($this->action, $actions_that_require_a_recommendation)) {

ruckus

# Redis configuration file example

# Note on units: when memory size is needed, it is possible to specify
# it in the usual form of 1k 5GB 4M and so forth:
#
# 1k => 1000 bytes
# 1kb => 1024 bytes
# 1m => 1000000 bytes
# 1mb => 1024*1024 bytes
# 1g => 1000000000 bytes

ruckus

// Generate the timestamp for the filename from the command line like:
// php -r "echo date('YmdHis', time());"
UP
--

CREATE TABLE foo (
  id int(11) PRIMARY KEY AUTO_INCREMENT,
  first_name varchar(64)
);

ruckus

#import "Account.h"
#import "JSONKit.h"

@implementation Account

@synthesize name = _name;
@synthesize accountId = _accountId;
@synthesize initial = _initial;
@synthesize code = _code;

ruckus

CREATE EXTENSION unaccent;
CREATE TEXT SEARCH CONFIGURATION vinosmith ( COPY = english );
ALTER TEXT SEARCH CONFIGURATION vinosmith ALTER MAPPING FOR hword, hword_part, word WITH unaccent, english_stem;

CREATE TRIGGER contacts_search_content_trigger BEFORE INSERT OR UPDATE
ON contacts FOR EACH ROW EXECUTE PROCEDURE
tsvector_update_trigger(search_content, 'public.vinosmith', title, name, phone, fax, email, mobile_phone);

ruckus

SELECT varietals.*, ts_rank_cd(varietals.search_content, plainto_tsquery('vinosmith', 'gruner')) as rank
FROM varietals WHERE varietals.search_content @@ plainto_tsquery('vinosmith', 'gruner')
ORDER BY rank DESC limit 25

=> [#<Varietal id: 657, name: "Grüner Veltliner" .. ]