Erushenko

/* How to calculate postgreSQL database size in disk ? */

SELECT pg_size_pretty(pg_database_size('thedbname'));

/* Calculate size of a table including or excluding the index */

SELECT pg_size_pretty(pg_total_relation_size('big_table'));
SELECT pg_size_pretty(pg_relation_size('big_table')); /* without index */

/* See indexes on a table with `\d tablename` */

Erushenko

// === Arrays

var [a, b] = [1, 2];
console.log(a, b);
//=> 1 2


// Use from functions, only select from pattern
var foo = () => [1, 2, 3];

Erushenko

Common Options

-#, --progress-bar Make curl display a simple progress bar instead of the more informational standard meter.

-b, --cookie <name=data> Supply cookie with request. If no =, then specifies the cookie file to use (see -c).

-c, --cookie-jar <file name> File to save response cookies to.

Erushenko

var interval = window.setInterval(function() {
    var moreButton = document.querySelector('a[ajaxify*="outgoing/more"]');
    if (moreButton)
    {
        moreButton.click();
        console.log('loading more...');
    }
    else
    {
        //window.clearInterval(interval);

Erushenko

var connectionString = 'postgres://localhost:5432/postgres';
var Promise=require('bluebird');


var knex = require('knex')({
  client: 'pg',
  connection: {
      user: 'postgres',
      database: 'postgres',
      port: 5432,