| Andrew Cooke | Contents | Latest | RSS | Twitter | Previous | Next


Welcome to my blog, which was once a mailing list of the same name and is still generated by mail. Please reply via the "comment" links.

Always interested in offers/projects/new ideas. Eclectic experience in fields like: numerical computing; Python web; Java enterprise; functional languages; GPGPU; SQL databases; etc. Based in Santiago, Chile; telecommute worldwide. CV; email.

Personal Projects

Lepl parser for Python.

Colorless Green.

Photography around Santiago.

SVG experiment.

Professional Portfolio

Calibration of seismometers.

Data access via web services.

Cache rewrite.

Extending OpenSSH.

C-ORM: docs, API.

Last 100 entries

Small Success With Go!; Re: Quick message - This link is broken; Adding Reverb To The Echo Chamber; Sox Audio Tools; Would This Have Been OK?; Honesty only important economically before institutions develop; Stegangraphy via PS4; OpenCL Mess; More Book Recommendations; Good Explanation of Difference Between Majority + Minority; Musical Chairs - Who's The Privileged White Guy; I can see straight men watching this conversation and laffing; When it's Actually a Source of Indignation and Disgust; Meta Thread Defending POC Causes POC To Close Account; Indigenous People Of Chile; Curry Recipe; Interesting Link On Marginality; A Nuclear Launch Ordered, 1962; More Book Recs (Better Person); It's Nuanced, And I Tried, So Back Off; Marx; The Negative Of Positive; Jenny Holzer Rocks; Huge Article on Cultural Evolution and More; "Ignoring language theory"; Negative Finger Counting; Week 12; Communication Via Telecomm Bids; Finding Suspects Via Relatives' DNA From Non-Crime Databases; Statistics and Information Theory; Ice OK in USA; On The Other Hand; (Current Understanding Of) Chilean Taxes / Contributions; M John Harrison; Playing Games on a Cloud GPU; China Gamifies Real Life; Can't Help Thinking It's Thoughtcrime; Mefi Quotes; Spray Painting Bike Frame; Weeks 10 + 11; Change: No Longer Possible To Merge Metadata; Books on Old Age; Health Tree Maps; MRA - Men's Rights Activists; Writing Good C++14; Risk Assessment - Fukushima; The Future of Advertising and Surveillance; Travelling With Betaferon; I think I know what I dislike so much about Metafilter; Weeks 8 + 9; More; Pastamore - Bad Italian in Vitacura; History Books; Iraq + The (UK) Governing Elite; Answering Some Hard Questions; Pinochet: The Dictator's Shadow; An Outsider's Guide To Julia Packages; Nobody gives a shit; Lepton Decay Irregularity; An Easier Way; Julia's BinDeps (aka How To Install Cairo); Good Example Of Good Police Work (And Anonymity Being Hard); Best Santiago Burgers; Also; Michael Emmerich (Vibrator Translator) Interview (Japanese Books); Clarice Lispector (Brazillian Writer); Books On Evolution; Looks like Ara (Modular Phone) is dead; Index - Translations From Chile; More Emotion in Chilean Wines; Week 7; Aeon Magazine (Science-ish); QM, Deutsch, Constructor Theory; Interesting Talk Transcripts; Interesting Suggestion Of Election Fraud; "Hard" Books; Articles or Papers on depolarizing the US; Textbook for "QM as complex probabilities"; SFO Get Libor Trader (14 years); Why Are There Still So Many Jobs?; Navier Stokes Incomplete; More on Benford; FBI Claimed Vandalism; Architectural Tessellation; Also: Go, Blake's 7; Delusions of Gender (book); Crypto AG DID work with NSA / GCHQ; UNUMS (Universal Number Format); MOOCs (Massive Open Online Courses); Interesting Looking Game; Euler's Theorem for Polynomials; Weeks 3-6; Reddit Comment; Differential Cryptanalysis For Dummies; Japanese Graphic Design; Books To Be Re-Read; And Today I Learned Bugs Need Clear Examples; Factoring a 67 bit prime in your head; Islamic Geometric Art; Useful Julia Backtraces from Tasks; Nothing, however, is lost with less discomfort than that which, when lost, cannot be missed

© 2006-2015 Andrew Cooke (site) / post authors (content).

Plotting Data from Postgres

From: "andrew cooke" <andrew@...>

Date: Sun, 31 Aug 2008 13:16:04 -0400 (CLT)

If PL/R looks too complicated -
- then from google hits it looks like gnuplot is the best (ie most
popular) option for plotting data in Postgres.

In postgres:
\t (do this only once - it toggles)
\o plot.txt
select count(*), distance from nearest_6_100 group by distance order by

In gnuplot:
set term dumb 70 24
plot 'plot.txt'

  120 ++--------A---------+----------+---------+---------+--------++
      +         +         +          +         + 'plot.txt'   A    +
      |         AA                                                 |
  100 ++      AAAAA                                               ++
      |       AAA AA                                               |
      |        AAA A A                                             |
      |       A  AAA                                               |
   80 ++      AA AAAA                                             ++
      |       A A AAA                                              |
      |     AAA     AA                                             |
   60 ++    AAA     A                                             ++
      |    AAAA      A                                             |
      |    AAA      A A                                            |
   40 ++   AA        AAA                                          ++
      |    A          AA                                           |
      |   AA          AAA                                          |
      |   AA           AA                                          |
   20 ++ AAA           AAA                                        ++
      | AAA              AAA A                                     |
      +AAA      +        AAAAAA  AA  +     A   AAAAAAAAAA+A        +
      0        100       200        300       400       500       600


With Separator

From: "andrew cooke" <andrew@...>

Date: Sun, 31 Aug 2008 13:28:17 -0400 (CLT)

Ooops.  That plotted only the first column.

What I wanted was...

In postgres:
\o plot.txt
select distance, count(*) from nearest_6_100 group by distance order by
distance; (note swapped order)

In gnuplot:
set datafile separator '|'
set log x
set xtics (1000,2000,3000,5000,10000)
plot [1000:10000] 'plot.txt'

  120 ++----------------A----------+-------------+----------------++
      +                 +          +             'plot.txt'   A    +
      |                 A                                          |
  100 ++                A                                         ++
      |                 A                                          |
      |                 A                                          |
      |                 AA                                         |
   80 ++                AA                                        ++
      |                 AA                                         |
      |                 AA                                         |
   60 ++               AAA                                        ++
      |                AAA                                         |
      |                AAA                                         |
   40 ++               AAA                                        ++
      |                A A                                         |
      |                A A                                         |
      |                A A                                         |
   20 ++               A A                                        ++
      |                A AA                                        |
      +                A+AA        + A          A+                 +
    0 ++--------------AA+-A--------+AAA---AA-AAAAA----------------++
     1000              2000       3000          5000             10000

(data have changed since last post).


Comment on this post