Peter Lindberg plindberg

A while back, I wrote [a script to do daily dumps of a PostgreSQL table with a JSONB column][old one]. This was something an intern did daily for a client.

However, as summer came, we needed to automate this. The simplest and quickest solution turned out to do this using Heroku Dataclips.

I wasn’t aware of the [JSON functions and operators][json ops] of PostgreSQL, allowing you to both SELECT stuff from inside the JSON, and use in WHERE predicates. (It appears that you can even set up indexes on JSON values.)

This script is one I wrote to dump a PostgreSQL table with a JSONB column into TSV put on your pasteboard (on macOS) such that you can just paste it into a Google Sheet.

I needed this for a client and it was a bit of work, so I thought it might be useful to someone out there.

README

Granted, this is little more than an obfuscated way of having a publicly writable S3 bucket, but if you don’t have a server which can pre-sign URLs for you, this might be an acceptable solution.

For this to work, you take the following steps:

Create a Lambda func, along with a new IAM role, keeping the default code.
Create an API in the API Gateway.

Rich Hickey on becoming a better developer

Sorry, I have to disagree with the entire premise here.

A wide variety of experiences might lead to well-roundedness, but not to greatness, nor even goodness. By constantly switching from one thing to another you are always reaching above your comfort zone, yes, but doing so by resetting your skill and knowledge level to zero.

Mastery comes from a combination of at least several of the following:

Knowledge
Focus

	http -b -a ${WATSON_DIALOG_USERNAME}:${WATSON_DIALOG_PASSWORD} \
	https://gateway.watsonplatform.net/dialog/api/v1/dialogs/${WATSON_DIALOG_ID}/conversation\
	\?date_from='2016-01-27 00:00:00'\&date_to='2016-06-22 00:00:00' \
	\|jq '
	.conversations[] \| .messages \|
	[
	.[] \|
	if .from_client == "true" then
	"> \(.text)"
	else

	'use strict';

	const co = require('co');

	// Like `reduce()` but accepting a generator function, such that it can be used asynchronously
	// within a generator function invoked by `co()`.
	function* reduceg(arr, genfn, initial) {
	let acc = initial;
	for (let x of arr) {
	acc = yield genfn(acc, x);

	<?xml version="1.0" encoding="UTF-8" ?>
	<dialog xsi:noNamespaceSchemaLocation="WatsonDialogDocument_1.0.xsd"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<flow>
	<folder label="Main">

	<output id="start">
	<prompt>
	<item>Write stuff and I’ll SHOUT it back to you.</item>
	</prompt>

	git remote \| \
	xargs -n1 -I{} \
	git log --oneline -1 --pretty=format:"%C(red)%h%d%C(reset) %s /%an, %ar" {}/master