q

VE Day: The Queen addresses the nation

The Queen commemorates the 75th anniversary of VE Day with a televised address to the UK.




q

Medium-hard SQL questions to think about

#354 — May 6, 2020

Read on the Web

Postgres Weekly

pgModeler: A Postgres Database Modeler — An easy way to create and edit database models in a visual way. It’s packaged up as a paid product but is also open source so you can build your own.

Raphael Araújo e Silva

The Best Medium-Hard Data Analyst SQL Interview Questions — This article begins with a quote: “The first 70% of SQL is pretty straightforward but the remaining 30% can be pretty tricky.” True! This article focuses on the tricky ‘medium-hard’ area that few tutorials venture into.

Zachary Thomas

Monitor Custom Postgres Metrics in Real-Time with Datadog — Monitor and visualize Postgres performance in context end-to-end alongside the rest of your stack. Create custom, drag-and-drop dashboards to quickly view analytics on any Postgres metric. Try Datadog free.

Datadog sponsor

My Favorite PostgreSQL Extensions: Part Two — The second part of a series we linked to last week. This time, Nawaz takes a look at pgAudit, pg_repack, and HypoPG.

Nawaz Ahmed

Backup Manifests and pg_verifybackup in Postgres 13 — Postgres 13 will introduce two features to enhance the automated validation of physical backups: backup manifests and a new tool called pg_verifybackup.

Gabriele Bartolini

arm64 Packages Now on apt.postgresql.org — If you’re running ARM64 hardware and Debian or Ubuntu, you can now install Postgres via apt.

Christoph Berg

Speeding Up count(*): Why Not Use max(id) - min(id)? — A warning tale in case you decide to take this shortcut. While you might be able to estimate or fudge a number that’s close, you can’t guarantee sequences will give you an exact, correct answer here.

Hans-Jürgen Schönig

Using Postgres for JSON Storage — With JSON and JSONB types and associated advanced ways to query such columns, using Postgres as a store for JSON data is pretty simple. This is the briefest of overviews but leads into an interactive online tutorial.

Steve Pousty

How to Migrate From Inheritance-Based Partitioning to Declarative Partitioning — Partitioning was introduced in Postgres 10 and Postgres 11 improved the declarative partitioning support. This article demonstrates a move from inheritance based partitioning to declarative partitioning using the native features found in Postgres 11+.

Caterina Magini

Free eBook: How to Get a 3x Performance Improvement on Your Postgres Database — Learn our best practices for optimizing Postgres query performance for customers like Atlassian and how to reduce data loaded from disk by 500x.

pganalyze sponsor

How to Backup Multiple Tablespaces with pg_basebackup

Ahsan Hadi

▶  Security and Compliance with Postgres — A recorded webinar that 2ndQuadrant ran recently.

Boriss Mejías

Oracle to PostgreSQL: ANSI Outer Join Syntax in Postgres — The latest in a series of blog posts about migrating to Postgres from Oracle which looks at what Postgres offers in place of Oracle’s join operators.

Kirk Roybal

An Interview with 2ndQuadrant's Jimmy Angelakos — The latest ‘PostgreSQL Person of the Week’ to face questions about his experiences with Postgres.

Andreas Scherbaum

dadbod.vim: A Modern Database Interface for Vim — A Vim plugin for interacting with numerous databases, including Postgres.

Tim Pope

???? Upcoming Online Events

  • Postgres Pulse - weekly at 11am ET each Monday. Weekly Zoom-based sessions with folks like Bruce Momjian, Vibhor Kumar, and other people at EnterpriseDB.
  • ???? Postgres Vision 2020 on June 23-24. A full attempt at an online Postgres conference across multiple days with multiple tracks.

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




q

Why being gay in Russia is about "love and passion"

The secret moment between two gay Russian lovers that defied haters.




q

Rob Lawrie, the ex-squaddie, and the girl taken

Rob thought he was helping a refugee girl and her father as they struggled to get to the UK. But he found out it was all a lie.




q

Coronavirus will have "significant impact" on economy

Chancellor Rishi Sunak has told reporters that Covid-19 will cause "hardship ahead".




q

2008 Club World Cup Final: LDU Quito 0-1 Manchester United

Liga de Quito-Manchester United, FIFA Club World Cup Japan 2008 Final: Both teams showed impressive attacking flair, but it was Wayne Rooney's angled shot that made the difference.




q

Seven questions to Skorovich and Giustozzi

To lift the FIFA Futsal World Cup, teams must successfully negotiate seven matches, as Russia and Argentina – the Colombia 2016 finalists who will lock horns on Saturday – know all too well. Prior to that decisive duel, FIFA.com posed seven questions to the coaches of the two surviving teams. 

 




q

Angola join Egypt and Morocco to qualify for Lithuania 2020




q

South American quartet seal qualification to Lithuania 2020




q

UEFA quartet qualify for Lithuania 2020




q

Bruno Henrique: It would be amazing to face Liverpool




q

Septet set their sights on supremacy in Qatar




q

2 days to go: Real equal rivals with UAE triumph




q

Bruno Henrique inspires Flamengo into the final




q

Salah headlines Qatar 2019 award winners




q

The Russian dressing room is seen ahead of the FIFA Futsal World Cup Quarter-Final match between Russia and Spain

CALI, COLOMBIA - SEPTEMBER 24: The Russian dressing room is seen ahead of the FIFA Futsal World Cup Quarter-Final match between Russia and Spain at the Coliseo el Pueblo Stadium on September 24, 2016 in Cali, Colombia. (Photo by Ian MacNicol - FIFA/FIFA via Getty Images)




q

Brazil book quarter-final ticket with high-octane Portugal win




q

Brazil reach quarter-finals, trio bounce back




q

Five-goal Gori leads Azzurri into quarter-finals




q

Uruguay lose to Tahiti but advance to quarters on goal difference




q

First two quarter-finals confirmed as hosts bow out in style




q

Senegal spring into quarter-finals with win over UAE




q

Portugal made to sweat by Oman before punching quarter-final ticket




q

Nikonorov hat-trick leads Russia into quarters




q

Triumvirate win to complete quarter-final line-up




q

Quartet make history at Paraguay 2019








q

Fode Konate (MLI) v Iraq

Vote for your favourite goal from the FIFA U-17 World Cup India 2017 at FIFA.com. Is it this strike from Mali's Fode Konate?  




q

Mannequin Challenge at the FIFA Confederations Cup Draw

Mannequin Challenge at the FIFA Confederations Cup Draw.




q

Manuel Neuer: "We want to win every possible trophy!"

Germany's World Cup™ winner 2014, Manuel Neuer, spoke with us about the upcoming Confederations Cup in Russia.




q

2 days to go: The quickest goal in the final

Fred's lighting fast strike after two minutes against Spain in the FIFA Confederations Cup Brazil 2013 final is the quickest ever scored in the tournament's finale.




q

Javier Aquino: Budweiser Man of the Match - Mexico v New Zealand

Hear from FIFA man of the match Javier Aquino after his sides 2-1 win over New Zealand.




q

Ricardo Quaresma (POR): Portugal - Mexico

Ricardo Quaresma (POR): Portugal - Mexico




q

Rayan Yaslam of Al Ain battles for possession with Juan Quintero of River Plate

AL AIN, UNITED ARAB EMIRATES - DECEMBER 18: Rayan Yaslam of Al Ain battles for possession with Juan Quintero of River Plate during the FIFA Club World Cup UAE 2018 Semi Final Match between River Plate and Al Ain at Hazza Bin Zayed Stadium on December 18, 2018 in Al Ain, United Arab Emirates. (Photo by David Ramos - FIFA/FIFA via Getty Images)




q

Hugo Leonardo of Kashima Antlers and Lucas Vazquez of Real Madrid talk 

ABU DHABI, UNITED ARAB EMIRATES - DECEMBER 19: Hugo Leonardo of Kashima Antlers and Lucas Vazquez of Real Madrid talk during the FIFA Club World Cup semi-final match between Kashima Antlers and Real Madrid at Zayed Sports City Stadium on December 19, 2018 in Abu Dhabi, United Arab Emirates. (Photo by David Ramos - FIFA/FIFA via Getty Images)




q

Lucas Vazquez of Real Madrid and Hugo Leonardo of Kashima Antlers battle for the ball 

ABU DHABI, UNITED ARAB EMIRATES - DECEMBER 19: Lucas Vazquez of Real Madrid and Hugo Leonardo of Kashima Antlers battle for the ball during the FIFA Club World Cup semi-final match between Kashima Antlers and Real Madrid at Zayed Sports City Stadium on December 19, 2018 in Abu Dhabi, United Arab Emirates. (Photo by Francois Nel/Getty Images)




q

Juan Quintero of River Plate takes a corner

Juan Quintero of River Plate takes a corner during the FIFA Club World Cup UAE 2018 Semi Final between River Plate and Al Ain on December 18, 2018 in Al Ain, United Arab Emirates. (Photo by Michael Regan - FIFA/FIFA via Getty Images)




q

Marcos Llorente of Real Madrid celebrates with teammate Lucas Vazquez

ABU DHABI, UNITED ARAB EMIRATES - DECEMBER 22: Marcos Llorente of Real Madrid celebrates with teammate Lucas Vazquez after scoring his team's second goal during the FIFA Club World Cup UAE 2018 Final between Al Ain and Real Madrid at the Zayed Sports City Stadium on December 22, 2018 in Abu Dhabi, United Arab Emirates. (Photo by Michael Regan - FIFA/FIFA via Getty Images)




q

MS Dhoni's back...quite literally so: Chennai Super Kings share funny Thala video

You cannot blame Chennai Super Kings (CSK) for missing their favourite son in action during what would have been the 13th edition of the Indian Premier League (IPL).

Had COVID-19 not wreaked havoc, the cash-rich T20 league would have been in full swing and all eyes would have been trained on Mahendra Singh Dhoni, returning to cricket after a sabbatical.

 
 
 
View this post on Instagram

#WhistlePodu ðŸ¦ÂðŸ’› VC: @sakshisingh_r @mahi7781

A post shared by Chennai Super Kings (@chennaiipl) onMay 5, 2020 at 6:04am PDT

Dhoni, CSK's decorated captain who led India to 2007 T20 and 2011 ODI World Cup triumph besides shepherding the Yellow Brigade to three IPL crowns, has not played competitive cricket since India's 2019 World Cup semi-final loss to New Zealand.

The 38-year old was supposed to make a much-awaited comeback in the IPL and had also attended CSK's camp before the deadly virus forced sport across the world to come to a grinding halt.

CSK, on Tuesday, shared a video where Dhoni is seen spending time with daughter Ziva and his dog at his lawn in Ranchi with his back towards the camera.

"#Thala @msdhoni's back...quite literally so! Smiling face with smiling eyes #WhistlePodu," CSK captioned the tweet, crediting Dhoni's wife Sakshi for capturing the video.

The veteran wicketkeeper batsman is also seen giving the dog some catches with the ball with Ziva for company.

Meanwhile, dashing England wicket-keeper batsman Jos Buttler has said that Dhoni has always been a big idol and while playing in the IPL one lesson for him has been how the former India skipper manages all the fanfare and still performs in crunch situations.

"MS Dhoni has always been a big idol of mine and chaos is always going around him, people wanting a bit of him, the cricket and the noise.

"....it is such a great lesson to just watch him and see first hand how to manage all that thing if you have to perform at the top level and perform in those crunch moment, that certainly has been one of the massive pluses," Buttler said in an interview to Lancashire Cricket with Warren Hegg.

Catch up on all the latest sports news and updates here. Also download the new mid-day Android and iOS apps to get latest updates.

Mid-Day is now on Telegram. Click here to join our channel (@middayinfomedialtd) and stay updated with the latest news

This story has been sourced from a third party syndicated feed, agencies. Mid-day accepts no responsibility or liability for its dependability, trustworthiness, reliability and data of the text. Mid-day management/mid-day.com reserves the sole right to alter, delete or remove (without notice) the content in its absolute discretion for any reason whatsoever




q

Give yourself a unique weekend, go crazy with paints at this event in Mumbai

Go crazy with paints
Give yourself a unique weekend and enjoy a party with lots of colours! Paint away all the week's troubles and discover the hidden artist in you. Gorge on food, sip on a drink while you’re at it. Who knows? Maybe it’ll pave the way for the next masterpiece on your wall.
ON May 26, 12 pm onwards
At Tea Villa Cafe, Vashi, Navi Mumbai.
CALL 8080850000
LOG ON TO insider.in cost Rs 1,500

Catch up on all the latest Crime, National, International and Hatke news here. Also download the new mid-day Android and iOS apps to get latest updates





q

Watch this mosquito-inspired drone light up and avoid a crash

Technology avoids obstacles by sensing air flow disruptions




q

The Week in Quotes




q

The Week in Quotes




q

The Week in Quotes




q

It's story time for Inaaya Naumi Kemmu and Soha Ali Khan amid quarantine

Different Bollywood celebrities are indulging in different activities at home to spend time amid the quarantine and lockdown issued by Prime Minister Narendra Modi. Some are cleaning their homes and many are sharing their workout videos. Soha Ali Khan's daughter Inaaya Naumi Kemmu have something else in mind.

Taking to her Instagram account, actress and mother Soha shared an immensely adorable picture of Inaaya arranging book in her playroom. The toddler looked cute in her black t-shirt and pink checkered trousers. The post was captioned as, ''Booked for the week! #lockdown #stoppedcountingthedays #storytime(sic).''

 
 
 
View this post on Instagram

Booked for the week! #lockdown #stoppedcountingthedays #storytime

A post shared by Soha (@sakpataudi) onApr 21, 2020 at 12:26am PDT

If you go to her Instagram account, she has been sharing pictures and videos of her family on Instagram account. She regularly updates us about her quarantine time. Recently, she shared a picture of her husband Kunal Kemmu and Inaaya. The father-daughter duo is seen peeling pees in the image! "It's just a 'matar' of time...#lockdown...#stayhome..#twopeasinapod (sic)," Soha captioned the picture.

 
 
 
View this post on Instagram

A post shared by Soha (@sakpataudi) onApr 15, 2020 at 1:46am PDT

Before this, Soha had shared an immensely adorable picture of Inaaya who could be seen sitting with her bunch of teddy bears and captioned it- House party Day 6. She also used the hashtag- Lockdown.

 
 
 
View this post on Instagram

House party Day 6 #lockdown

A post shared by Soha (@sakpataudi) onMar 29, 2020 at 10:42pm PDT

Catch up on all the latest entertainment news and gossip here. Also, download the new mid-day Android and iOS apps.

Mid-Day is now on Telegram. Click here to join our channel (@middayinfomedialtd) and stay updated with the latest news




q

B-town buzz: Hema Malini is spending lockdown with pets; Jubin Nautiyal is quarantining in Dehradun

While husband Dharmendra is at their Lonavala farm, Hema Malini is spending lockdown at her Juhu home with pet dogs. The veteran star provided a glimpse of her 'special family members' on Twitter. She shared pictures of Snoopy, the stray she adopted as a puppy. She also has a Golden Retriever called Gypsy "who has now grown old and spends the entire afternoon with me (sic)."

Song of the hills

Jubin Nautiyal is spending lockdown in hometown Dehradun. The Tum hi aana singer is keeping fans entertained through virtual performances from his rooftop. Considering the picturesque backdrop in the hilly terrain, fans have now asked for a virtual concert. He has lined up a show on April 26, which will stream live on his social media handles. Nautiyal will render Bollywood as well as English tracks.

Catch up on all the latest entertainment news and gossip here. Also, download the new mid-day Android and iOS apps.

Mid-Day is now on Telegram. Click here to join our channel (@middayinfomedialtd) and stay updated with the latest news




q

David Dhawan on Varun's birthday celebrations: It will be a quiet family affair

When normalcy returns, Varun Dhawan may well host a glitzy bash that mentor Karan Johar would approve of. For now though, an intimate celebration is on the cards for the star who turns 33 today. The actor plans to spend the big day with dad David, mother Lali, brother Rohit and family, who stay a few floors above him in a Juhu highrise.

It was originally supposed to be a working birthday for the actor as Coolie No 1 was slated to release on May 1. "The family had considered formally announcing Varun's engagement to long-time girlfriend Natasha Dalal on the occasion. However, given the current scenario, they have decided to do it at an appropriate time," says a source.


David Dhawan

Though tight-lipped on the subject of Varun-Natasha's engagement, filmmaker David says he is glad the family is together on the star's big day. "It will be a quiet family affair. Over the past few weeks, Varun has been with us, and has been taking care of Lali and me. He is especially concerned about me as I am diabetic," he says. Ask him about the fate of Coolie No 1, and the filmmaker says, "It's my 45th film as a director. I think people will want to watch comedy [post the crisis]. Work on the film is underway."

Catch up on all the latest entertainment news and gossip here. Also, download the new mid-day Android and iOS apps.

Mid-Day is now on Telegram. Click here to join our channel (@middayinfomedialtd) and stay updated with the latest news