marr75

with table_stats as (
select psut.relname,
  psut.n_live_tup,
  1.0 * psut.idx_scan / greatest(1, psut.seq_scan + psut.idx_scan) as index_use_ratio
from pg_stat_user_tables psut
order by psut.n_live_tup desc
),
table_io as (
select psiut.relname,
  sum(psiut.heap_blks_read) as table_page_read,

Mikulas

CREATE EXTENSION unaccent;

CREATE OR REPLACE FUNCTION webalize(varchar) RETURNS text AS $$
  SELECT trim(both '-' from regexp_replace(lower(unaccent($1)), '[^a-z0-9]+', '-', 'g'));
$$ LANGUAGE SQL;


SELECT unaccent('Příliš žlutý  kůň 91. stupeň!');
-- Prilis zluty  kun 91. stupen!
SELECT webalize('Příliš žlutý  kůň 91. stupeň!');

fprochazka

error_log  syslog:server=unix:/var/log/nginx.sock;

http {
    log_format verbose '$remote_addr - $remote_user $host "$request" $status $body_bytes_sent "$http_referer" "$http_user_agent"';

    map $status $loggable {
        ~^[2]  0;
        default 1;
    }

roryokane

diff --git a/file.txt b/file.txt
index 3299d68..accc3bd 100644
--- a/file.txt
+++ b/file.txt
@@ -1,7 +1,7 @@
+abc
 aaaaaa
 aaaaaa
 bbbbbb
 bbbbbb

rjames86

Last updated: 2017-03-18

Searching for Files

Find images in a directory that don't have a DateTimeOriginal

exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' .

###Output photos that don't have datetimeoriginal to a CSV### Note this can take a long time if you have a lot of jpgs

chockenberry

#!/bin/sh

find=`find /Applications /Applications/Utilities -maxdepth 2 -name '*.app' -exec echo \{\} \;`
#echo $find
IFS=$'\n'
apps=($find)
total=${#apps[*]}
echo "Checking $total applications..."
echo "The following applications will break in Gatekeeper on 10.9.5 and Yosemite:"
count=0

hrach

server {
	listen       80;
	server_name  example.com;
	root         d:/webs/example.com/www;

	index index.php index.html;
	try_files $uri $uri/ /index.php?$args;

	location ~ \.phpt?$ {
		try_files $uri @missing;

d11wtq

docker run -rm -t -i -v $(dirname $SSH_AUTH_SOCK) -e SSH_AUTH_SOCK=$SSH_AUTH_SOCK ubuntu /bin/bash

lm

<?php

class AdminerColors
{

	function head()
	{
		static $colors = array(
			'127.0.0.1' => '#ED1C24',
			'localhost' => '#009245',

isetz

Merge with Merge of https://github.com/bassjobsen/Bootstrap-3-Typeahead this fixes error with $.browser and adds minLength option

This is a fork of Bootstrap Typeahead that adds minimal but powerful extensions.

For example, process typeahead list asynchronously and return objects

  # This example does an AJAX lookup and is in CoffeeScript
  $('.typeahead').typeahead(
    # source can be a function