h2g2bob @h2g2bob@mastodon.dbatley.com

It's midsummer, the longest day (in the northern hemisphere). A time of travel and calm seas, of bonfires and barbecues.

I now run a service which helps you diagnose slow queries in PostgreSQL. It makes a diagram from the query planner output, helping you see which bit is slow.
https://dbatley.com/blog/2019/06/dbplanview.html #postgres #sql

Estimating the carbon footprints of various sandwiches https://www.improbable.com/2019/05/23/the-carbon-footprints-of-various-sandwiches-study/ #science

The world population is aging: there are more people aged 65+ than children under 5
https://ourworldindata.org/population-aged-65-outnumber-children #world

The naked mole rat and sensitivity to pain. Starts weird, and just gets worse. https://blogs.sciencemag.org/pipeline/archives/2019/06/10/fast-pain-relief-in-only-seven-million-years

Hong Kong government trying to allow extradition to China, weakening HK independence. Estimates of numbers protesting between 1 in 8 and 1 in 30. https://www.theguardian.com/world/2019/jun/09/vast-protest-in-hong-kong-against-extradition-law-china #world

Taxing carbon dioxide http://timharford.com/2019/05/why-the-world-needs-a-carbon-tax/ #economics #climate

Exim vulnerability when localhost emails `${run{...}}@localhost` https://lwn.net/Articles/790553/rss

The newspapers will promote strange new diets, but the expert advice has remained the same: lots of veg, lots of carbs https://www.nhs.uk/tools/documents/eatwell/eatwell.mob.html

Logic with kittens https://diamondgeezer.blogspot.com/2019/04/logic-with-kittens.html

https://www.cyclestreets.net/collisions/reports/2017420196262/

Oceans, land and deep subsurface: how is life distributed across environments?
https://ourworldindata.org/life-by-environment #science

Uncertain ballot papers in the Cotswolds
https://timrollpickering.blogspot.com/2019/05/uncertain-ballot-papers-in-cotswolds.html

Very pleased with EU election result.
- Strong Remain (Lib Dem, Green, etc) got 40.4%
- Strong Leave (Bexit and UKIP) only got 34.9%
Don't Know (Lab and Con) got 23.2%. #EP2019

Wonder why your screws never go in straight? Make a pilot hole using pin punch and mallet first! #woodwork #maker

Quality tablecloths in quality restaurants
https://www.improbable.com/2019/04/11/the-impact-of-a-quality-table-cloth-in-a-restaurant-new-study/ #ig

Vote for a pro-eu party: Lib Dem, Green or Change UK.

Where: https://wheredoivote.co.uk/

If you want to vote tactically: https://medium.com/@Metatone/a-strawman-on-ep-election-tactical-voting-for-remainers-9b17edcdbcfd

#vote #ukpol #ep2019

Your candidates for the European Elections tomorrow https://whocanivotefor.co.uk/ #ukpol #ep2019

What happened to the buses, now that Hammersmith Bridge is closed? https://diamondgeezer.blogspot.com/2019/05/route-533.html #london #map