destan

import java.io.IOException;
import java.net.URISyntaxException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.security.KeyFactory;
import java.security.NoSuchAlgorithmException;
import java.security.PrivateKey;
import java.security.interfaces.RSAPublicKey;
import java.security.spec.InvalidKeySpecException;
import java.security.spec.PKCS8EncodedKeySpec;

bartojs

boot -d com.github.jnr/jnr-ffi repl

=> (import jnr.ffi.LibraryLoader)

=> (definterface LibC (^int puts [^String s]))

=> (def libname (if (.contains (.toLowerCase (System/getProperty "os.name")) "windows") "msvcrt" "c"))

=> (def libc (.load (LibraryLoader/create LibC) libname))

jfrost

So, I did a quick test with pgbouncer running on the local host and talking to a remote postgresql backend.  I had the script open a connection, run a quick almost instantaneous query (SELECT now() ), collect the results and close the connection.  It looped over this 50,000 times.

Connecting to the bouncer over local unix socket, it took 31s to perform all the queries.

Connecting to the bouncer over localhost, it took 45s to perform all the queries.

Connecting to the bouncer running on the remote server, it took 1m6s

Without using pgbouncer, it took 3m34s

daveliepmann

(ns localstorage)

(defn set-item!
  "Set `key' in browser's localStorage to `val`."
  [key val]
  (.setItem (.-localStorage js/window) key val))

(defn get-item
  "Returns value of `key' from browser's localStorage."
  [key]

floriankraft

SQL2

All nodes with a specific name

SELECT * FROM [nt:unstructured] AS node
WHERE ISDESCENDANTNODE(node, "/search/in/path")
AND NAME() = "nodeName"

All pages below content path

jbottigliero

/** @jsx React.DOM */
define(['reactjs'], function(React){

	return React.createClass({

		getDefaultProps: function(){
			return {
				multiple: false
				/*
				name: 'mySelect'

auser

angular.module('restangularDemoApp', [
  'restangular',
  'ngCookies'
])
.constant('apiKey', 'YOUR_Mongolab_API_KEY')
.config(function(RestangularProvider, apiKey) {
  RestangularProvider.setBaseUrl('https://api.mongolab.com/api/1/databases/YOURDATABASE/collections');
    RestangularProvider.setDefaultRequestParams({ 
      apiKey: apiKey
    })

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

jboner

Latency Comparison Numbers (~2012)
----------------------------------
L1 cache reference                           0.5 ns
Branch mispredict                            5   ns
L2 cache reference                           7   ns                      14x L1 cache
Mutex lock/unlock                           25   ns
Main memory reference                      100   ns                      20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy             3,000   ns        3 us
Send 1K bytes over 1 Gbps network       10,000   ns       10 us
Read 4K randomly from SSD*             150,000   ns      150 us          ~1GB/sec SSD