Alex Kreidler alexkreidler

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

title	date	author	tags	syndicate
Faster PostgreSQL Counting	2016-10-12	Joe Nelson		true

Everybody counts, but not always quickly. This article is a close look into how PostgreSQL optimizes counting. If you know the tricks

Where to get FFMpeg

Windows

https://ffmpeg.zeranoe.com/builds/

OSX

https://evermeet.cx/ffmpeg/

GraphQL-LD

GraphQL-LD is a way to query Linked Data using GraphQL.

Instead of querying GraphQL interfaces, Linked Data interfaces are queried, such as SPARQL endpoints, TPF interfaces, Linked Data documents, ... This is done by semantifying GraphQL queries using a JSON-LD context.

Try it out from your browser: http://query.linkeddatafragments.org/

Alternatively, install GraphQL-LD or Comunica SPARQL and execute GraphQL-LD queries on your machine

	/*
	* I add this to html files generated with pandoc.
	*/

	html {
	font-size: 100%;
	overflow-y: scroll;
	-webkit-text-size-adjust: 100%;
	-ms-text-size-adjust: 100%;
	}

	import os
	import sys
	import time
	import atomac
	import subprocess

	if len(sys.argv) < 2:
	print "Usage: bouncer.py <path_to_logic_project> (<path_to_logic_project>)"
	os.exit(1)

	//-----------------------------------------------------------------------------
	// EventTypes.js
	//-----------------------------------------------------------------------------

	// required event class definitions for MIDI events

	//-----------------------------------------------------------------------------
	// Event : base class for all events
	//-----------------------------------------------------------------------------

	==========================
	How Software Companies Die
	==========================
	- Orson Scott Card

	The environment that nurtures creative programmers kills management and
	marketing types - and vice versa.

	Programming is the Great Game. It consumes you, body and soul. When
	you're caught up in it, nothing else matters. When you emerge into

	'use strict'

	const {randomBytes} = require('crypto')
	const {Suite} = require('benchmark')
	const {ok} = require('assert')

	const Farmfilter = require('farmfilter')
	const XXBloom = require('xxbloom')
	const JSBloom = require('jsbloom').filter
	const Orlando = require('orlando')

	import pandas as pd
	import numpy as np
	import fastparquet
	from sqlalchemy import create_engine, schema, Table

	# Copied from pandas with modifications


	def __get_dtype(column, sqltype):
	import sqlalchemy.dialects as sqld