Michal Oblak 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 / 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 / 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 / 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 / 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 / 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 / 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 / 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 / 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 / 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"