Skip to content

Instantly share code, notes, and snippets.

View jb41's full-sized avatar

Michal Oblak jb41

20 followers · 3 following
View GitHub Profile
@jb41
jb41 / postgresql_useful_queries.sql
Created January 21, 2019 07:49
-- show slow queries eating whole CPU
SELECT substring(query, 1, 50) AS short_query, round(total_time::numeric, 2) AS total_time, calls, rows, round(total_time::numeric / calls, 2) AS avg_time, round((100 * total_time / sum(total_time::numeric) OVER ())::numeric, 2) AS percentage_cpu FROM pg_stat_statements ORDER BY total_time DESC LIMIT 20;
-- same as above but whole query
SELECT query AS short_query, round(total_time::numeric, 2) AS total_time, calls, rows, round(total_time::numeric / calls, 2) AS avg_time, round((100 * total_time / sum(total_time::numeric) OVER ())::numeric, 2) AS percentage_cpu FROM pg_stat_statements ORDER BY total_time DESC LIMIT 20;
@jb41
jb41 / cats-can-code-index.html
Created September 11, 2017 11:49
<body>
<h1 class="title" sheetsu-key="Header">
DrivePages by Sheetsu - simplest solution to host websites
</h1>
<h2 class="subtitle">
<a href="https://sheetsu.com/pages" sheetsu-key="Main link">
Visit pages.sheetsu.com
</a>
</h2>
@jb41
jb41 / feature-in-progress.html
Created September 1, 2017 11:22
<a href="#" onclick='Intercom("showNewMessage", "Hello there! 👋 I want to add domain to my Sheetsu Page")'>Add Domain</a>
@jb41
jb41 / sheetsu-js.demo-001.html
Created July 14, 2017 13:38
<!DOCTYPE html>
<html>
<head>
<title></title>
<script src="//script.sheetsu.com/"></script>
</head>
<body>
<script>
function getParamsFromUrl(url) {
@jb41
jb41 / ajax_post_to_sheetsu.html
Created March 30, 2017 20:43
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
</head>
<body>
<form id="form">
<input type="text" name="name">
<input type="text" name="score">
<button type="submit">submit</button>
@jb41
jb41 / sheetsu_angular_get.coffee
Created February 1, 2017 07:38
angular.module('app').service('Subjucator', [
'$http', function($http) {
return {
get: function(url) {
return $http.get(url);
},
post: function(url, data) {
return $http.post(url, data);
}
};
@jb41
jb41 / error.rb
Created July 30, 2016 16:49
Dynamically create Error classes
module SheetCRUD
module Error
ERRORS = [
unauthorized: { message: 'Unauthorized.', status: 401 },
limit_exceed: { message: 'Rate limit exceed.', status: 429 },
not_found: { message: 'Not found.', status: 404 }
]
class StandardAPIError < StandardError
@jb41
jb41 / push_data.py
Created June 21, 2016 10:02
import requests
url = 'https://sheetsu.com/apis/YOUR_API_ID'
data = {"timestamp": "1458819671995", "idea": "wooho"}
r = requests.post(url, json=data)
print r.status_code
print r.json()
@jb41
jb41 / sheetsu_get_example.html
Created May 11, 2016 22:48
<html>
<head>
<script src="https://code.jquery.com/jquery-3.0.0-alpha1.js"></script>
</head>
<body>
<ul id="characters-list"></ul>
<script>
var sheetsuUrl = "https://sheetsu.com/apis/v1.0/020b2c0f";
@jb41
jb41 / charge_app.rb
Created May 7, 2016 13:08
require 'pry'
require 'json'
require 'httparty'
require 'stripe'
class ChargeApp < Sinatra::Base
AMOUNT = 300
Stripe.api_key = "SECRET_STRIPE_KEY"