The Register

Biting the hand that feeds IT — Enterprise Technology News and Analysis

PostgreSQL 19 connects the dots with standardized graph queries

PostgreSQL 19 is set to add standardized SQL syntax for querying property graphs. The open source database has steadily grown in popularity over the last five years, becoming the most popular among developers for the first time in 2023. Speaking to The Register, Alastair Turner, PostgreSQL evangelist at open source consultancy Percona, said the property graph query support in PostgreSQL 19 – due later this month or early October – resulted from collaboration among several of the database's largest contributors. Graph databases store data as nodes, relationships, and properties rather than tables or documents. They have advantages for certain workloads, but adopting one can mean adding another DBMS to the technology stack. The relational database has been acquiring graph query capabilities for some time, but PostgreSQL 19 is set to go further, Turner explained. "All the rest of it has sort of been done through Object Relational Mapping over the top. This is actually baked-in graph syntax. It comes from the SQL 2023 standard." Turner said the implementation was "very heavily influenced" by some of the engineers behind OpenCypher, the open source query language for graph databases. The work also involved PostgreSQL committers who sit on the SQL standards committee. "This is one of the most interesting developments because it's one of the big multi-vendor collaborations. There was lots of coding and review work across quite a few of the big contributors," he said. The new capability implements SQL/PGQ, which became part of the SQL standard in 2023. "It's on the right path," Turner said. "The SQL community and the PostgreSQL community are going to try to optimize everything." However, he added that the implementation "still needs one or two additional syntax features" before it can displace dedicated graph databases for a significant number of workloads. Turner said: "The current implementation creates queries across node-edge graphs to satisfy those requests. So some of them perform very well. What's going to have to happen in the next iteration or two is that indexing add-ons catch up to improve the performance." ®

Kouwe drukte om IJsland

Voor Europa zou een IJslandse toetreding leuk zijn voor de balans – een rijk noordelijk land erbij in plaats van alleen armere oostelijke landen. Maar dat IJslanders de status quo prefereren, is ook prima.

West Texas Sunsets

Thomas Hawk posted a photo:

West Texas Sunsets

Found Slide

Thomas Hawk posted a photo:

Found Slide

Wait a Minute

Thomas Hawk posted a photo:

Wait a Minute

The L. Rosario Collection

Thomas Hawk posted a photo:

The L. Rosario Collection

date stamped on slide April 1967

It Sure Felt Nice

Thomas Hawk posted a photo:

It Sure Felt Nice

MetaFilter

The past 24 hours of MetaFilter

constrained but not powerless

"I suggest a small experiment. For two weeks, try living as though free will were not the most useful way to interpret behaviour. You don't need to decide whether it exists. If you live as if there is no free will, blame is no longer the default; behaviour must instead be understood in terms of the conditions that produced it."

MrBeast x James Patterson

James Patterson's latest novel, The Most Dangerous Game, is a collaboration with Jimmy Donaldson, better known as MrBeast, a YouTube star with more than half a billion subscribers. Donaldson, who appears as a character in the novel, is known for his brand of gamified philanthropy that has been called "poverty porn," and his Prime Video reality show "Beast Games" is the subject of a class-action lawsuit on behalf of its contestants. And the book? With pre-orders in the four-figure range (although disputed by the publisher), Donaldson, who hopes that his collaboration will be "the first book that [his fans have] ever read that they loved," might be relying on a $1m contest to spur sales.

"I have a lot of lines in the book," Donaldson says. "If we were lucky enough to do a movie, I wouldn't want to ruin it because I don't have much acting skills."

Rijnmond - Nieuws

Het laatste nieuws van vandaag over Rotterdam, Feyenoord, het verkeer en het weer in de regio Rijnmond

Taakstraf en boete voor minderjarige jongen uit Rotterdam (17) voor rellen op Malieveld

Een 17-jarige jongen uit Rotterdam is veroordeeld voor zijn aandeel in de rellen op het Malieveld in Den Haag. Hij sloot zich tijdens de ongeregeldheden aan bij een groep relschoppers die zich tegen de politie keerde. Vanuit die groep werden onder meer voorwerpen naar de mobiele eenheid gegooid. De jongen heeft een taakstraf van 40 uur gekregen.

Rotterdammers vrezen wraak na verdwenen cocaïne, OM eist nu jaren cel

Het Openbaar Ministerie heeft 3,5 en 3 jaar cel geëist tegen twee Rotterdammers. De twee mannen (39 en 28 jaar) worden ervan verdacht samen 23 kilo cocaïne te hebben gesmokkeld. De douane kwam de mannen op het spoor nadat de lading cocaïne vanuit Sint Maarten was gevolgd.

Wel.nl

Minder lezen, Meer weten.

Hoeveelheid ingeleverd vuurwerk stijgt tot bijna 360 kilo

DEN HAAG (ANP) - De hoeveelheid vuurwerk die mensen hebben ingeleverd bij speciale inzamelpunten is gestegen tot bijna 360 kilo. Op vrijdag konden mensen in het Gelderse Lochem afstand doen van hun vuurwerk, en daar kwam 218,5 kilo binnen, laat de gemeente weten.

In Lochem ging het om 206 kilo consumentenvuurwerk. Daarnaast ontving het inleverpunt 8,5 kilo vuurwerk met flitspoeder, zoals strijkers, en 4 kilo vuurwerk voor noodsignalen.

Eerder deze week waren er inzamelingen in Terneuzen, Middelburg en Venlo. Daar leverden mensen in totaal 140,7 kilo vuurwerk in, waarvan 103,5 kilo in Middelburg. Vergelijkbare cijfers van eerdere jaren zijn er niet.

In de komende dagen zijn er inzamelmomenten in plaatsen als Maastricht, Bergen op Zoom, Breda, Tilburg, Den Bosch en Eindhoven. De vuurwerkinzameling van de overheid duurt tot begin oktober. Bij de komende jaarwisseling is consumentenvuurwerk landelijk verboden. Alleen klein siervuurwerk, zoals sterretjes, is nog toegestaan.


Dodental Tibet na overstroming gestegen naar 31

LHASA (ANP/RTR) - Het dodental door de overstromingsramp in het Himalayagebergte is in Tibet is gestegen naar 31. Ook worden nog 531 mensen vermist, meldt staatspersbureau Xinhua.

Chinese media maakten eerder nog melding van 21 omgekomen slachtoffers. Het officiële dodental in het aangrenzende Nepal ligt veel hoger. Daar kwamen ongeveer 1300 mensen om het leven. Duizenden personen worden nog vermist.

De ramp voltrok zich eind augustus. Na een gletsjerinstorting liet een vloedgolf een spoor van verwoestingen achter in het grensgebied. Dorpen, wegen en bruggen in het bergachtige gebied werden weggevaagd.


EU-commissaris schrapt bezoek Servië om 'verheerlijking Mladić'

BRUSSEL (ANP/AFP) - Eurocommissaris voor EU-uitbreiding Marta Kos annuleert haar bezoek aan Servië dat voor september stond gepland, schrijft ze op X. Zij neemt dit besluit naar eigen zeggen vanwege "de verheerlijking" rond de dood van de voor genocide veroordeelde Bosnisch-Servische generaal Ratko Mladić.

De kist van Mladić, gedrapeerd met de Servische vlag, werd donderdag in Belgrado ontvangen door soldaten, de zoon van Mladić en de minister van Justitie. De Servische president Aleksandar Vučić zei dat de staat "alle mogelijke logistieke en transportondersteuning" zou bieden en dat hij tienduizenden mensen verwacht voor de begrafenis zaterdag.

Kos schrijft op X: "De terugkeer van zijn lichaam naar Belgrado herinnert Europa aan de donkerste bladzijden uit onze recente geschiedenis. De verheerlijking rond zijn dood is onverenigbaar met de waarden waarop de EU-route is gebouwd."

Kos veroordeelde al eerder plannen van Servië, een kandidaat-lidstaat van de EU, om Mladić met staatseer te begraven.


Granite Landscape

Darren Schiller has added a photo to the pool:

Granite Landscape

Granite Island, known traditionally as Nulcoowarra or Kaiki by the Ramindjeri and Ngarrindjeri people, is a historic landmark located just off the coast of Victor Harbor, South Australia.

Indigenous and Geological Origins Dreaming Significance: According to the Ngurunderi Creation story, the island was formed when the ancestral figure Ngurunderi cast his spear into the sea in pursuit of his wives.

Geology: The island’s signature giant granite boulders formed around 480 million years ago from magma cooled deep beneath the Earth's surface before being exposed by centuries of erosion.

European Exploration and Industry
1802 Encounter: British explorer Matthew Flinders and French explorer Nicolas Baudin met near Encounter Bay by chance.
1830s Whaling: A shore-based bay whaling station operated on the island starting in March 1837.
Quarrying: The island provided building materials and granite used across mainland South Australia.

Development of the Causeway and Tourism
1875 Causeway: A 630-meter pier and horse-drawn tramway were built to connect Granite Island to the mainland, initially helping transport cargo like wool before transitioning entirely to tourism. A modern replacement causeway officially opened in December 2021.

Iconic Tram: The Victor Harbor Horse Drawn Tramway remains one of the last operating commercial horse-drawn tram routes in Australia.

Wildlife: The island became famous for its Little Penguin (fairy penguin) colony and a popular walking circuit known as the Kaiki Walk.

Granite Island

Darren Schiller has added a photo to the pool:

Granite Island

Granite Island, known traditionally as Nulcoowarra or Kaiki by the Ramindjeri and Ngarrindjeri people, is a historic landmark located just off the coast of Victor Harbor, South Australia.

Indigenous and Geological Origins Dreaming Significance: According to the Ngurunderi Creation story, the island was formed when the ancestral figure Ngurunderi cast his spear into the sea in pursuit of his wives.

Geology: The island’s signature giant granite boulders formed around 480 million years ago from magma cooled deep beneath the Earth's surface before being exposed by centuries of erosion.

European Exploration and Industry
1802 Encounter: British explorer Matthew Flinders and French explorer Nicolas Baudin met near Encounter Bay by chance.
1830s Whaling: A shore-based bay whaling station operated on the island starting in March 1837.
Quarrying: The island provided building materials and granite used across mainland South Australia.

Development of the Causeway and Tourism
1875 Causeway: A 630-meter pier and horse-drawn tramway were built to connect Granite Island to the mainland, initially helping transport cargo like wool before transitioning entirely to tourism. A modern replacement causeway officially opened in December 2021.

Iconic Tram: The Victor Harbor Horse Drawn Tramway remains one of the last operating commercial horse-drawn tram routes in Australia.

Wildlife: The island became famous for its Little Penguin (fairy penguin) colony and a popular walking circuit known as the Kaiki Walk.

The Bluff from Granite Island

Darren Schiller has added a photo to the pool:

The Bluff from Granite Island

Granite Island, known traditionally as Nulcoowarra or Kaiki by the Ramindjeri and Ngarrindjeri people, is a historic landmark located just off the coast of Victor Harbor, South Australia.

Indigenous and Geological Origins Dreaming Significance: According to the Ngurunderi Creation story, the island was formed when the ancestral figure Ngurunderi cast his spear into the sea in pursuit of his wives.

Geology: The island’s signature giant granite boulders formed around 480 million years ago from magma cooled deep beneath the Earth's surface before being exposed by centuries of erosion.

European Exploration and Industry
1802 Encounter: British explorer Matthew Flinders and French explorer Nicolas Baudin met near Encounter Bay by chance.
1830s Whaling: A shore-based bay whaling station operated on the island starting in March 1837.
Quarrying: The island provided building materials and granite used across mainland South Australia.

Development of the Causeway and Tourism
1875 Causeway: A 630-meter pier and horse-drawn tramway were built to connect Granite Island to the mainland, initially helping transport cargo like wool before transitioning entirely to tourism. A modern replacement causeway officially opened in December 2021.

Iconic Tram: The Victor Harbor Horse Drawn Tramway remains one of the last operating commercial horse-drawn tram routes in Australia.

Wildlife: The island became famous for its Little Penguin (fairy penguin) colony and a popular walking circuit known as the Kaiki Walk.

The Guardian

Latest news, sport, business, comment, analysis and reviews from the Guardian, the world's leading liberal voice

‘I’m used to doing the impossible’: George Lucas unveils new LA museum – what’s its story?

Spaceship-shaped gallery, featuring works from Banksy, Norman Rockwell and Frida Kahlo, is devoted to ‘visual storytelling’ – and is finally ready to open

“I’m used to doing the impossible,” George Lucas said on Wednesday. But “this one almost broke my will”.

The film-maker was describing the decades of work that went into his latest project, the Lucas Museum of Narrative Art, as it was unveiled to the press in Los Angeles eight years after breaking ground, following attempts to build it in two other cities. Shaped like a spaceship and towering over the nearby University of Southern California – Lucas’s alma mater – the long-awaited institution finally opens on 22 September. It aims to be a testament to visual storytelling across all kinds of media – paintings, comics, murals, photography, sculpture.

Continue reading...

Russell Howard announces ‘devastating’ death of baby son

Comedian and his wife, Cerys Morgan, set up charitable foundation in memory of Felix, who died shortly after birth

Russell Howard has announced the death of his baby son, in what he described as the “most devastating time of our lives”.

The 46-year-old comedian said his family had been “changed for ever” after their “beautiful baby boy”, Felix, died shortly after birth.

Continue reading...

Van Weel steekt middelvinger op naar Bolle Jos

David van Weel steekt middelvinger op

Heel dapper van David van Weel, maar we hebben niet het idee dat een van z'n 30.000+ ambtenaren 'm goed heeft uitgelegd in welk wespennest hij zijn vinger prikt. Maar hey: Van Weel steekt een 'dikke middelvinger' op naar cokebaas Bolle Jos, in Engeland ook wel bekend als Fat Jos. De facto zegt Van Weel daarmee: "Bolle Jos is een GIGANTISCHE MIET." Nu hebben we nooit met Joske geknikkerd, maar we kennen 'm ook weer niet als iemand die bekendstaat om z'n zelfspot, humor of incasseringsvermogen. "Ik durf gewoon een dikke middelvinger op te steken naar Bolle Jos, en te vertellen dat we hem gaan pakken." Nou, helemaal mooi! We gaan het zien.

Soon