Category Archives: Other

postgres dump query to file

\copy (select fields from table where something=otherthing) to ‘/tmp/test.csv’ with HEADER CSV;

Posted in Other | Comments Off on postgres dump query to file

A photo posted by Joshua Boyd (@joshua_d_boyd) on Jan 24, 2017 at 4:27am PST

Posted in Other | Comments Off on

A photo posted by Joshua Boyd (@joshua_d_boyd) on Jan 24, 2017 at 8:47pm PST

Posted in Other | Comments Off on

Swift 3 on Ubuntu 16.10

On swift.org’s downloads page Swift 3 comes with builds for Ubuntu 14.04 and Ubuntu 16.04, but not 16.10. It is a reasonable guess that the 16.04 build will still work on 16.10, but once downloaded and extracted, it complained about … Continue reading

Posted in Other | Comments Off on Swift 3 on Ubuntu 16.10

Posted in Other | Comments Off on

Just a Tree

Trying some inline processing.js.

Posted in Other | Comments Off on Just a Tree

Make PostgreSQL default to UTF-8

From here : UPDATE pg_database SET datistemplate=FALSE WHERE datname=’template1′; DROP DATABASE template1; CREATE DATABASE template1 WITH owner=postgres template=template0 encoding=’UTF8′; UPDATE pg_database SET datistemplate=TRUE WHERE datname=’template1′;

Posted in Other | Comments Off on Make PostgreSQL default to UTF-8

Fastest route to Postgres and Python with psycopg2 on OSX.

Download Postgres.app from postgresapp.com. Unzip into /Applications, then run it. To get psycopg2 to then install do: PATH=$PATH:/Applications/Postgres.app/Contents//Versions/9.3/bin/ pip install psycopg2 Tada! Your done and without having had to use fink or brew.

Posted in Other | Comments Off on Fastest route to Postgres and Python with psycopg2 on OSX.

JSON Pretty Printer in Go

Posted in Other | Comments Off on JSON Pretty Printer in Go

A quick trial at creating color fields (and then sticking textured stuff on top).

Posted on by jdboyd | Comments Off on