RTNFeb 10

#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

Meeresspiegel steigt abrupt an

Satellitendaten zeigen einen schnelleren Anstieg des Meeresspiegels um 40 Prozent zwischen 2010 und 2012. TUM-Forschende haben einen wichtigen Beitrag zu einer Studie der Europäischen Weltraumorganisation ESA geleistet, die den Wasserschwund an Land, die Erwärmung der Ozeane und den Anstieg des Meeresspiegels untersucht hat.

TUM School of Engineering and Design
Turbo Learn PHPJan 17

How to Block SQL Injection With PDO Prepared Statements

String concatenation turns logins into exploits.

#php #pdo #sqlinjection #security #howto #database

https://www.youtube.com/watch?v=R1esAkJqZXA

How to Block SQL Injection With PDO Prepared Statements #sqlinjection

YouTube
Show threadMichaelJan 8

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

Investigating the performance of Laravel's `whereIn` vs `whereIntegerInRaw` - blog.thms.uk

Revisiting a classic Laravel tip: does `whereIntegerInRaw()` outperform `whereIn()` in 2026?

blog.thms.uk
MichaelJan 7

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

maschmiJan 2

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

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

Searchlight Cyber
Alerta! Alerta!Nov 27

I just stumbled upon a case where property hooks were the best solution: https://andreas.heigl.org/2025/11/27/property-hooks-for-the-win/

#php #propertyhooks #php84 #pdo

andreas.heigl.orgNov 27

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

taegaNov 10

How does Thread Lifting work?
Thread Insertion: Using cannulas or tiny needles, a practitioner places PDO threads into the skin’s subdermal layer throughout the operation. These threads elevate and support drooping tissues, functioning as a framework for the skin.

Website: https://taega.com.au/non-surgical-face-lift-with-pdo-thread-lift/
#taega #PDO #PDOthreads #threadlifiting

taegaNov 7

Types of PDO threads
Three different PDO thread types are available to address the concerns of each patient:

Smooth threads: suggested for producing collagen, perioral, periocular, and forehead lines.
Twist threads: this type provides a little volume and lift for areas such as under the eyebrow, corners of the mouth and the chin.

Website: https://taega.com.au/non-surgical-face-lift-with-pdo-thread-lift/
#taega #taegaclinic #pdo #threadlift

taegaOct 23

What is PDO Thread Lift?
Polydioxanone, or PDO for short, is a thread that is dissolvable and usually used by surgeons during surgical procedures. PDO thread lift is an anti-aging procedure that helps tighten and uplift sagging skin on the neck and face.

Face thread lifting uses PDO threads to introduce them into the skin’s subcutaneous layer. It aids in skin lifting and the production of collagen.

Website: https://taega.com.au/non-surgical-face-lift-with-pdo-thread-lift/
#taega #taegaclinic #PDO #threadliftpdo