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%' 

nikmartin

Secure sessions are easy, but not very well documented.  
Here's a recipe for secure sessions in Node.js when NginX is used as an SSL proxy:

The desired configuration for using NginX as an SSL proxy is to offload SSL processing 
and to put a hardened web server in front of your Node.js application, like:

[NODE.JS APP] <- HTTP -> [NginX] <- HTTPS -> [PUBLIC INTERNET] <-> [CLIENT]

Edit for express 4.X and >:  Express no longer uses Connect as its middleware framework, it implements its own now. 

tanaikech

Upload Files to Google Drive using Javascript

News

At October 11, 2019, I published a Javascript library to to run the resumable upload for Google Drive. When this is used, the large file can be uploaded. You can also use this js library.

Description

This is a sample script for uploading files to Google Drive using Javascript. The files are uploaded by Drive API v3. gapi.client.drive.files.create() can create an empty file on Google Drive. But it cannot directly upload files including contents. I think that this might not be able to upload files and metadata with the multipart/related, although this might be resolved by the future update. So now, as one of workarounds, I use using XMLHttpRequest.

• This sample uses gapi.
• Before you use this, please enable Drive API at API console and carr

adamgibbons

var restify = require('restify')
  , port = process.env.PORT || 3000
  , Phantom = require('phantom')
  , tmpdir = require('os').tmpdir()
  , fs = require('fs');

var server = restify.createServer();

function setResponseHeaders(res, filename) {
  res.header('Content-disposition', 'inline; filename=' + filename);

uoxiu

<?php

$folder = 'W:\\test\\';

$infile = $folder . 'in.docx';
$outFile = $folder . 'out.docx';

$targetFiles = [
    'word/document.xml'
];

TheFoot

/**
 *      This module provides native variable type checking utilities.
 *      It has no external dependencies.
 *      No parsing or coercion is performed.
 *
 *      @module TypeUtils
 */
const validateUUID = require ( 'uuid-validate' );

// The module definition

ErisDS

Below is just about everything you'll need to style in the theme. Check the source code to see the many embedded elements within paragraphs.

---

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5

Heading 6

sharq88

// get the call stack
Object.defineProperty ( global, '__stack', {
	get: function () {
		var orig = Error.prepareStackTrace;
		Error.prepareStackTrace = function ( _, stack ) {
			return stack;
		};
		var err = new Error;
		Error.captureStackTrace ( err, arguments.callee );
		var stack = err.stack;