bi

Tiger survival threatened by mass road-building in precious habitats

Over half the world’s wild tigers now live 5 kilometres from a road, and infrastructure projects planned in Asia could fragment their habitat further




bi

People put on ventilators for covid-19 may need lengthy rehabilitation

Healthcare systems need to prepare for the extensive physiotherapy and mental rehabilitation that people put on ventilators for covid-19 will need as they recover




bi

Pondering the big question of consciousness is a welcome distraction

Our best mathematical theory of consciousness is sparking a rethink of one of science’s hardest problems – how simple matter gives rise to a complex mind




bi

A Japanese nuclear power plant created a habitat for tropical fish

A small increase in water temperature near a Japanese nuclear power plant allowed tropical fish to colonise the area, suggesting global warming will drastically alter some marine ecosystems




bi

Bi-Powered





bi

One of world's oldest men marks 116th birthday in South Africa

South African Fredie Blom celebrated his 116th birthday on Friday unfazed by the coronavirus crisis, over 100 years since the Spanish flu pandemic killed his sister. "I have lived this long because of God's grace," said Blom, possibly one of the oldest men in the world. Lighting a cigarette, he recalled the 1918 pandemic that left tens of millions dead worldwide including his sister.





bi

Biden's lead over Trump widens – but strain on his virtual campaign grows

Coronavirus has robbed the Democrat of his typical back-slapping approach as he faces growing scrutiny and a third-party challengeThe Tampa, Florida, rally for Joe Biden on Thursday evening began as it normally might have, before a once-in-a-century pandemic transformed all aspects of American life, including the presidential campaign. A local high school student recited the pledge of allegiance, a campaign organizer pleaded with supporters to volunteer and a local DJ spun R&B music between speakers.But in a sign of how profoundly the coronavirus crisis has reshaped American politics, that was where the similarities ended.With much of the US still in lockdown, the presumptive Democratic presidential nominee has been forced to take his campaign to unseat Donald Trump online. It has not always been easy.His campaign’s first attempt to recreate a traditional rally – part of a virtual swing through the battleground state of Florida – was later described by his opponents as an “unmitigated technological failure”. The video stream was glitchy and pixelated. The audio was choppy, rendering some remarks nearly incomprehensible. And there were lengthy delays between speakers and at one point, the feed went dark for several minutes.“Am I on?” asked Biden, beaming into the telecast from his home in Wilmington, Delaware, where he has been isolated since the middle of March. An off-camera voice replied that he was. Biden removed a pair of aviator sunglasses as he walked toward the camera.“Good evening, Tampa. Thanks so much for tuning in,” he continued, a hint of irritation in his voice. “I wish we could have done this together – and it had gone a little more smoothly.”For nearly two months, Biden has been the test subject in a novel political experiment: running for president in the age of Covid-19.Social distancing restrictions imposed to stop the spread of the virus have already starved the campaign of a victory tour to mark his ascent to the Democratic nomination. It may well deny Democrats the chance to formally nominate him in person at the party’s national convention this summer. Endorsements from former rivals and party leaders occur online to varying degrees of fanfare. . The remote set-up, anathema to Biden’s back-slapping, glad-handing approach to politics, has left the candidate walled off from voters and competing for visibility.Yet, technical difficulties aside, his campaign of confinement seems to be working.In recent weeks, Biden has widened his lead over Trump as the president’s support slips amid growing disapproval of his response to the pandemic. Surveys from Pennsylvania, Michigan, Wisconsin, Florida, North Carolina and Arizona – key battlegrounds that Trump won in 2016 – show Biden ahead. At a recent virtual fundraiser last week, Jennifer O’Malley Dillon, his new campaign manager, expressed optimism about Biden’s prospects in Florida and Arizona.“The natural state of this race is to be a referendum on Donald Trump and every time Donald Trump steps to the microphone he hurts himself,” said Mark Mellman, a veteran Democratic pollster. “That’s a pretty good position for Joe Biden to be in.”Biden initially struggled to adapt to his cloistered reality. In March, the campaign turned a recreation room in the basement of his home into a studio, though not fast enough for his critics, who launched a “Where’s Joe” campaign to mark the candidate’s relative disappearance from the national stage.But since then, Biden has been busy. Nearly every day he makes appearances on local TV news channels or national talkshows. He launched a podcast, where he has hosted conversations with prominent Democratic governors and potential vice-presidential candidates. He spends time each day speaking with a voter – a frontline worker, campaign volunteers – and he participated in what the campaign billed as a “virtual rope line”.“So what’s up?” he said to Ashley Ruiz of Fort Lauderdale, Florida, one of several voters on the rope line. “Tell me about your situation, Ash.”•••Biden’s rise in the polls comes as he contends with an allegation from Tara Reade, a former aide in his Senate office who accused him of sexual assault in 1993. In an interview this week with Megyn Kelly, the former Fox News and NBC television host, Reade said he should withdraw from the presidential race.Biden has forcefully denied the allegation. “It’s not true, I am saying unequivocally. It never, never happened,” he said last week, in an interview addressing her claim for the first time publicly.Publicly, Democrats, including prominent MeToo advocates, have rallied around Biden, though privately some in the party have expressed concern about the continuous drip of reporting on the matter.So far the allegation appears to have marginally dented his reputation, but not his lead. Most voters – 86% – are aware of the allegation, according to a Monmouth poll, which found the electorate divided over whether they viewed the claim as credible. At the same time, the poll showed Biden nine points ahead of Trump.Despite Trump’s falling electoral fortunes, many Democrats remain anxious about Biden’s position – and his strategy.David Axelrod and David Plouffe, two of Barack Obama’s top campaign strategists, implored Biden’s campaign to expand its digital footprint in a joint New York Times op-ed that compared the atmospherics of the candidate’s home videos to “an astronaut beaming back to earth from the International Space Station”.“Online speeches from his basement won’t cut it,” they wrote.Lis Smith, the former top adviser to Pete Buttigieg’s presidential campaign, followed with an op-ed on Thursday that offered a blueprint for turning Biden into the “hottest bad boy and disrupter in the media game”. She suggested his campaign use TV appearances and digital content to highlight Biden’s empathy, a trait even supporters say the president has lacked in response to the rising coronavirus death toll.Part of the campaign’s evolving digital strategy includes partnering with groups that already have an online presence, like JoeMamas2020, a national coalition of “moms, caregivers, moms to be, aunts & all the parental figures in between” with about 27,000 Facebook and 1,200 Twitter followers. The group has helped amplify Biden’s appearances and policy proposals while spreading the word about upcoming events.Julie Zebrak, the group’s co-founder, said the online army is growing with women energized to help elect a candidate who would end the Twitter presidency.“We are all extremely enthusiastic for Joe Biden to beat Donald Trump,” she said.Yet the same traits that endear Biden to a growing coalition of suburban women and Never Trump Republicans have largely failed to excite younger, progressive voters. It’s not that they prefer Trump – they don’t – but a lack of enthusiasm among those voters could spell trouble in November if they stay home or vote for a third-party candidate.The campaign has also ramped up its outreach to young people, who overwhelmingly supported Biden’s rival Bernie Sanders. On Friday, Biden presented his economic pitch in an appearance on NowThis, a social-media-heavy news outlet with a young, progressive audience.“This crisis hit harder and will last longer because Donald Trump spent the last three years undermining the core pillars of our economic strength,” Biden said in remarks that attacked Trump’s stimulus efforts a kind of “cronyism” and corporate welfare. Before he began speaking, Biden removed a face mask, a pointed rebuke of the president who had refused to wear one.Still, new research conducted on behalf of NextGen America found many young people weren’t convinced Biden’s policies meet the scale of the challenges bearing down on their generation.This makes the efforts of groups like Progressive Turnout Project, which endorsed him this week, all the more important. In the coming months, the group is investing more than $52m to turn out low-propensity Democratic voters – including young people and people of color – in 17 key battleground states.“The best thing we can do is go and knock on doors and have face-to-face conversations with voters,” said Alex Morgan, the group’s executive director. “We are still looking to do that. But it’ll be knocking on that door and then taking a few big steps back and having a more distant conversation.”•••Biden’s campaign also faces another looming threat. The Michigan congressman Justin Amash, who left the Republican party last year after voting to impeach Trump, recently announced that he would seek the Libertarian party nomination.His entrance has alarmed Democrats, who fear he could siphon off Never Trump voters who might otherwise back Biden, particularly in Amash’s home state of Michigan, where third-party candidates pulled away a combined 5% of the vote share in 2016. Hillary Clinton lost the state by just 10,704 votes, less than 0.25%.Many Democrats believe Biden’s fate may well rest on his ability to persuade their own side to vote.“Trump has shown no desire or ability to moderate for those swing voters in this election,” said Addisu Demissie, who served as Cory Booker’s presidential campaign manager. “So those voters are now likely going to end up either Biden voters or non-voters or third-party voters, and that’s the competition.”This week, Trump traveled to the battleground state of Arizona, where he toured a medical mask facility without wearing one himself. The visit was a symbolic show of his administration’s push to reopen the US economy but there were unmistakable elements of his signature campaign rallies, including the music that played when Trump finished his remarks (the Rolling Stones’ You Can’t Always Get What You Want).Trump’s cross-country venture stood in striking contrast to Biden’s virtual swing through Florida – which included a rally, a roundtable in Jacksonville and an appearance on the local news in Tampa. The technical glitches only further highlighted the limitations of his confinement.But the coronavirus has also upended Trump’s strategy, erasing the booming economy he has made a centerpiece of his re-election campaign. In recent weeks, his campaign has all but abandoned championing the president’s leadership, instead focusing its efforts on diminishing Biden.Trump’s campaign manager, Brad Parscale, previewed the onslaught on Twitter this week, comparing the Trump re-election juggernaut to the Death Star from the Star Wars movies. “In a few days we start pressing FIRE for the first time,” he wrote.As Trump prepares to make even greater use of the advantages of incumbency, Biden faces his biggest test yet. Can he really lead a Rebel Alliance from his basement?





bi

A 1996 court declaration written by Tara Reade's ex-husband shows she spoke of harassment in Biden's Senate office

"It was obvious that this event had a very traumatic effect on (Reade), and that she is still sensitive and effected (sic) by it today," Dronen wrote.





bi

James Clapper Said He ‘Never Saw Direct Empirical Evidence’ of Trump-Russia Collusion in FBI Interview

Former director of national intelligence James Clapper in 2018 said that he hadn't seen evidence that the Trump presidential campaign colluded with Russia to win the 2016 general election.Clapper was responding to a query from then-representative Tom Rooney, a Florida Republican, during an interview before the House Intelligence Committee. The transcript of the interview was released on Thursday."I never saw any direct empirical evidence that the Trump campaign or someone in it was plotting [or] conspiring with the Russians to meddle with the election," Clapper said."That's not to say that there weren't concerns about the evidence we were seeing, anecdotal evidence…[redacted]," Clapper added. "But I do not recall any instance when I had direct evidence of the content of these meetings. It's just the frequency and prevalence of them was of concern."Rooney then asked Clapper, "At what time is collusion collusion, and at what time is it just people that may have an affiliation with the campaign meeting or talking with… the Russian ambassador or somebody that's of Russian origin, and when should that be taken as something that rises to the level of an Intelligence Community concern?""I really can't answer it other than the sort of visceral reaction to why all these meetings with the Russians," Clapper responded. Clapper admitted that it would be "legitimate" for incoming Trump administration officials to meet with representatives of Russia, "but I think there is a line…between that and violating the principle that in this country we traditionally have one President and one administration at a time."The interview was part of a set of 53 transcripts of interviews held by the House Intelligence Committee as part of the Russia investigation. Current committee chairman Adam Schiff had called for the release of the transcripts in 2018.However, after 43 transcripts had been reviewed and redacted by intelligence agencies as of June 2019, Schiff refused to relase the completed transcripts to the public. Current acting DNI head Richard Grenell informed Schiff on Wednesday that all the transcripts were ready for publication.





bi

Ex-husband of Biden accuser Tara Reade said she told him of being sexual harassed: report

Biden has repeatedly denied Reade's allegation.





bi

Trump calls Ahmaud Arbery killing 'very disturbing' but says he trusts Georgia justice

President Trump said he had watched the video of Ahmaud Arbery being shot and found it “heartbreaking,” but he has confidence in the Georgia legal system.





bi

Labour Party: Starmer moves to rein in shadow cabinet spending plans

Leaked letter from shadow minister reveals attempt to impose discipline on top team, writes Iain Watson.




bi

Coronavirus: Boris Johnson 'bitterly regrets' care home crisis

The PM says government is "working hard" to tackle it - and sets 200,000 test aim by end of month.




bi

Coronavirus lockdown: UK 'should not expect big changes'

The PM will set out a "cautious" road map for the UK in his speech on Sunday, a cabinet minister says.




bi

The FBI said I was my parents' stolen baby - but I found the truth

Foundling Paul Fronczak was given to a family whose baby had been stolen - but was he really their son?




bi

Coronavirus: Andy Serkis reads entire Hobbit live online for charity

More than 650,000 watch the Gollum actor narrate Tolkien's fantasy classic in one 11-hour sitting.




bi

Coronavirus: Concerns for wellbeing of babies born in lockdown

New mothers are missing out on support for their babies amidst lockdown restrictions.




bi

A panel on accessibility, design inclusion and ethics, hiring and retaining diverse talent, and landing a job in UX.

It’s one thing to seek diverse talent to add to your team, another to retain the people you’ve hired. Why do so many folks we bring in to add depth and breadth of experience to our design and business decision-making process end up leaving? Hear thoughtful, useful answers to this question and other mysteries of […]

The post A panel on accessibility, design inclusion and ethics, hiring and retaining diverse talent, and landing a job in UX. appeared first on Zeldman on Web & Interaction Design.




bi

An intro to making Postgres high availability on Kubernetes

#351 — April 15, 2020

Read on the Web

Postgres Weekly

A Detailed Look at pg_show_plans — A few issues ago we linked to a basic introduction to pg_show_plans – this goes a little further. pg_show_plans lets you look at the execution plans of slow queries in real time as they’re being executed which can help you when troubleshooting.

Kaarel Moppel

Intersecting GPS Tracks to Identify Infected Individuals — I’m not a huge fan of COVID-19 related content, but this is a pretty interesting technique with numerous use cases. Essentially it uses PostGIS to identify overlapping paths.

Florian Nadler

Online Training: Learn PostgreSQL from Home — The remote PostgreSQL Database Administration training course is available at a discounted rate & will be conducted in two different timezones. The course covers day-to-day DBA operations, monitoring, server configurations, and more.

2ndQuadrant PostgreSQL Training sponsor

PostgreSQL's 'Related Projects' — Thanks to Andreas Scherbaum for pointing out a new page on the Postgres site dedicated to projects related to Postgres like the code that runs the Postgres web site, mailing list, build farm, package management system, etc.

PostgreSQL Global Development Group

Authentication Configuration in Postgres (and CockroachDB) — In Postgres, client authentication can be controlled via a ‘HBA’ (host-based authentication) file. It’s not something we see covered very often, so you might find this interesting, particularly as it compares things against CockroachDB.

Raphael ‘kena’ Poss

▶  Easy And Correct High Availability Postgres with Kubernetes — A 50 minute talk from PostgresOpen 2019 that goes all the way ‘from containers up’ until actually doing stuff with Postgres.

Steven Pousty

How To Set Up an Express API Backend Project With Postgres — A pretty extensive walkthrough of creating an HTTP API using Express with Node.js and Postgres on the backend, then deploying it all on Heroku.

Chidi Orji

A Beginners Guide to Basic Indexing in Postgres

James Bannister

eBook: The Most Important Events to Monitor in Your Postgres Logs — In this eBook, we are looking at the Top 6 Postgres log events for monitoring query performance and preventing downtime.

pganalyze sponsor

Documenting the Citus Extension to Postgres: An Interview with Joe Nelson — Joe, a.k.a. begriffs, talks about why he works on documentation, why the multi-tenant and real-time analytics tutorials matter, the INSERT..SELECT with repartitioning feature, and what development platform Citus uses for docs.

Citus Data (Microsoft)

Procedural vs Query Approaches for Finding Packages — Explorations of a query that can be used to display which packages are available for a given FreeBSD port. Get your head around the data model and the ideas here apply to all sorts of situations.

Dan Langille

???? Upcoming Events

All in-person events we had listed are cancelled or postponed due to the COVID outbreak, so we're now linking to webinars, livestreams, and similar online events.

If you have any, just hit reply and if it's Postgres related (and either free or not too expensive) we'll include it in a future issue. Just one this week:

???? – requires e-mail address or registration
???? – costs money to participate

???? Seen on Twitter

Saw this tweet and thought it was a pretty neat reminder of the sorts of things we can do with Postgres. Justin kindly let us include it:

Click through to the original tweet if you want to see the code better. Neat use for a generated column!




bi

'How do I convince the Home Office I'm a lesbian?'

More than 1,500 people claim asylum in the UK each year, claiming that they are persecuted for being gay. But it's not an easy thing to prove.




bi

Birth in a pandemic: 'You are stronger than you think'

Coronavirus is throwing many birth plans up in the air and leading some health trusts to increase home births.




bi

Dirty streaming: The internet's big secret

Figures suggest that IT now generates as much CO2 as flying, with some arguing it's nearly double.




bi

Sex, Disability, and Sex and Disability

Disability and sex is a topic around which there are a lot of misconceptions, but what do disabled people think when people get awkward talking about sex with them?




bi

Bill Gates: Few countries will get 'A-grade' for coronavirus response

The Microsoft billionaire says we find ourselves in uncharted territory with the coronavirus pandemic.




bi

Vote for your favourite goal of Colombia 2016

The FIFA Futsal World Cup Colombia 2016 saw some superb strikes that will stay in the memory of all who witnessed them live. But which was the most outstanding? Watch the ten goals and choose which one, in your opinion, was the very best?




bi

Lozano: Colombia 2016 is a turning point

Javier Lozano is much more than an authority on futsal. With two FIFA Futsal World Cup titles to his name during his time in charge of Spain, the former coach is now one of the sport’s gurus, a status he has attained thanks to his achievements and the legacy he left behind.




bi

Jubilant Solo retain crown but Oceanian gap narrows




bi

Vaporaki: World Champions badge brings great responsibility

Vaporaki: the badge of world champion brings great responsibility




bi

Gabi, a serial leader from Simeone to Xavi




bi

Henderson’s Liverpool 'box set' hinting at big crescendo




bi

Mahdi Javid (R) of Iran and Robinho (L) of Russia fight for the ball

MEDELLIN, COLOMBIA - SEPTEMBER 27: Mahdi Javid (R) of Iran and Robinho (L) of Russia fight for the ball during the FIFA Futsal World Cup Semi-Final match between Iran and Russia at Coliseo Ivan de Bedout stadium on September 27, 2016 in Medellin, Colombia. (Photo by Alex Caparros - FIFA/FIFA via Getty Images)




bi

Hossein Tayebi of Iran battles with Vladislav Shayakhmetov of Russi

MEDELLIN, COLOMBIA - SEPTEMBER 27: Hossein Tayebi of Iran battles with Vladislav Shayakhmetov of Russia during the FIFA Futsal World Cup semi-final match between Iran and Russia at Coliseo Ivan de Bedout on September 27, 2016 in Medellin, Colombia. (Photo by Jan Kruger - FIFA/FIFA via Getty Images)




bi

Hossein Tayebi (R) of Iran and Danil Davydov (L) of Russia compete for the ball

MEDELLIN, COLOMBIA - SEPTEMBER 27: Hossein Tayebi (R) of Iran and Danil Davydov (L) of Russia compete for the ball during the FIFA Futsal World Cup Semi-Final match between Iran and Russia at Coliseo Ivan de Bedout stadium on September 27, 2016 in Medellin, Colombia. (Photo by Alex Caparros - FIFA/FIFA via Getty Images)




bi

Adil Habil #8 of Morocco takes a shot from behind the center line

BUCARAMANGA, COLOMBIA - SEPTEMBER 18: Adil Habil #8 of Morocco takes a shot from behind the center line during Group F match play between Spain and Morocco in the 2016 FIFA Futsal World Cup at Coliseo Bicentenario on September 18, 2016 in Bucaramanga, Colombia. Habil scored on the shot. (Photo by Victor Decolongon - FIFA/FIFA via Getty Images)




bi

A Montage showing Sergey Skorovich, coach of Russia, and Diego Giustozzi, coach of Argentina, at the FIFA Futsal World Cup Colombia 2016

A Montage showing Sergey Skorovich, coach of Russia, and Diego Giustozzi, coach of Argentina, at the FIFA Futsal World Cup Colombia 2016




bi

The official ball of the Colombia 2016 FIFA Futsal World Cup

The official ball of the Colombia 2016 FIFA Futsal World Cup is photographed ahead of the final match at the Coliseo El Pueblo stadium, in Cali, Colombia on October 1, 2016. / AFP / LUIS ROBAYO




bi

Miguel Castro (L) of Portugal conducts the ball next to Hossein Tayebi (R) of Iran

CALI, COLOMBIA - OCTOBER 01: Miguel Castro (L) of Portugal conducts the ball next to Hossein Tayebi (R) of Iran during the FIFA Futsal World Cup Third Place Play off match between Iran and Portugal at the Coliseo El Pueblo stadium on October 1, 2016 in Cali, Colombia. (Photo by Alex Caparros - FIFA/FIFA via Getty Images)




bi

Miguel Castro (L) of Portugal conducts the ball next to Hossein Tayebi (R) of Iran

CALI, COLOMBIA - OCTOBER 01: Miguel Castro (L) of Portugal conducts the ball next to Hossein Tayebi (R) of Iran during the FIFA Futsal World Cup Third Place Play off match between Iran and Portugal at the Coliseo El Pueblo stadium on October 1, 2016 in Cali, Colombia. (Photo by Alex Caparros - FIFA/FIFA via Getty Images)




bi

Joao Matos of Portugal vies with Hossein Tayebi of Iran

CALI, COLOMBIA - OCTOBER 01: Joao Matos of Portugal vies with Hossein Tayebi of Iran during the FIFA Futsal World Cup Third Place play off match between Iran and Portugal at the Coliseo el Pueblo Stadium on on October 1, 2016 in Cali, Colombia. (Photo by Ian MacNicol - FIFA/FIFA via Getty Images)




bi

Pedro Cary (R) of Portugal and Hossein Tayebi (L) of Iran fight for the ball

Pedro Cary (R) of Portugal and Hossein Tayebi (L) of Iran fight for the ball during the FIFA Futsal World Cup Third Place Play off match between Iran and Portugal at the Coliseo El Pueblo stadium on October 1, 2016 in Cali, Colombia. (Photo by Alex Caparros - FIFA/FIFA via Getty Images)




bi

Joao Matos of Portugal vies with Hossein Tayebi of Iran

Joao Matos of Portugal vies with Hossein Tayebi of Iran during the FIFA Futsal World Cup Third Place play off match between Iran and Portugal at the Coliseo el Pueblo Stadium on on October 1, 2016 in Cali, Colombia. (Photo by Ian MacNicol - FIFA/FIFA via Getty Images)




bi

Enock Mwepu (ZAM) - Zambia v Iran

Enock Mwepu (ZAM) -  Zambia v Iran




bi

Colombia 0-1 Ghana (India 2017)

Watch highlights of the Group A match between Colombia and Ghana at the FIFA U-17 World Cup India 2017.




bi

India 1-2 Colombia (India 2017)

Watch highlights of the Group A match between India and Colombia at the FIFA U-17 World Cup.





bi

Colombia 0-4 Germany (India 2017)

Watch highlights of the Round of 16 match between Colombia and Germany at the FIFA U-17 World Cup.




bi

Jann-Fiete Arp (GER) v Colombia

Vote for your favourite goal from the FIFA U-17 World Cup India 2017 at FIFA.com. Is it this strike Germany's Jann-Fiete Arp? 




bi

Birthday boy Vela eyes Russian success

The Mexican and Real Sociedad striker discusses the importance of the FIFA Confederations Cup as well as his history with Arsenal and at the 2010 FIFA World Cup. 




bi

Describing Russia in one word

The seven coaches who know they will be spending the summer in Russia at the FIFA Confederations Cup - Stanislav Cherchesov, Anthony Hudson, Joachim Low, Juan Antonio Pizzi, Juan Carlos Osorio, Fernando Santos and Ange Postecoglou – come up with some interesting ways to describe the host country!