Skip to content

Instantly share code, notes, and snippets.

View Techmind's full-sized avatar

Bogunov Ilya Techmind

View GitHub Profile
mysql -uroot -p123 -e "CREATE USER 'homestead'@'%' IDENTIFIED BY 'secret';"
mysql -uroot -p123 -e "GRANT ALL PRIVILEGES ON * . * TO 'homestead'@'%';"
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASwAAACWCAYAAABkW7XSAAAEYklEQVR4Xu3UAQkAAAwCwdm/9HI83BLIOdw5AgQIRAQWySkmAQIEzmB5AgIEMgIGK1OVoAQIGCw/QIBARsBgZaoSlAABg+UHCBDICBisTFWCEiBgsPwAAQIZAYOVqUpQAgQMlh8gQCAjYLAyVQlKgIDB8gMECGQEDFamKkEJEDBYfoAAgYyAwcpUJSgBAgbLDxAgkBEwWJmqBCVAwGD5AQIEMgIGK1OVoAQIGCw/QIBARsBgZaoSlAABg+UHCBDICBisTFWCEiBgsPwAAQIZAYOVqUpQAgQMlh8gQCAjYLAyVQlKgIDB8gMECGQEDFamKkEJEDBYfoAAgYyAwcpUJSgBAgbLDxAgkBEwWJmqBCVAwGD5AQIEMgIGK1OVoAQIGCw/QIBARsBgZaoSlAABg+UHCBDICBisTFWCEiBgsPwAAQIZAYOVqUpQAgQMlh8gQCAjYLAyVQlKgIDB8gMECGQEDFamKkEJEDBYfoAAgYyAwcpUJSgBAgbLDxAgkBEwWJmqBCVAwGD5AQIEMgIGK1OVoAQIGCw/QIBARsBgZaoSlAABg+UHCBDICBisTFWCEiBgsPwAAQIZAYOVqUpQAgQMlh8gQCAjYLAyVQlKgIDB8gMECGQEDFamKkEJEDBYfoAAgYyAwcpUJSgBAgbLDxAgkBEwWJmqBCVAwGD5AQIEMgIGK1OVoAQIGCw/QIBARsBgZaoSlAABg+UHCBDICBisTFWCEiBgsPwAAQIZAYOVqUpQAgQMlh8gQCAjYLAyVQlKgIDB8gMECGQEDFamKkEJEDBYfoAAgYyAwcpUJSgBAgbLDxAgkBEwWJmqBCVAwGD5AQIEMgIGK1OVoAQIGCw/QIBARsBgZaoSlAABg+UHCBDICBisTFWCEiBgsPwAAQIZAYOVqUpQAgQMlh8gQCAjYLAyVQlKgIDB8gMECGQEDFamKkEJEDBYfo
select * from reporting_hourly limit 5;
+----+-------+-------------+------------+----------+------------+-------------+---------+---------------------+-----+---------+---------------------+-------------+----------+--------+---------------------+----------+-------------+--------+-------+-------------+
| id | count | campaign_id | event_type | movie_id | paysite_id | tubesite_id | browser | time | asn | zone_id | count_thirdparty_id | views_count | external | repeat | visit_view_time | price | language_id | geo_id | os_id | platform_id |
+----+-------+-------------+------------+----------+------------+-------------+---------+---------------------+-----+---------+---------------------+-------------+----------+--------+---------------------+----------+-------------+--------+-------+-------------+
| 1 | 1 | 0 | 3 | 0 | 0 | 2 | Firefox | 2015-04-21 09:00:00 | 0 | 3 | 1 | 0 | 0 | 0 | 0000-00-00 00:
@Techmind
Techmind / player locations.txt
Created April 18, 2011 20:44
player locations
;
32,1;povar345;POWER OF DARKNESS;
102,1;wolfik32;;
147,1;Варлорд;;
160,2;Jettorio;;
183,256;Vassekho;;
187,2;ElPresident;;
206,256;Dmi3;Inferno;
240,256;Ir0nF1st;;
16,4;Sanches;POWER OF DARKNESS;
class User
include Buyer
include BuyerWithShotgun
end
class Buyer
private money
def canPay(price)
money > price
end
[CategoryFrameIoList, CategoryFrameSize] =
if WriteCategory == true ->
[[CategorySize = byte_size(Category), Category], CategorySize + 4];
true -> [[], 0]
end,
{ok, Client} = riak:client_connect('riak@192.168.11.123').
Mine = riak_object:new(<<"groceries">>, <<"mine">>, ["eggs", "bacon"]).
Yours = riak_object:new(<<"groceries">>, <<"yours">>, ["bread", "bacon"]).
Client:put(Yours, 1).
Client:put(Mine, 1).
Map = fun(G, 'undefined', 'none')->[G] end.
Reduce = fun(Glist, 'none') -> Glist end.
@Techmind
Techmind / gist:1315813
Created October 26, 2011 08:49
riak search ru stemmer
-module(ru_stem).
-export([
standard_analyzer_factory/2
]).
-define(UPPERCHAR(C), (C >= $A andalso C =< $Z) orelse (C >= 1040 andalso C =< 1071)).
-define(LOWERCHAR(C), (C >= $a andalso C =< $z) orelse (C >= 1072 andalso C =< 1103)).
-define(NUMBER(C), (C >= $0 andalso C =< $9)).
-define(WHITESPACE(C), ((C == $\s) orelse (C == $\n) orelse (C == $\t) orelse (C == $\f) orelse (C == $\r) orelse (C == $\v))).
@Techmind
Techmind / gist:1475874
Created December 14, 2011 09:32
Вопросы по риаку.
Потому было б интересно услышать по ваш опыт использования Риака. Что у вас за система (в общем виде и как в ней юзаеться риак.)
Юзали ли серьезно мап-редьюс, как делали индексы(прикручивали ли поиск ?\2i), какие самые большие проблемы были и как обходили.
Если есть еще знакомые с опытом использования риака меня можно пнуть в их сторону(Льва Валкина еще спрошу, но и так неплохо знаю как у них система работает, он пишет подбробно + общался с парой человек из их команды =)).
Package: erlang
State: installed
Automatically installed: no
Version: 1:13.b.3-dfsg-2ubuntu2.1
Priority: optional
Section: universe/interpreters
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Uncompressed Size: 86.0k
Depends: erlang-base | erlang-base-hipe, erlang-dev, erlang-appmon, erlang-asn1, erlang-common-test, erlang-corba, erlang-crypto, erlang-debugger,
erlang-dialyzer, erlang-docbuilder, erlang-edoc, erlang-erl-docgen, erlang-et, erlang-eunit, erlang-gs, erlang-ic, erlang-inets,