Skip to content

Instantly share code, notes, and snippets.

View tistaharahap's full-sized avatar

Batista Harahap tistaharahap

88 followers · 26 following
View GitHub Profile
@tistaharahap
tistaharahap / xl-iframe.html
Created May 14, 2017 15:22
XL Iframe
<!DOCTYPE html>
<html><head>
<noscript>
&lt;meta http-equiv="refresh"content="0;URL=http://ibn.adreach.co/ads-request?t=3&amp;j=0&amp;i=182324434&amp;s=I03025149477501061917&amp;a=http://www.livescore.com/"/&gt;
</noscript>
<link href="http://ibn.adreach.co:8004/COMMON/css/ibn_20150915.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="http://ibn.adreach.co/ads-request?t=3&amp;j=2&amp;callback=ibn.jsonp313&amp;rnd=313&amp;a=http%3A%2F%2Fwww.livescore.com%2F&amp;i=182324434&amp;s=I03025149477501061917"></script><style type="text/css">
:root #content > #center > .dose > .dosesingle,
:root #content > #right > .dose > .dosesingle
{ display: none !important; }</style><meta name="viewport" content="width=device-width, initial-scale=1"><meta name="apple-mobile-web-app-capable" content="no"><title>LiveScore Soccer : Live Soccer Scores by LiveScore.com</title><script type="text/javascript" src="http://ibn.adreach.co/ads-reset?j=2&amp;adsTransactionId=D0394775012212561&amp;orgUrl=http%3A%2F
@tistaharahap
tistaharahap / results.txt
Created September 13, 2016 10:43
$ python hs.py
**/ Benchmarking Handlersocket - START /**
Elapsed time: 9.35 seconds
Speed : 10693.14 queries/second
**/ Benchmarking Handlersocket - END /**
**/ Benchmarking MySQL - START /**
Elapsed time: 12.11 seconds
@tistaharahap
tistaharahap / hs.py
Created September 13, 2016 10:41
from pyhs import Manager
import MySQLdb
import time
def run_handlersocket(maximum):
hs = Manager() # Assuming that Handlersocket is available at 127.0.0.1
print '**/ Benchmarking Handlersocket - START /**\n'
@tistaharahap
tistaharahap / hs.py
Last active September 13, 2016 10:40
from pyhs import Manager
def main():
hs = Manager() # Assuming that Handlersocket is available at 127.0.0.1
user = hs.find('fun', 'user', '>=', ['user_id', 'user_name', 'user_email', 'created'], ['tistaharahap'], 'usernames', 1)
print dict(user[0])
@tistaharahap
tistaharahap / create-index.sql
Created September 6, 2016 08:52
CREATE INDEX usernames ON `user` (user_name);
@tistaharahap
tistaharahap / hs.txt
Created September 6, 2016 08:46
$ python hs.py
{'user_name': 'tistaharahap', 'user_id': '1', 'user_email': 'tista@example.org', 'created': '2016-09-06 15:00:00'}
@tistaharahap
tistaharahap / hs.py
Created September 6, 2016 08:46
from pyhs import Manager
def get_user_by_id(hs, user_id):
pass
def main():
hs = Manager() # Assuming that Handlersocket is available at 127.0.0.1
@tistaharahap
tistaharahap / install-deps.txt
Last active September 6, 2016 08:37
$ pip install -r requirements.txt
Collecting python-handler-socket (from -r deps (line 1))
Downloading python-handler-socket-0.2.4.tar.gz
Building wheels for collected packages: python-handler-socket
Running setup.py bdist_wheel for python-handler-socket ... done
Stored in directory: /Users/tista/Library/Caches/pip/wheels/48/7c/46/ee1c1e3dabc22527c8780ac7ae3ca7ba03a66e6720d5d1f481
Successfully built python-handler-socket
Installing collected packages: python-handler-socket
Successfully installed python-handler-socket-0.2.4
@tistaharahap
tistaharahap / requirements.txt
Created September 6, 2016 08:36
python-handler-socket
@tistaharahap
tistaharahap / users.sql
Created September 6, 2016 06:50
CREATE TABLE user (
user_id INT UNSIGNED PRIMARY KEY,
user_name VARCHAR(50),
user_email VARCHAR(255),
created DATETIME
) ENGINE=InnoDB;