Skip to content

Instantly share code, notes, and snippets.

View sanchezzzhak's full-sized avatar
🦙
lama no prob llama

Tutik Alexsandr sanchezzzhak

🦙
lama no prob llama
View GitHub Profile
@sanchezzzhak
sanchezzzhak / clickhouse-get-tables-size.sql
Created January 18, 2018 13:43
clickhouse get tables size
SELECT table,
formatReadableSize(sum(bytes)) as size,
min(min_date) as min_date,
max(max_date) as max_date
FROM system.parts
WHERE active
GROUP BY table
@sanchezzzhak
sanchezzzhak / StatGrid.php
Created August 9, 2017 16:09
GridView closure options test example
<?php
interface IStat {
const GROUP_HOUR = 'hour';
}
class StatGrid extends Object
{
/** @var Stat */
public $model;
/** @var SqlDataProvider */
@sanchezzzhak
sanchezzzhak / test_mongo_short_id.php
Created November 23, 2016 11:55
mongo short id
<?php
class Base62 {
const CHARS_SYMBOLS = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_-';
/**
* @param $id
* @return string
*/
public static function encode($id){
@sanchezzzhak
sanchezzzhak / ISO3166_RU.json
Created July 22, 2015 11:35
Список кодов Стран по ISO 3166 в json
[{
"flag_url" : "//upload.wikimedia.org/wikipedia/commons/thumb/b/b9/Flag_of_Australia.svg/22px-Flag_of_Australia.svg.png",
"name_ru" : "Австралия",
"iso_code2" : "AU",
"iso_code3" : "AUS"
}, {
"flag_url" : "//upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/22px-Flag_of_Austria.svg.png",
"name_ru" : "Австрия",
"iso_code2" : "AT",
"iso_code3" : "AUT"