dirkraft

/*
Copyright Alex Leone, David Nufer, David Truong, 2011-03-11. kathack.com

javascript:var i,s,ss=['http://kathack.com/js/kh.js','http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js'];for(i=0;i!=ss.length;i++){s=document.createElement('script');s.src=ss[i];document.body.appendChild(s);}void(0);

*/
var BORDER_STYLE = "1px solid #bbb",
    CSS_TRANSFORM = null,
    CSS_TRANSFORM_ORIGIN = null,
    POSSIBLE_TRANSFORM_PREFIXES = ['-webkit-', '-moz-', '-o-', '-ms-', ''],

dirkraft

create view index_dupes as 
SELECT pg_size_pretty(sum(pg_relation_size(sub.idx))::bigint) AS size,
    (array_agg(sub.idx))[1] AS idx1,
    (array_agg(sub.idx))[2] AS idx2,
    (array_agg(sub.idx))[3] AS idx3,
    (array_agg(sub.idx))[4] AS idx4
FROM ( SELECT pg_index.indexrelid::regclass AS idx,
           (((((((pg_index.indrelid::text || '
'::text) || pg_index.indclass::text) || '
'::text) || pg_index.indkey::text) || '

dirkraft

"""
Print tabular data to a console making a best effort to write one row per line,
adjusting column sizes and truncating automatically to fit each row.

The main function is `console_table.fmt`. Execute this script to run the sample.

https://gist.github.com/dirkraft/f0759cebfd4d4567365c36570f1e3e51

Written against python 3.6.3. Requires pydash (sorry purists, I like this library :D ).

dirkraft

import org.postgresql.copy.CopyManager
import org.postgresql.core.BaseConnection
import org.slf4j.LoggerFactory

import java.nio.charset.Charset
import java.sql.Connection

/** Postgres helper to bulk load data into a db as quickly as possible. */
class PgCopy(db: DbAccess) extends Serializable {

dirkraft

<configuration scan="true">
  <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
    <!-- encoders are assigned the type
         ch.qos.logback.classic.encoder.PatternLayoutEncoder by default -->
    <encoder>
      <!-- @formatter:off -->
      <pattern>%highlight(%-5level) %d{yyyy-MM-dd'T'HH:mm:ss.SSS} %yellow([%thread]) %blue(%logger{36}) %msg%n</pattern>
      <!-- @formatter:on -->
    </encoder>
  </appender>

dirkraft

// ==UserScript==
// @name         GitHub Issue Link Title (GHILT)
// @version      0.0.1
// @author       dirkraft
// Must match aggressively due to HTML5 History, which won't trigger Tampermonkey @match.
// @match        https://github.com/*/*
// @grant        none
// @require      https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js
// ==/UserScript==

dirkraft

/*
# Put this in root build.gradle
buildscript {
    ext.kotlin_version = '1.1.2-5'
    repositories { mavenCentral() }
    dependencies { classpath "org.jetbrains.kotlin:kotlin-gradle-plugin:$kotlin_version" }
}
# Then in each project build.gradle where desired:
apply from: '../gradle/kotlin.min.gradle'
*/

dirkraft

/*
# Put this in root build.gradle
buildscript {
    ext.kotlin_version = '1.1.3-2'
    repositories { mavenCentral() }
    dependencies { classpath "org.jetbrains.kotlin:kotlin-gradle-plugin:$kotlin_version" }
}
# Then in each project build.gradle where desired:
apply from: '../gradle/kotlin.gradle'
*/

dirkraft

/*
The MIT License (MIT)

Copyright (c) 2017 Jason Dunkelberger (aka "dirkraft")

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is

dirkraft

/**
 * Usage:
 * <pre>
 *   $scope.refresh = new DelayedSearch({
 *    immediate: function() {
 *      // always do this immediately
 *      // e.g. show refreshing indicator
 *    },
 *    delayMs: 200,
 *    delayed: function() {