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
| ;; React supports "refs" as a way for a component to get a | |
| ;; handle to its children. Classically, refs were string-based. | |
| ;; Recent versions of React support callback attributes as a | |
| ;; more elegant variant of accessing DOM notes or components. | |
| ;; | |
| ;; This example uses a Form-3 component as per | |
| ;; https://github.com/Day8/re-frame/wiki/Creating-Reagent-Components | |
| ;; | |
| ;; For callback refs, see React's documentation | |
| ;; https://facebook.github.io/react/docs/more-about-refs.html |
| 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; |
| 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)) |
| 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 |
| (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] |
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
| /** @jsx React.DOM */ | |
| define(['reactjs'], function(React){ | |
| return React.createClass({ | |
| getDefaultProps: function(){ | |
| return { | |
| multiple: false | |
| /* | |
| name: 'mySelect' |
| 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 | |
| }) |
| -- 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%' |
| 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 |