AntJanus

Route::get('export', function() {
    $posts = Post::where('status', '=', 'published')->get();

	foreach ($posts as $post) {
	        $category = Category::where('id', '=', $post->category)->get()[0]->title;
		$content = <<<EOD
---
layout: post
title:  "$post->title"
date:   $post->created

AntJanus

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

AntJanus

# Allow moving the window
00029FEA: 0F E9
00029FEB: 85 1B
00029FEC: 1A 03
00029FED: 03 00

# Prevent the window from maximising by itself
0002A028: E5 DE
0002A029: 00 02

AntJanus

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console