#pdo — Public Fediverse posts

Provolone Valpadana DOP: the art of semi-hard stretched curd cheese

Il Provolone Valpadana DOP represents the excellence of a cheese semi-hard stretched curd cheeseThis type of cheese, the result of a historic migration of dairy …
#dining #cooking #diet #food #Italiancheese #Cheese #EmiliaRomagnaandLombardy #Italia #Italian #italiancheeses #italiano #italy #Lombardia #PDO #trento #Veneto
https://www.diningandcooking.com/2756078/provolone-valpadana-dop-the-art-of-semi-hard-stretched-curd-cheese/

Provolone Valpadana DOP: the art of semi-hard stretched curd cheese

Il Provolone Valpadana DOP represents the excellence of a cheese semi-hard stretched curd cheeseThis type of cheese, the result of a historic migration of dairy …
#dining #cooking #diet #food #Italiancheese #Cheese #EmiliaRomagnaandLombardy #Italia #Italian #italiancheeses #italiano #italy #Lombardia #PDO #trento #Veneto
https://www.diningandcooking.com/2756078/provolone-valpadana-dop-the-art-of-semi-hard-stretched-curd-cheese/

Provolone Valpadana DOP: the art of semi-hard stretched curd cheese https://www.diningandcooking.com/2756078/provolone-valpadana-dop-the-art-of-semi-hard-stretched-curd-cheese/ #Cheese #EmiliaRomagnaAndLombardy #Italia #Italian #ItalianCheese #ItalianCheeses #italiano #italy #Lombardia #PDO #trento #Veneto

Provolone Valpadana DOP: the art of semi-hard stretched curd cheese https://www.diningandcooking.com/2756078/provolone-valpadana-dop-the-art-of-semi-hard-stretched-curd-cheese/ #Cheese #EmiliaRomagnaAndLombardy #Italia #Italian #ItalianCheese #ItalianCheeses #italiano #italy #Lombardia #PDO #trento #Veneto

I've made a new release for the PHP DuckDB PDO driver:

- Update to DuckDB 1.5.5
- Support for PHP 8.6
- Support for TrueAsync and Quack protocol
- More examples in the readme:
- ascii chart rendering with SQL
- LLM integration
- fetch public data
- direct data copy from MySQL/MariaDB

Binary releases are available on GitHub and can be installed or updated with PIE:

pie install thomas-0816/pdo-duckdb-php

https://github.com/thomas-0816/pdo-duckdb-php

#php #duckdb #pdo #analytics #bigdata #parquet

pdo_duckdb: a native PDO driver for DuckDB, the in-process analytical database. Query DuckDB's columnar engine through the standard PDO API, with a native appender for bulk loads and optional result streaming for big scans.

https://github.com/iliaal/pdo_duckdb
Write-up: https://ilia.ws/blog/pdo-duckdb-a-pdo-driver-for-duckdb

#php #duckdb #pdo

pdo_duckdb: a native PDO driver for DuckDB, the in-process analytical database. Query DuckDB's columnar engine through the standard PDO API, with a native appender for bulk loads and optional result streaming for big scans.

https://github.com/iliaal/pdo_duckdb
Write-up: https://ilia.ws/blog/pdo-duckdb-a-pdo-driver-for-duckdb

#php #duckdb #pdo

Arborio Rice: The Giant’s Eightieth Anniversary

Il Arborio rice It is the most internationally known Italian rice variety. Characterized by very large, pearly grains rich in starch, has become in many countries of the world the synonym of ‘risotto rice’, a record of notoriety that no other Ita…
#dining #cooking #diet #food #Italiandiet #Italia #Italian #ItalianDiet #Italianrice #italiano #italy #PDO #Risotto
https://www.diningandcooking.com/2690066/arborio-rice-the-giants-eightieth-anniversary/

Arborio Rice: The Giant’s Eightieth Anniversary

Il Arborio rice It is the most internationally known Italian rice variety. Characterized by very large, pearly grains rich in starch, has become in many countries of the world the synonym of ‘risotto rice’, a record of notoriety that no other Ita…
#dining #cooking #diet #food #Italiandiet #Italia #Italian #ItalianDiet #Italianrice #italiano #italy #PDO #Risotto
https://www.diningandcooking.com/2690066/arborio-rice-the-giants-eightieth-anniversary/

Arborio Rice: The Giant’s Eightieth Anniversary https://www.diningandcooking.com/2690066/arborio-rice-the-giants-eightieth-anniversary/ #Italia #Italian #ItalianDiet #ItalianRice #italiano #italy #PDO #Risotto

Arborio Rice: The Giant’s Eightieth Anniversary https://www.diningandcooking.com/2690066/arborio-rice-the-giants-eightieth-anniversary/ #Italia #Italian #ItalianDiet #ItalianRice #italiano #italy #PDO #Risotto

Italian asparagus: spring shoots – Gift

– Italian asparagus They represent a model of agricultural biodiversity that integrates color diversity, local traditions, and nutritional properties with potential health benefits. Analysis of the sector highlights a supply chain capable of combin…
#dining #cooking #diet #food #Italiandiet #antioxidants #IGP #Italia #Italian #Italianasparagus #ItalianDiet #italiano #italy #PDO
https://www.diningandcooking.com/2688916/italian-asparagus-spring-shoots-gift/

Italian asparagus: spring shoots – Gift

– Italian asparagus They represent a model of agricultural biodiversity that integrates color diversity, local traditions, and nutritional properties with potential health benefits. Analysis of the sector highlights a supply chain capable of combin…
#dining #cooking #diet #food #Italiandiet #antioxidants #IGP #Italia #Italian #Italianasparagus #ItalianDiet #italiano #italy #PDO
https://www.diningandcooking.com/2688916/italian-asparagus-spring-shoots-gift/

Italian asparagus: spring shoots – Gift https://www.diningandcooking.com/2688916/italian-asparagus-spring-shoots-gift/ #antioxidants #IGP #Italia #Italian #ItalianAsparagus #ItalianDiet #italiano #italy #PDO

Italian asparagus: spring shoots – Gift https://www.diningandcooking.com/2688916/italian-asparagus-spring-shoots-gift/ #antioxidants #IGP #Italia #Italian #ItalianAsparagus #ItalianDiet #italiano #italy #PDO

Culatello, the King of Italian Cured Meats: DOP and Regulations

If the Prosciutto di Parma is the ambassador of Italian delicatessen in the world, the culatello is, without a doubt, the undisputed King. This product ultra-premium It is not only th…
#dining #cooking #diet #food #Italiandiet #EmiliaRomagnaandLombardy #export #Italia #Italian #Italiancuredmeats #ItalianDiet #italiano #italy #PDO
https://www.diningandcooking.com/2676399/culatello-the-king-of-italian-cured-meats-dop-and-regulations/

Culatello, the King of Italian Cured Meats: DOP and Regulations

If the Prosciutto di Parma is the ambassador of Italian delicatessen in the world, the culatello is, without a doubt, the undisputed King. This product ultra-premium It is not only th…
#dining #cooking #diet #food #Italiandiet #EmiliaRomagnaandLombardy #export #Italia #Italian #Italiancuredmeats #ItalianDiet #italiano #italy #PDO
https://www.diningandcooking.com/2676399/culatello-the-king-of-italian-cured-meats-dop-and-regulations/

Culatello, the King of Italian Cured Meats: DOP and Regulations https://www.diningandcooking.com/2676399/culatello-the-king-of-italian-cured-meats-dop-and-regulations/ #EmiliaRomagnaAndLombardy #export #Italia #Italian #ItalianCuredMeats #ItalianDiet #italiano #italy #PDO

Culatello, the King of Italian Cured Meats: DOP and Regulations https://www.diningandcooking.com/2676399/culatello-the-king-of-italian-cured-meats-dop-and-regulations/ #EmiliaRomagnaAndLombardy #export #Italia #Italian #ItalianCuredMeats #ItalianDiet #italiano #italy #PDO

Laravel + TrueAsync: настоящая конкурентность без Swoole

В 2025 году в PHP отклонили RFC про нативные корутины. Автор не сдался и продолжил работу - так появился TrueAsync, расширение которое добавляет в PHP настоящую асинхронность без изменений в коде приложения. Я решил запустить на этом Laravel. Фреймворк проектировался под FPM-модель и совершенно не готов к тому что один воркер будет обрабатывать тысячи запросов параллельно. Как это починить без клонирования контейнера, почему PDO Pool даёт настоящую конкурентность которой нет в Swoole, и что получилось в бенчмарке против Octane.

https://habr.com/ru/articles/1024762/

#PHP #laravel #async #корутины #frankenphp #pdo #benchmark

Bresaola della Valtellina PGI: Nutrition and Market

La Bresaola della Valtellina PGI consolidates its position in the Italian delicatessen industry through a combination of technological rigor and specific climate conditions. Analysis of the sector reveals an effici…
#dining #cooking #diet #food #Italiandiet #Halal #Italia #Italian #Italiancuredmeats #ItalianDiet #italiano #italy #Kosher #Lombardia #PDO
https://www.diningandcooking.com/2595623/bresaola-della-valtellina-pgi-nutrition-and-market/

Taleggio DOP: Market, Microbiology, and Regulations

Il Taleggio DOP It is one of the most important washed-rind cheeses in the European dairy heritage, with an export share that structurally accounts for over a third of total production. The identity of this raw-cu…
#dining #cooking #diet #food #Italiancheese #Cheese #Italia #Italian #italiancheeses #italiano #italy #Lombardia #MadeinItaly #nutrition #PDO
https://www.diningandcooking.com/2574017/taleggio-dop-market-microbiology-and-regulations/

Parmigiano Reggiano: Italian market down

Parmigiano Reggiano is declining in Italy, yet strengthening its global positioning and consolidating its value. This is what emerges from the 2025 economic data presented today by the Consortium in Milan. Consumer turno…
#dining #cooking #diet #food #Italiancheese #balancesheet #Cheese #export #Italia #Italian #italiano #italy #market #ParmigianoReggiano #PDO #production
https://www.diningandcooking.com/2573120/parmigiano-reggiano-italian-market-down-2/

Parmigiano Reggiano: Italian market down

Parmigiano Reggiano is declining in Italy, yet strengthening its global positioning and consolidating its value. This is what emerges from the 2025 economic data presented today by the Consortium in Milan. Consumer turnove…
#dining #cooking #diet #food #Italiancheese #balancesheet #Cheese #export #Italia #Italian #italiano #italy #market #ParmigianoReggiano #PDO #production
https://www.diningandcooking.com/2571899/parmigiano-reggiano-italian-market-down/

#TUM:
"
Satellitendaten zeigen einen schnelleren Anstieg des Meeresspiegels um 40 Prozent zwischen 2010 und 2012.

.. wichtigen Beitrag zu einer Studie ..geleistet, die den Wasserschwund an Land, die Erwärmung der Ozeane und den Anstieg des Meeresspiegels untersucht hat.
"
https://www.ed.tum.de/ed/news-single-view-start/article/meeresspiegel-steigt-abrupt-an/

5.2.2026

#Argo #BEAST #BreakPoint #DiscoTimes #EO #Erdbeobachtung #Erdsystemforschung #ESA #GMSL #GRACE #GRACEFO #Klimawandel #Meeresspiegelanstieg #NAO #PDO #Raumfahrt #Satelliten #SLCCI #Software

#TUM:
"
Satellitendaten zeigen einen schnelleren Anstieg des Meeresspiegels um 40 Prozent zwischen 2010 und 2012.

.. wichtigen Beitrag zu einer Studie ..geleistet, die den Wasserschwund an Land, die Erwärmung der Ozeane und den Anstieg des Meeresspiegels untersucht hat.
"
https://www.ed.tum.de/ed/news-single-view-start/article/meeresspiegel-steigt-abrupt-an/

5.2.2026

#Argo #BEAST #BreakPoint #DiscoTimes #EO #Erdbeobachtung #Erdsystemforschung #ESA #GMSL #GRACE #GRACEFO #Klimawandel #Meeresspiegelanstieg #NAO #PDO #Raumfahrt #Satelliten #SLCCI #Software

To kinda answer my own question I've done some testing:

As you'd expect, there is still a difference between ->whereIn() and ->whereIntegerInRaw(), but I don't think it's very large.

It almost certainly doesn't matter when your list contains 50 values.

Interestingly the difference decreases as the set size increases.

For more details, see my blog post:

https://blog.thms.uk/2026/01/laravel-wherein?utm_source=mastodon

#Laravel #PHP #PDO

To kinda answer my own question I've done some testing:

As you'd expect, there is still a difference between ->whereIn() and ->whereIntegerInRaw(), but I don't think it's very large.

It almost certainly doesn't matter when your list contains 50 values.

Interestingly the difference decreases as the set size increases.

For more details, see my blog post:

https://blog.thms.uk/2026/01/laravel-wherein?utm_source=mastodon

#Laravel #PHP #PDO

RE: https://mstdn.social/@backpackforlaravel/115796650772319121

Is this still a thing? I thought this was fixed donkey's years ago?

Edit: When I say 'Is this still a thing' I meant 'Is the performance difference still a thing?', rather than 'does the function still exist?'

#Laravel #PHP #PDO

RE: https://mstdn.social/@backpackforlaravel/115796650772319121

Is this still a thing? I thought this was fixed donkey's years ago?

Edit: When I say 'Is this still a thing' I meant 'Is the performance difference still a thing?', rather than 'does the function still exist?'

#Laravel #PHP #PDO

Novel SQL Injection Technique in PDO Prepared Statements

https://slcyber.io/research-center/a-novel-technique-for-sql-injection-in-pdos-prepared-statements/

> Searchlight Cyber's Security Research team details a Novel Technique for SQL Injection in PDO's Prepared Statements.

This is quite an interesting read on a SQLi even if using an access pattern with prepared statements.

#sqlinjection #php #pdo #AppSec

Novel SQL Injection Technique in PDO Prepared Statements

https://slcyber.io/research-center/a-novel-technique-for-sql-injection-in-pdos-prepared-statements/

> Searchlight Cyber's Security Research team details a Novel Technique for SQL Injection in PDO's Prepared Statements.

This is quite an interesting read on a SQLi even if using an access pattern with prepared statements.

#sqlinjection #php #pdo #AppSec

Property-Hooks for the win

Property-Hooks were one of the really hot topics of last years PHP8.4 release. And I do have very strong opinions on them. They were and probably still are extremely hyped for something that in my personal opinion should be a very niche thing. In new projects you shouldn’t really need them.

But just today I had one of those situations where they helped me combine legacy code with new functionality.

The starting position

I am working on a project where we are using PDO and especially PDO::FETCH_CLASS to create Objects from our database-content.

So the code looks something like this:

function getAllFoos() : array{    $stmt = $this->executePdoQuery(<<<SQL        SELECT * FROM table        SQL);    $stmt->setFetchMode(PDO::FETCH_CLASS, Foo::class);    return $stmt->fetchAll();}

Foo looks something like this:

final class Foo {    public string a;    public string b;}

And the database-table looks something like this:

CREATE TABLE foo (    a VARCHAR(20),    b VARCHAR(20),)

Everything worked as expected and calling getAllFoos got me a list of Foo-objects.

So Far so good.

Now I wanted to add a new field to the Foo-object and that should contain an Enum. Easy peasy.

final class Foo {    public string a;    public string b;    private Status $status;}enum Status: string {    case Open = 'open';    case Closed = 'closed';}

Now I need to update the database

ALTER TABLE foo ADD COLUMN `status` VARCHAR(10) NOT NULL DEFAULT 'open';

That’s it!

When testing that though I found that it wasn’t because now everything blew up when calling getAllFoos ….

What happened?

Well, as expected the fetchAll tried to hydrate the values of the Foo object wth the values from the DB. But the DB contains a string whereas the Foo object expects the respective enum.

There is no out of the box solution to this. PDO has no idea how to convert this database-value into something the object understands (it could infer the expected enum-type from the type-hint but that can get out of hand rather quickly when it’s not an enum bot any other object that doesn’t have a ::from method or…)

Property Hooks to the rescue.

So I had to find my own way around this. And here property hooks are awesome when one has to adapt to legacy code.

So this is what my Foo class now looks like

final class Foo {    public string a;    public string b;    private Status $status {        set(string|Status $value) {            if (is_string($value)) {                $value = Status::from($value);            }                        $this->status = $value;        }    }}

Works like a charm now!

#legacy #pdo #php #propertyHooks

At first I thought this was going to be a rant about unhealthy foods, that didn't meet the presenters rigid standards.

But, instead this is a rational and well reasoned discussion about why America has so much more ultra-processed and low quality foods than the EU.

#FakeFoods #Nutrition #UltraprocessedFoods #Protected #PDO #ProtectedDesignationofOrigin #USA #EU #Food

https://youtu.be/vfehGfSTu70?si=evRHf15P3lkHKpvd

Climate models reveal how human activity may be locking the Southwest into permanent drought

The southwestern United States has been in a historic megadrought for much of the past two decades, with its reservoirs including lakes Mead and Powell dipping to record lows and legal disputes erupting over rights to use water from the Colorado River.

Research indicates that human activity may be driving drought far more than previously thought via the Pacific Decadal Oscillation.

#drought #PDO #ColoradoRiver #PacificDecadalOscillation #water

https://theconversation.com/climate-models-reveal-how-human-activity-may-be-locking-the-southwest-into-permanent-drought-262837

Climate models reveal how human activity may be locking the Southwest into permanent drought

The southwestern United States has been in a historic megadrought for much of the past two decades, with its reservoirs including lakes Mead and Powell dipping to record lows and legal disputes erupting over rights to use water from the Colorado River.

Research indicates that human activity may be driving drought far more than previously thought via the Pacific Decadal Oscillation.

#drought #PDO #ColoradoRiver #PacificDecadalOscillation #water

https://theconversation.com/climate-models-reveal-how-human-activity-may-be-locking-the-southwest-into-permanent-drought-262837

Yesterday I went to a bring-your-own #BBQ and I was surprised at how many people were surprised that I brought my own (non #PDO) #Halloumi.

Yesterday I went to a bring-your-own #BBQ and I was surprised at how many people were surprised that I brought my own (non #PDO) #Halloumi.

Better experience and fast, secure way to create a connection with MariaDB.

// Config.php

$mariadb = ini_get('pdo_mysql.default_socket');

$pdo = new PDO("mysql:unix_socket=$mariadb;dbname=test", 'root', '');

if($pdo){
echo "Database connection success!";
}

#php #mariadb #pdo #socket #mysql #mysqli #mysqlpdo

Better experience and fast, secure way to create a connection with MariaDB.

// Config.php

$mariadb = ini_get('pdo_mysql.default_socket');

$pdo = new PDO("mysql:unix_socket=$mariadb;dbname=test", 'root', '');

if($pdo){
echo "Database connection success!";
}

#php #mariadb #pdo #socket #mysql #mysqli #mysqlpdo

🚨 Two new Geographical Indications have been registered :

🇸🇰 ‘Trnavský slad’ #PGI
🇲🇹 ‘Ġbejna tan-nagħaġ’ #PDO

Find all information in the Official Journal 📘 https://europa.eu/!Jwjj3T

#GeographicalIndications #EUQuality #Slovakia #Malta
---
https://nitter.privacydev.net/EURLex/status/1884143600541524285#m

🚨 Two new Geographical Indications have been registered :

🇸🇰 ‘Trnavský slad’ #PGI
🇲🇹 ‘Ġbejna tan-nagħaġ’ #PDO

Find all information in the Official Journal 📘 https://europa.eu/!Jwjj3T

#GeographicalIndications #EUQuality #Slovakia #Malta
---
https://nitter.privacydev.net/EURLex/status/1884143600541524285#m

Right way to config with PDO.

#Mysql #mariadb #sql #php #pdo

🚨 Two new Geographical Indications registered today:

🇹🇷 Silifke Yoğurdu #PGI
🇷🇴 Jidvei #PDO

Find all information in the Official Journal 📘 https://europa.eu/!Rhbfhm

#GeographicalIndications #EUQuality #Türkiye #Romania
---
https://nitter.privacydev.net/EURLex/status/1882327264530243985#m

RT by @EUCYPRUS: Last trip to Cyprus in current capacity. Agreed priorities for 2024 aid programme. Discussed challenges for #Cyprus #reunification and #Halloumi/Hellim #PDO scheme. 7 years journey ending - I tried my best to make a difference. Thank you counterparts and colleagues @EU_reforms

🐦🔗: https://nitter.cz/KjBjornsson/status/1737373853217616239#m

[2023-12-20 07:26 UTC]

What is the recommended max number of database queries per HTTP request, assuming fully optimized queries and correctly indexed database columns? #PHP #Mezzio #Laminas #PDO #PostgreSQL #MySQL

🇧🇬De Bulgaarse gefermenteerde witte #pekelkaas "Българско бяло саламурено сирене / Bulgarsko byalo salamureno sirene" is als beschermde oorsprongsbenaming (BOB) toegevoegd aan het 🇪🇺Europese kwaliteitsregister.👇 #Bulgarije
<div class="rsshub-quote">
EUR-Lex: The name "Bulgarsko byalo salamureno sirene" has been added in the register of protected designations of origin and protected geographical indications
Find all information in the Official Journal ➡️https://europa.eu/!tgGqBh
#GeographicalIndications #EUQuality #PDO #Bulgaria
</div>

🐦🔗: https://n.respublicae.eu/EUinNL/status/1685980604238639105

The name "Bulgarsko byalo salamureno sirene" has been added in the register of protected designations of origin and protected geographical indications
Find all information in the Official Journal ➡️https://europa.eu/!tgGqBh
#GeographicalIndications #EUQuality #PDO #Bulgaria

🐦🔗: https://n.respublicae.eu/EURLex/status/1685897874255523840

Application submitted by #France for "Poulet du Bourbonnais" to be granted #PDO 🐔.
This opens the opposition phase, which lasts for 3 months.
More information in OJ C 268 🇫🇷 https://europa.eu/!PfbC6B
#GeographicalIndications #EUQuality #AOC

🐦🔗: https://n.respublicae.eu/EURLex/status/1685927280667762688

The name "Powidła śliwkowe z Doliny Dolnej Wisły" has been added in the register of protected designations of origin (PDO)
More information in Official Journal L 171 https://europa.eu/!dm7xxb
#GeographicalIndications #PDO #OfficialJournal #EUQuality #agriculture https://t.co/TZuxJwKNOg

🐦🔗: https://n.respublicae.eu/EURLex/status/1676912028827435010

#GeographicalIndications: The name "Novigradska dagnja" has been added in the register of protected designations of origin and protected geographical indications (#PDO)
More information in the Official Journal ➡️ https://europa.eu/!PWP933
#EUQuality #EUfood #Croatia https://t.co/mC8eqIjeee

🐦🔗: https://n.respublicae.eu/EURLex/status/1673935103678881792

#GeographicalIndications: The name "Çağlayancerit Cevizi" has been added in the register of protected designations of origin and protected geographical indications (#PDO)

More information here 🇹🇷 https://europa.eu/!HyXyTG

#EUQuality #EUfood #walnut #Türkiye

🐦🔗: https://n.respublicae.eu/EURLex/status/1668524540320677891