ikenfin

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

ikenfin

javascript:if(!window.__debug_div_borders_inited) { var sheet = document.styleSheets[0]; sheet.insertRule('body.__debug_div_borders div { outline: 1px solid green; }', ((sheet.cssRules && sheet.cssRules.length) || 0)); window.__debug_div_borders_inited = true; } document.body.classList.toggle('__debug_div_borders');void(0);

ikenfin

import React from 'react'
import * as R from 'ramda'

// Group data by day
// [ {*}, ... ] -> { x: [*], ... }
const groupByDay = R.groupBy(item => {
  const date = new Date(parseInt(item.date))
  return date.getDate()
})

ikenfin

ssh-keygen -t rsa -b 4096 -m PEM -f jwtRS256.key
# Don't add passphrase
openssl rsa -in jwtRS256.key -pubout -outform PEM -out jwtRS256.key.pub
cat jwtRS256.key
cat jwtRS256.key.pub

ikenfin

# some more ls aliases
alias ll='ls -alF'
alias la='ls -A'
alias l='ls -CF'
alias c='clear'

# git aliases
alias gad='git add'
alias gcm='git commit -m'
alias gp='git push'

ikenfin

Inspired by dannyfritz/commit-message-emoji

See also gitmoji.

Commit type	Emoji
Initial commit	🎉 :tada:
Version tag	🔖 :bookmark:
New feature	✨ :sparkles:
Bugfix	🐛 :bug:

ikenfin

<?php
/*
   Set my_theme_t function as allowed for pods echo tag
*/
function my_theme_pods_template_echo_tag_allowed_functions($funcs) {
    return array_merge($funcs, array('my_theme_t'));
}
add_filter('pods_template_echo_tag_allowed_functions', 'my_theme_pods_template_echo_tag_allowed_functions');
/*
    Add "echo" tag to Pods Template

ikenfin

Код	Название
27611	Москва
26062	С.-Петербург
29865	Абакан
22550	Архангельск
34880	Астрахань
29838	Барнаул
34214	Белгород
31510	Благовещенск

ikenfin

<?php
    
    /*
        Родительский класс для XML импортеров.
    */
    class AbstractAdvertisementXMLReader {
        
        protected $reader;
        protected $result = array();
        

ikenfin

/* 
  Очередь фиксированного размера
*/
function fixedSizeQueue(size) {
	var queue = Array.apply(null, []);
	queue.fixedSize = size;
	queue.trimHead = fixedSizeQueue.trimHead;
	queue.push = fixedSizeQueue.push;

	return queue;