ferrari

The one where we interviewed Luca Ferrari

#352 — April 22, 2020

Read on the Web

???? We've got a neat bonus for you this week at the bottom of the issue ????

Postgres Weekly

Postgres Explain Visualizer 2: A Vue.js Component to Show Execution Plans — Less a standalone tool and something you’d use when building your own Postgres tooling. There is, however, a demo here. The output is really nifty.

Dalibo

Insert-Only Tables To Be Autovacuumed in Postgres 13 (But Why?) — Autovacuuming clears up dead tuples that are often left when updating or deleting data from tables, so why is autovacuuming for append-only tables a big deal in Postgres 13? Laurenz explains.

Laurenz Albe

Faster CI/CD for All Your Software Projects Using Buildkite — See how Shopify scaled from 300 to 1800 engineers while keeping their build times under 5 minutes.

Buildkite sponsor

Full Text Search in Milliseconds with Rails and Postgres — If you’ve never played with full text search with Postgres and Rails, this is a fine place to start. It covers LIKE/ILIKE, trigrams, and ‘proper’ full text searching. We also get to see how Leigh took a query from taking 130ms down to 7ms.

Leigh Halliday

An Easy Postgres 12 and pgAdmin 4 Setup with Docker — Docker provides an easy and loosely coupled way to get things set up in a development environment.

Jonathan S. Katz

Is There a Limit on Number of Partitions Handled by Postgres? — Sort of, but you’d really have to be going at it to stretch Postgres 12’s capabilities in this area.

Denish Patel

Where Do My Postgres Settings Come From? — A nice visual look at how parameters and settings cascade or override each other.

My DBA Notebook

Identify Slow-Running PostgreSQL Queries Quickly in Datadog — Improve PostgreSQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards in Datadog.

Datadog sponsor

Replicate Multiple Postgres Servers to a Single MongoDB Server using Logical Decoding Output Plugin

David Zhang

An Overview of the JOIN Methods in Postgres

Kumar Rajeev Rastogi

???? A Q&A with…
Luca Ferrari
Postgres community organizer, author, adjunct professor, and open source advocate.

Luca Ferrari has had a huge impact on the Postgres community in Italy, having been president of the Italian PostgreSQL Users Group in the past and having helped to organize the popular PGDay.it events. He also blogs frequently about Postgres and wrote PostgreSQL 11 Server Side Programming Quick Start Guide for Packt.

Note: A more complete version of this interview is on the Web.

We caught up with him to ask about server side Postgres use cases in particular:

For those who use Postgres as a simple database and haven't touched the deeper elements, where do you think they should start?

There's no single answer to this question, since Postgres is such a huge project with so many features and a rich community. I never found a project where it cannot fit in. Postgres is somehow like Unix: you cannot touch it as "just a database", you need to commit to its culture to benefit the most out of it.

In my classes, I can see that people usually get fascinated by the capabilities of doing server side programming, and that is why I decided to write my book about this topic. Often, people do not expect to be able to embed their Perl, Java, or Python libraries directly into PostgreSQL without having to rewrite their business logic in an SQL-like language.

Another great feature nowdays is the support to JSON within the database, thanks to which PostgreSQL can be used as both a relational database and a 'NoSQL' storage engine, providing a lot of flexibility in your infrastructure.

One suggestion I always gave is to join the mailing lists: there are several that differ by topic and amount of traffic. Most are very active and have high quality contributors that take care in providing accuate replies to users' questions, that spend time in reproducing errors and edge-cases, and who will help you. That's a mandatory place where you have to start, in my opinion, to better learn about the project, its features and its culture.

Where should the line be drawn between doing things in an external programming language versus within Postgres?

Often the right choice is to place business logic near the data it refers to, that is within the database itself. However, there are several things to take into account including the developer's experience and the expressiveness of SQL-derived languages like pl/PgSQL.

There's a habit of letting ORMs (Object Relational Mappers) do most of the database interaction nowadays, reducing the database to a "simple storage". Of course, databases can do a lot more, and PostgreSQL in particular can help you migrate and embed your own business logic into the database itself.

I have helped a few companies embed their own Java libraries into Postgres resulting in a more robust and coherent way to access the data (the real value) without any regard of the application they were using. Because once you start having data, you will soon find that such data is required by multiple applications in different technologies and on different platforms, so that implementing the same business logic rules over and over becomes a huge effort; on the other hand, moving such logic within the database simplifies and keep uniform the way your data is manipulated.

What one thing do you think people should learn?

Stored procedures. They serve as a common base for triggers and are very similar to routines, therefore allowing you to build more complex pieces into your own cluster. Once you have learnt the common way of defining functions, you can go deeper and write your own native functions using other languages (e.g. C). This is more complex, but thanks to the extensibility of Postgres is not an impossible task and can help you migrating more and more code into the database. Once you have created a new feature, please do contribute it back so that other people can use it!

...

Last, allow me to announce that I'm working on another book right now: me and a friend of mine are writing a more general book on Postgres that will try to answer your question by leading the reader through the main features that make Postgres unique and great.

Be sure to check out Luca's book PostgreSQL 11 Server Side Programming Quick Start Guide to learn more about the topics covered in this interview. You can also find the code from the book in this GitHub repo.

If you enjoyed this interview, Luca actually gave some more detailed answers in the full interview which you can read here.




ferrari

F1: Ferrari's Sebastian Vettel makes virtual racing debut

Ferrari star Sebastian Vettel has made his esports debut with the Legends Trophy organised by Torque Esports.

After being supplied with a simulator by Torque Esports company Allinsports, Vettel made his first appearance in esports competition fighting battles with the likes of former F1 racer and two-time Indy 500 winner Juan Pablo Montoya and fellow ex-Formula 1 World Champions Emerson Fittipaldi and Jenson Button.

Vettel's Ferrari teammate Chales LeClerc has been active on various esports platforms, participating from his Monaco apartment. LeClerc has won two virtual F1 races and taken part in a variety of other races.

Vettel finished 15th and 12th, respectively, in his two races but the four-time F1 champion was unlucky in both -- getting caught up in incidents that were not his fault on the rFactor 2 virtual version of the former home of the Malaysian Grand Prix.

Montoya finished the day as the Legends Trophy points leader. He led home Button and ex-24 Hours of Le Mans winner Emanuele Pirro in race one while finishing fifth in the reverse grid race, which was won by Fernandez over factory Aston Martin Le Mans winner Darren Turner and Pirro.

The Colombian was able to avoid first-lap drama in the opening race to take the victory.

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




ferrari

Driver takes advantage of Germany's empty autobahn to hit 231MPH in his Ferrari LaFerrari

Video footage of a Ferrari LaFerrari tearing along the German Autobahn was posted on social media. The £1.7million sports car hit 231mph racing along an unrestricted section of the motorway.




ferrari

Max Verstappen 'completely wrong' over Ferrari jibe, claims team principal Mattia Binotto 

Ferrari have responded angrily after Red Bull driver Verstappen suggested the Italian team's poor performance on Sunday was linked to the closure of a potential engine loophole.




ferrari

Ex-Ferrari chief Ross Brawn tells Sebastian Vettel and Charles Leclerc to follow Lewis Hamilton

Former Ferrari chief Ross Brawn has called on one of the Italian team's warring drivers to follow Lewis Hamilton's example and accept blame for their collision in Brazil as tension rumbles on.




ferrari

A real-estate tycoon's virtually undriven car collection is heading to auction soon, including one of the most famous Ferraris in history — take a look at all of the cars




ferrari

How Tesla's cargo capacity stacks up against other iconic front trunks in the car industry: From Ferrari, Porsche, Lamborghini, and more




ferrari

Ferrari go public about pursuit of Lewis Hamilton with Brit's contract up after the 2020 season  

JONATHAN McEVOY IN ABU DHABI: Ferrari have admitted for the first time that they are considering a move for Lewis Hamilton with his contract due to expire after the end of the 2020 racing season.




ferrari

JONATHAN McEVOY: Lewis Hamilton MUST join Ferrari

For the third successive season, Lewis Hamilton wrapped up the drivers' prize with two rounds to spare. So to what needs to happen: Hamilton joining Ferrari for the 2021 season.




ferrari

'I would welcome him': Charles Leclerc wants Lewis Hamilton to join him at Ferrari

Talk of Hamilton's future dominated the final round of the Formula One season in Abu Dhabi, as Ferrari admitted they were open to the idea of signing the sport's biggest star.




ferrari

Ferrari threaten to use team's VETO to block Toto Wolff becoming the next CEO of Formula One

The super-ambitious Wolff, currently head of Mercedes, has harboured a desire to replace Liberty Media's moustachioed Chase Carey, who is likely to relinquish his post in the next 18 months.




ferrari

Ferrari admit Lewis Hamilton has been in talks to join them in 2021

Hamilton's £40million-a-year deal with Mercedes expires at the end of next year, and Ferrari chief executive Louis Camilleri has confirmed that preliminary discussions have taken place.




ferrari

Charles Leclerc signs new Ferrari deal until 2024 as F1 team put faith in him over Sebastian Vettel

Charles Leclerc has signed a five-year contract to remain with Ferrari following a successful maiden campaign with Ferrari, rewarding the Frenchman with a new and improved deal.




ferrari

Charles Leclerc insists he and Ferrari team-mate Sebastian Vettel will not crash again

Following a number of on-track disputes last season - the pair's first together at Ferrari - their battle reached boiling point when they crashed into each other at the Interlagos circuit.




ferrari

Lewis Hamilton holds talks with Ferrari over 2021 move with doubt over Mercedes Formula One future

Lewis Hamilton's future with Mercedes is under increasing threat and the British driver could join Ferrari in 2021. He has one more season with the Silver Arrows on his £40million-a-year deal.




ferrari

Lewis Hamilton's move to Ferrari looks OFF and here's why F1 fans will be disappointed

COMMENT - JONATHAN MCEVOY: There are long years when I would have wagered life and limb on Lewis Hamilton ending his career in a Ferrari. But it no longer looks like it will be the case.




ferrari

Mercedes boss Toto Wolff vows to keep Lewis Hamilton out of the clutches of Ferrari

The British racing star's contact is set to expire at the end of the year, and the six-time world champion has been heavily linked with a move to Ferrari.




ferrari

Ferrari 'not considering' move for Lewis Hamilton after confirming Sebastian Vettel as first option

Hamilton, whose Mercedes contract is set to expire at the end of the year, had held informal talks about joining Ferrari last year but any move now looks dead in the water.




ferrari

Fittipaldi says Hamilton can cement place in history by winning with Ferrari

The British Formula One driver, who shared the Laureus World Sportsman of the Year award with Lionel Messi on Monday, has been linked with a switch from Mercedes to Ferrari.




ferrari

Jenson Button urges Ferrari star Charles Leclerc to seriously threaten Lewis Hamilton's title bid

INTERVIEW BY NATHAN SALT: Jenson Button has warned Charles Leclerc that his honeymoon at Ferrari is over and he must now put up a fight with Lewis Hamilton for the title.




ferrari

Lewis Hamilton confirms he will sit down to discuss new Mercedes contract amid Ferrari rumours

It has been reported that Hamilton could pocket around £60million from a new deal with Mercedes but he and Wolff both claimed that they have not yet spoken about figures.




ferrari

F1 revolt as SEVEN teams publish letter to FIA chiefs over agreement with Ferrari regarding engine

The seven teams, which includes Lewis Hamilton's Mercedes, Red Bull and McLaren, are concerned that that FIA's probe does not identify whether Ferrari bent the rules.




ferrari

F1 faces biggest 'cheating' accusation of the decade as teams fight against Ferrari's FIA deal

JONATHAN MCEVOY: Seven Formula One teams have threatened to take Ferrari and the governing body, the FIA, to court for hushing up a potentially illegal Ferrari engine.




ferrari

FIA defend extensive investigations into Ferrari's engine used last season

On Wednesday, seven of Formula One's 10 teams published a joint statement expressing surprise and shock at the FIA's confidential agreement with Ferrari.




ferrari

FIA boss and former Ferrari CEO Jean Todt says he struck secret deal with his old team over engine

EXCLUSIVE BY JONATHAN MCEVOY IN MELBOURNE: Todt has told Formula One's teams he took the decision to strike a settlement with his old team over their allegedly illegal engine.




ferrari

Formula One could salvage 2020 season by running into JANUARY claims Ferrari boss Mattia Binotto

Eight rounds have been postponed, and more look likely to follow with countries in lockdown, but F1 bosses have said they hope to get back on track some time in the European summer.




ferrari

Ferrari could QUIT Formula One if budget caps are reduced further in wake of the coronavirus crisis

Last year teams agreed to a budget cap of 175million US dollars (£142million) for 2021 but there have been suggestions that could be cut further.




ferrari

Ferrari's Charles Leclerc wants to go racing the 'wrong' way round as F1 bosses devise programme

The Monegasque was speaking as Formula One bosses devise a rescheduled programme to fit between 15 and 18 races into the second half of the year after the coronavirus hiatus.




ferrari

'F1 can survive without Ferrari'' insists McLaren boss Zak Brown

McLaren boss Zak Brown has claimed Formula One can live without Ferrari if they refuse to go along with a lower budget cap.




ferrari

Edwin van der Sar says Zinedine Zidane drove to training in a Fiat while team-mates drove Ferraris

Edwin van der Sar highlighted the differences between Zinedine Zidane and his Juventus team-mates by revealing he would drive a Fiat into training, while others favoured a Ferrari.




ferrari

A great week for speed fans: Ferrari deliver 'superb levels of performance' and Jose Mourinho picks up the first Jaguar F-type coupe

The 200 mph California T is set to roar into Britain from September after its world debut at next month's Geneva Motor Show, whilst the Jaguar F-Type sports coupe was launched this week.




ferrari

Ford's stupendous new GT supercar looks set to challenge Ferrari in the race for peak performance

The new model is predicted to sell for a quarter of a million pounds. The two-seater was designed by Scot Moray Callum and unveiled at the Detroit Motor Show ahead of going into production.




ferrari

Sebastian Vettel is in danger of becoming Ferrari's No 2 behind Charles Leclerc

JONATHAN MCEVOY - F1 COLUMN: Sebastian Vettel's nightmare scenario, the one that would end his career in grand prix racing, is to carry No 1 status at Ferrari in nothing but name.




ferrari

Scottish Mortgage interview: Why we hold Amazon, Tesla and Ferrari

Scottish Mortgage's co-manager Tom Slater, explains how the trust invests and why he believes 'the world's most exciting, interesting growth companies' have more good times ahead.




ferrari

Edwin van der Sar says Zinedine Zidane drove to training in a Fiat while team-mates drove Ferraris

Edwin van der Sar highlighted the differences between Zinedine Zidane and his Juventus team-mates by revealing he would drive a Fiat into training, while others favoured a Ferrari.




ferrari

Selfish driver parks their $150,000 red Ferrari 360 Spider in a disabled spot without a permit

The red Ferrari 360 was pictured in a Brisbane car park with no sign of a disabled permit.




ferrari

Lewis Hamilton's personalised Ferrari shown off by friend

Lewis Hamilton may be receiving a phone call from disgruntled Mercedes chiefs soon, after images of his personalised La Ferrari made their way online.




ferrari

As Ferrari Reopens, Staff Are Greeted With Coronavirus Blood Tests

Ferrari employees who are going back to work pass through a series of steps designed to keep the coronavirus out, including blood tests for antibodies. WSJ’s Eric Sylvers reports from the car maker’s factory near the center of Italy’s outbreak. Photo: Francesca Volpi for The Wall Street Journal




ferrari

Charles Leclerc Plays Down Prospect of Ferrari Revival Ahead of Austrian Grand Prix

Mercedes hold a commanding lead over Ferrari in both the constructors' and drivers' championships after winning a record eight straight races this season.




ferrari

Ferrari's Sebastian Vettel, Charles Leclerc Play Down Improved Pace at Austrian GP Practice

Austrian Grand Prix: Ferrari's Charles Leclerc topped in the second practice after Lewis Hamilton had won the first.




ferrari

Austrian GP: Ferrari's Charles Leclerc Grabs Pole Position, Focussed on 'Finishing the Job'

Austrian Grand Prix: Charles Leclerc of Ferrari outpaced Mercedes' Lewis Hamilton to claim the pole position.




ferrari

British GP: Charles Leclerc Fastest and Sebastian Vettel Second as Ferrari Set Pace

Ferrari drivers Charles Leclerc and Sebastian Vettel posted two fastest times in the third and final free practice session of British GP at Silverstone.




ferrari

Leclerc on Top With Vettel as Ferrari Shine in German Grand Prix Practice

Charles Leclerc topped in the second practice while Sebastian Vettel was victorious in the first practice as Ferrari started the German Grand Prix well.




ferrari

German GP: Lewis Hamilton Gets Pole, Disaster for Ferrari

Lewis Hamilton stormed to pole position at German Grand Prix, as both Ferrari drivers Charles Leclerc and Sebastian Vettel will start last after technical faults marred their qualifying.




ferrari

Ferrari Have an Illness That Needs a Cure, Says Mercedes Boss

Technical glitch became the undoing of both Charles Leclerc and Sebastian Vettel of Ferrari as Mercedes' Lewis Hamilton took the pole position at German GP.




ferrari

Michael Schumacher's Ferrari a Perfect Fit for Son Mick

Mick Schumacher drove around in F2004 car which carried his father, Michael Schumacher, to 13 wins from 18 races and his seventh and last title.




ferrari

Formula One: Charles Leclerc Pips Sebastian Vettel as Ferrari Dominate Belgian GP Practice

Charles Leclerc and Sebastian Vettel topped the timming charts as Ferrari reigned sumpreme at the Belgian GP's first two practice sessions.




ferrari

Formula One: Charles Leclerc Claims Pole as Ferrari Lock Out Front Row in Belgian GP

Ferrari got a dominant front row lockout as Charles Leclerc claimed pole and Sebastian Vettel in second at the Belgian Grand Prix.




ferrari

Ferrari's Charles Leclerc Wins Belgian GP, Lewis Hamilton Finishes Second

Charles Leclerc rode to his first Formula One victory from pole as he finished ahead of series leader Lewis Hamilton.




ferrari

Formula One: Lewis Hamilton says Ferrari Could be an Option But Loyalty is Key

Lewis Hamilton said he might one day be tempted to race for Ferrari in the Formula One but emphasised that his loyalty to Mercedes.