markselby

  local redis = require "resty.redis"
  local red = redis:new()
  red:set_timeout(1000) -- 1 sec

  local ok, err = red:connect("127.0.0.1", 6379)
  if not ok then
    ngx.log(ngx.ERR, "Redis failed to connect")
    return ngx.exit(ngx.HTTP_SERVICE_UNAVAILABLE)
  end

markselby

var zlib = require('zlib');
var redis = require('redis');
var redisClient = redis.createClient();
var crypto = require('crypto');

// Our custom caching write function
function cached(body, lifetime, type) {
  var key = this.req.originalUrl;
  var res = this;
  var etag, len;

markselby

# Build dependencies for OpenResty.
sudo apt-get install build-essential libpcre3-dev libssl-dev libgeoip-dev

# Install standard Nginx first so that you get the relevant service scripts installed too
sudo apt-get install nginx

# If you want to access Postgres via Nginx
sudo apt-get install libpq-dev

markselby

location / {
  try_files $uri @redis_cache;
  add_header Source Files; # Handy for development
}

location @redis_cache {
  # Make sure this path is correct
  # Run "nginx -V" from the command prompt and look for --prefix=/path/to/somewhere
  # and place redis.lua there, or use an absolute path as shown below
  content_by_lua_file /path/to/your/config/redis.lua;

markselby

function loadGists() {
  var els = $('code[gist]'), gists = {}, code = [], stylesheets = [];
  // Get elements referencing a gist and build a gists hash referencing the elements that use it
  els.each(function(idx, rawEl) {
    var el = $(rawEl), gist = el.attr('gist');
    rawEl.gist = gist;
    rawEl.file = el.attr('file');
    gists[gist] = gists[gist] || { targets: [] };
    gists[gist].targets.push(el);
  });

markselby

/*
 * Find which tables were involved in a number of queries.
 * This is obviously a contrived example. A practical application would be to wrap all
 * the queries for a web page in a transaction (perhaps using before/after filters in
 * the case of Rails) and then use the stats for cache invalidation.
 */

BEGIN TRANSACTION;
  /* Run the queries */
  SELECT * from news LIMIT 5;

markselby

#/bin/sh
(
  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?><urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">"
  psql -c "COPY (SELECT xmlelement(name url, xmlforest('http://writebox.co.uk/news/' || slug AS loc, to_char(updated_at, 'YYYY-MM-DDThh:mm:ss+07:00') AS lastmod)) FROM news) TO STDOUT" writebox_$2
  echo "</urlset>"
) > $1/public/sitemap.xml
cat $1/public/sitemap.xml | gzip -9 > $1/public/sitemap.xml.gz

markselby

-- eg SELECT sort_order('-relevance', ['title', 'updated_at', 'relevance'])
-- Optionally specify +/- prefix for sort field. Invalid sort field uses first in array
CREATE OR REPLACE FUNCTION sort_order(_field text, _valid text[]) RETURNS json AS
$$
  _field = decodeURIComponent(_field);
  var directions = { ' ': 'ASC', '-': 'DESC' }; // + becomes space
  var direction = directions[_field[0]];
  if(direction) { _field = _field.slice(1) } else { direction = directions['-']; };
  if(_valid.indexOf(_field) < 0) _field = _valid[0];
  return { field: _field, direction: direction };

markselby

// Somewhere in your javascript assets included at the end of the document
$(document).ready(function() {
  loaded = true;
  doInit();
});

markselby

NODE_ENV=development node sample-usage.js