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

C[omp]ute

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

Choochoo Training Diary

Last 100 entries

Surprise Paradox; [Books] Good Author List; [Computing] Efficient queries with grouping in Postgres; [Computing] Automatic Wake (Linux); [Computing] AWS CDK Aspects in Go; [Bike] Adidas Gravel Shoes; [Computing, Horror] Biological Chips; [Books] Weird Lit Recs; [Covid] Extended SIR Models; [Art] York-based Printmaker; [Physics] Quantum Transitions are not Instantaneous; [Computing] AI and Drum Machines; [Computing] Probabilities, Stopping Times, Martingales; bpftrace Intro Article; [Computing] Starlab Systems - Linux Laptops; [Computing] Extended Berkeley Packet Filter; [Green] Mainspring Linear Generator; Better Approach; Rummikub Solver; Chilean Poetry; Felicitations - Empowerment Grant; [Bike] Fixing Spyre Brakes (That Need Constant Adjustment); [Computing, Music] Raspberry Pi Media (Audio) Streamer; [Computing] Amazing Hack To Embed DSL In Python; [Bike] Ruta Del Condor (El Alfalfal); [Bike] Estimating Power On Climbs; [Computing] Applying Azure B2C Authentication To Function Apps; [Bike] Gearing On The Back Of An Envelope; [Computing] Okular and Postscript in OpenSuse; There's a fix!; [Computing] Fail2Ban on OpenSuse Leap 15.3 (NFTables); [Cycling, Computing] Power Calculation and Brakes; [Hardware, Computing] Amazing Pockit Computer; Bullying; How I Am - 3 Years Post Accident, 8+ Years With MS; [USA Politics] In America's Uncivil War Republicans Are The Aggressors; [Programming] Selenium and Python; Better Walking Data; [Bike] How Fast Before Walking More Efficient Than Cycling?; [COVID] Coronavirus And Cycling; [Programming] Docker on OpenSuse; Cadence v Speed; [Bike] Gearing For Real Cyclists; [Programming] React plotting - visx; [Programming] React Leaflet; AliExpress Independent Sellers; Applebaum - Twilight of Democracy; [Politics] Back + US Elections; [Programming,Exercise] Simple Timer Script; [News] 2019: The year revolt went global; [Politics] The world's most-surveilled cities; [Bike] Hope Freehub; [Restaurant] Mama Chau's (Chinese, Providencia); [Politics] Brexit Podcast; [Diary] Pneumonia; [Politics] Britain's Reichstag Fire moment; install cairo; [Programming] GCC Sanitizer Flags; [GPU, Programming] Per-Thread Program Counters; My Bike Accident - Looking Back One Year; [Python] Geographic heights are incredibly easy!; [Cooking] Cookie Recipe; Efficient, Simple, Directed Maximisation of Noisy Function; And for argparse; Bash Completion in Python; [Computing] Configuring Github Jekyll Locally; [Maths, Link] The Napkin Project; You can Masquerade in Firewalld; [Bike] Servicing Budget (Spring) Forks; [Crypto] CIA Internet Comms Failure; [Python] Cute Rate Limiting API; [Causality] Judea Pearl Lecture; [Security, Computing] Chinese Hardware Hack Of Supermicro Boards; SQLAlchemy Joined Table Inheritance and Delete Cascade; [Translation] The Club; [Computing] Super Potato Bruh; [Computing] Extending Jupyter; Further HRM Details; [Computing, Bike] Activities in ch2; [Books, Link] Modern Japanese Lit; What ended up there; [Link, Book] Logic Book; Update - Garmin Express / Connect; Garmin Forerunner 35 v 230; [Link, Politics, Internet] Government Trolls; [Link, Politics] Why identity politics benefits the right more than the left; SSH Forwarding; A Specification For Repeating Events; A Fight for the Soul of Science; [Science, Book, Link] Lost In Math; OpenSuse Leap 15 Network Fixes; Update; [Book] Galileo's Middle Finger; [Bike] Chinese Carbon Rims; [Bike] Servicing Shimano XT Front Hub HB-M8010; [Bike] Aliexpress Cycling Tops; [Computing] Change to ssh handling of multiple identities?; [Bike] Endura Hummvee Lite II; [Computing] Marble Based Logic; [Link, Politics] Sanity Check For Nuclear Launch; [Link, Science] Entropy and Life

© 2006-2017 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 -
http://www.varlena.com/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html
- 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
distance;
\o

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 AAA-------+---------+-AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA-----++
      0        100       200        300       400       500       600


Andrew

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:
\t
\o plot.txt
select distance, count(*) from nearest_6_100 group by distance order by
distance; (note swapped order)
\o

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).

Andrew

Comment on this post