#pdo — Public Fediverse posts

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/

Bresaola della Valtellina PGI: Nutrition and Market https://www.diningandcooking.com/2595623/bresaola-della-valtellina-pgi-nutrition-and-market/ #Halal #Italia #Italian #ItalianCuredMeats #ItalianDiet #italiano #italy #Kosher #Lombardia #PDO

Salento DOP Olive Oil: A Rebirth in the New Specification https://www.diningandcooking.com/2581037/salento-dop-olive-oil-a-rebirth-in-the-new-specification/ #ExtraVirginOliveOil #Italia #Italian #ItalianOlive #ItalianOliveOil #italiano #italy #Olive #OliveOil #OrganicFarming #PDO #puglia

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/

Taleggio DOP: Market, Microbiology, and Regulations https://www.diningandcooking.com/2574017/taleggio-dop-market-microbiology-and-regulations/ #Cheese #Italia #Italian #ItalianCheese #ItalianCheeses #italiano #italy #Lombardia #MadeInItaly #nutrition #PDO

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 https://www.diningandcooking.com/2573120/parmigiano-reggiano-italian-market-down-2/ #BalanceSheet #Cheese #export #Italia #Italian #ItalianCheese #italiano #italy #market #ParmigianoReggiano #PDO #production

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/

Parmigiano Reggiano: Italian market down https://www.diningandcooking.com/2571899/parmigiano-reggiano-italian-market-down/ #BalanceSheet #Cheese #export #Italia #Italian #ItalianCheese #italiano #italy #market #ParmigianoReggiano #PDO #production

#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

#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

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

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

Wine Vinegar Europe Maintains Dominance with PDO and PGI Labels

The global wine vinegar market is poised for significant growth, driven by evolving consumer preferences, the shift toward health-centric diets, and a growing inclination for premium, artisanal food products. With the wine vi…
#dining #cooking #diet #food #Wine #And #dominance #EUROPE #labels #maintains #PDO #pgi #Vinegar #with
https://www.diningandcooking.com/2204924/wine-vinegar-europe-maintains-dominance-with-pdo-and-pgi-labels/

Wine Vinegar Europe Maintains Dominance with PDO and PGI Labels

The global wine vinegar market is poised for significant growth, driven by evolving consumer preferences, the shift toward health-centric diets, and a growing inclination for premium, artisanal food products. With the wine vi…
#dining #cooking #diet #food #Wine #And #dominance #EUROPE #labels #maintains #PDO #pgi #Vinegar #with
https://www.diningandcooking.com/2204924/wine-vinegar-europe-maintains-dominance-with-pdo-and-pgi-labels/

Wine Vinegar Europe Maintains Dominance with PDO and PGI Labels https://www.diningandcooking.com/2204924/wine-vinegar-europe-maintains-dominance-with-pdo-and-pgi-labels/ #And #dominance #EUROPE #labels #maintains #PDO #pgi #Vinegar #Wine #with

Wine Vinegar Europe Maintains Dominance with PDO and PGI Labels https://www.diningandcooking.com/2204924/wine-vinegar-europe-maintains-dominance-with-pdo-and-pgi-labels/ #And #dominance #EUROPE #labels #maintains #PDO #pgi #Vinegar #Wine #with

Wine Vinegar Europe Maintains Dominance with PDO and PGI Labels https://www.diningandcooking.com/2204924/wine-vinegar-europe-maintains-dominance-with-pdo-and-pgi-labels/ #And #dominance #EUROPE #labels #maintains #PDO #pgi #Vinegar #Wine #with

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

Modena Traditional Balsamic Vinegar: bottle production grows (+5%) https://www.diningandcooking.com/2098839/modena-traditional-balsamic-vinegar-bottle-production-grows-5/ #abroad #Italia #Italian #ItalianVinegar #italiano #italy #MarioGambiglianiZoccoli #market #PDO #production #sales #TraditionalBalsamicVinegarOfModena #Vinegar

Record of 3.2 Billion Euros in https://www.diningandcooking.com/2090639/record-of-3-2-billion-euros-in/ #canada #Canadian #Cheese #consortium #consumption #distribution #food #Italia #Italian #ItalianCheese #italiano #italy #Markets #Parmesan #ParmigianoReggiano #PDO #retailers #sales

🚨 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

Activités du moment :

Création : framework #PHP basé sur #slimphp, avec un core doté d'1 orm perso léger basé sur #PDO, des aspects de sécurité, d'envoi de msg, des générateurs (contrôleurs, templates, modules, routes, models...), etc.

Possibilités : #restful, #microservice, #monolithique ou tout à la fois.

Utilité : un projet de site pour des copains (ils participeront au dev) et mes propres besoins.

Présentation : GIT, langages, outils de prog (pour des néophyte motivés)

#enmodedev #dev

Undercover footage from #farms that supply the #Parma ham industry depicts a pattern of #suffering, neglect & unsanitary conditions with potential violations of #animalwelfare & sanitation laws: https://www.lcanimal.org/index.php/investigations/investigations-in-the-field/italian-pig-farm-investigation-2024 #PDO #label #labeling #ParmaHam #ham #prosciutto #bacon #pork

Agrifood Special CAPitals Brief: Enjoy, it’s from Europe! https://www.euractiv.com/section/agriculture-food/news/agrifood-special-capitals-brief-enjoy-its-from-europe/?utm_source=dlvr.it&utm_medium=mastodon #geographicalindications #GIs #PDO #PGI #protecteddenominations

#GeographicalIndications : Application submitted by #Croatia for "Meso turopoljske svinje" to be granted #PDO

This opens the opposition phase, which lasts for 3 months

More information in 🇪🇺 OJ C 199
🇭🇷 https://europa.eu/!8rwNTh

#EUQuality #EUfood #EUproduction

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

#PDO: The amendment to the product specification ‘#Jabugo’ has been approved.

Find out more in the 🇪🇺 #OfficialJournal C 128
🇪🇸 https://europa.eu/!WHWyy8

#GeographicalIndications #EUQuality #denominaciondeorigen #Spain

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

#GeographicalIndications: The names #AntakyaKünefesi" and "#Íslensktlambakjöt" have been added in the register of protected designations of origin and protected geographical indications (#PDO #PGI)

🇹🇷 🇮🇸https://europa.eu/!RJ3cnC

#EUQuality #Turkey #Iceland

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

#GeographicalIndications: The name "Goranski medun" has been added in the register of protected designations of origin and protected geographical indications (#PDO)

More information here : 🇭🇷 https://europa.eu/!3whBdh

#EUQuality #EUfood #EUproduction #honey

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

RT @cdeualmeria: 👏🌱🥜🇪🇸 #IndicacionesGeográficas

La denominación "#Nuezdepedroso" ha sido inscrita en el registro de denominaciones de origen protegidas y de indicaciones geográficas protegidas (#PDO)

#EUQuality #España #Denominaciondeorigen #productoRiojano

📄👉 https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=CELEX:32022R2466&pk_campaign=todays_OJ&pk_source=EURLEX&pk_medium=TW&pk_keyword=PDO%20PGI&pk_content=Regulation&pk_cid=EURLEX_todaysOJ

🐦🔗: https://n.respublicae.eu/EUAgri/status/1613139185744990208

#GeographicalIndications: The name "#Nuezdepedroso" has been added in the register of protected designations of origin and protected geographical indications (#PDO)

More information here : 🇪🇸 https://europa.eu/!RrnH7Y

#EUQuality #Spain #denominaciondeorigen #productoriojano

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