Of representation and interpretation: A unified theory - PHPBenelux meetup

Of representation and interpretation A unified theory @arnoutboks Arnout Boks
PHPBenelux 10-09-2020

@arnoutboks #PHPBenelux Hard problems in programming • Cache invalidation •
Naming things • Off-by-one errors

@arnoutboks #PHPBenelux Hard problems in programming • String escaping •
Timezones • Character encoding

@arnoutboks #PHPBenelux Many difficulties with these topics are related

@arnoutboks #PHPBenelux This talk is… • My personal view •
Not an absolute truth • Meant to make you think

Data And its meaning

@arnoutboks #PHPBenelux A number

@arnoutboks #PHPBenelux A byte

@arnoutboks #PHPBenelux Some JSON data { "income":100000 }

@arnoutboks #PHPBenelux A word

@arnoutboks #PHPBenelux A prime number 4931083597028501900275777672390764957284907772150208632080750184097926278850976588645578020 1366007328679544734112831735367831201557535981978545054811571939345877330038009932619505876 4525023820408110189885042615176579941704250889037029119015870030479432826073821469541570330 2279875576818956016240300641115169008728798381942582716745647748166843479284645809291315318 6007001004335318936319343912948604450370991980047709462921558180711169153031876288477878354
1575932891093295447350881882465495060005019006274705305381164278294267474853496525745368151 1706550281905552656221353146310421008662867971144467063669219825861581112515556504813420768 6732340765505485910826956266693066236799702104812396562518006818323653959348395675357557532 4619023481064700987753027956186892925380693305204238149969945456945774138335689906005870832 1812704861133682026515905166351874029X18197693937677852928722109550412925792573818660584501 5055250274994771883129310457698090915304613359419030258813205932277444385255046677902451869 7062627788891979580423065750615669834695617797879659201644051939960716981112615195610276283 2339825791423321726961443744381056485529348876349210309887028787453233132532122678633283702 7925099749969488775936915917644588032718384740235933020374888506755706587919461134193230781 4854436454375113207098606390746417564121635042388002967808558670370387509410769821183765499 2052043682558546422885024299633226853691246485500075591664024729240716450725319674499952944 8434741902107729606820558130923626837987951966199798285525887161096136561780745661592488660 8898164568541721362920846656279131478466791550965154310113538586208196875836883595577893914 5453935681996098808540476590735897289898342504712891841626587896821853808795627903997862944 9397605467534821256750121517082737107646270712467532102483678159400087505452543537

@arnoutboks #PHPBenelux Data has a different meaning under different interpretations

Functions A bit of theory

@arnoutboks #PHPBenelux Functions x y y = f(x) f

@arnoutboks #PHPBenelux Functions D R x y f: D →
R y = f(x)

@arnoutboks #PHPBenelux Functions <?php function f(D $x): R { $y
= do_something_with($x); return $y; }

@arnoutboks #PHPBenelux Functions float int 3.84 4 round: float →
int 4 = round(3.84)

@arnoutboks #PHPBenelux Functions D R x1 y f: D →
R x2

@arnoutboks #PHPBenelux Functions float int 3.84 4 round: float →
int 4.35

@arnoutboks #PHPBenelux Functions D R x y1 f: D →
R y2

@arnoutboks #PHPBenelux Pure functions D R x y1 f: D
→ R y2

@arnoutboks #PHPBenelux Impure functions • Randomness • State (global or
local) • IO • Filesystem • Network • System clock

@arnoutboks #PHPBenelux Functions D R x ? f: D →
R

@arnoutboks #PHPBenelux Functions (in mathematics) D R x f: D
→ R

@arnoutboks #PHPBenelux Functions (in programming) D R x Exception! f:
D → R

Representation & Interpretation

@arnoutboks #PHPBenelux Level of abstraction float int round: abstraction

@arnoutboks #PHPBenelux Level of abstraction Money string serialize_money: abstraction

@arnoutboks #PHPBenelux Level of abstraction string byte[] encode_as_utf16: abstraction

@arnoutboks #PHPBenelux Representation • Translation of a high-level concept to
a lower-level representation • All input values supported • Lossless (ideally) • Same data, just in a different form

@arnoutboks #PHPBenelux Level of abstraction byte[] string decode_from_utf16: abstraction

@arnoutboks #PHPBenelux Level of abstraction string Money parse_money: abstraction

@arnoutboks #PHPBenelux Interpretation • Translation of a low-level representation (back)
to a higher-level concept • Usually not all input values supported • Same data, just in a different form

@arnoutboks #PHPBenelux Why do we do this?

@arnoutboks #PHPBenelux Transmission of data Money string abstraction byte[] light
pulses, magnetic grains, etc. …

Escaping A different view

@arnoutboks #PHPBenelux Escaping for SQL <?php $username = $_POST['username']; $sql
= "SELECT * FROM users WHERE username = '" . db_escape_string($username) . "'"; $result = db_query($sql);

@arnoutboks #PHPBenelux Escaping for SQL <?php // $_POST['username'] = "';
DROP TABLE users; --" $username = $_POST['username']; $sql = "SELECT * FROM users WHERE username = '" . db_escape_string($username) . "'"; $result = db_query($sql);

@arnoutboks #PHPBenelux Escaping for SQL <?php // $_POST['username'] = "John
O'Shea" $username = $_POST['username']; $sql = "SELECT * FROM users WHERE username = '" . db_escape_string($username) . "'"; $result = db_query($sql);

@arnoutboks #PHPBenelux Escaping for SQL <?php // returns "John O'Shea"
$username = get_username_using_api(); $sql = "SELECT * FROM users WHERE username = '" . db_escape_string($username) . "'"; $result = db_query($sql);

@arnoutboks #PHPBenelux Escaping for SQL <?php // $username = "John
O'Shea" $username = /* (whatever) */; $sql = "SELECT * FROM users WHERE username = '" . db_escape_string($username) . "'"; $result = db_query($sql);

@arnoutboks #PHPBenelux String escaping is NOT a security measure

@arnoutboks #PHPBenelux String escaping is just properly representing data

@arnoutboks #PHPBenelux Escaping as representation string SQLFragment (?) db_escape_string: "O'Shea"
"O\'Shea"

@arnoutboks #PHPBenelux Escaping as representation <?php db_escape_string("John O'Shea"); // ->
"John O\'Shea" <?php as_sql_string_literal("John O'Shea"); // -> "'John O\'Shea'" Better:

@arnoutboks #PHPBenelux Escaping as representation string SQLStringLiteral as_sql_string_literal: "O'Shea" "'O\'Shea'"

@arnoutboks #PHPBenelux Chained escaping as representation <?php $name = "John
O'Shea"; $js_name = as_js_string_literal($name); $js_script = "showGreeting(" . $js_name . ")"; $html_tag = "<a onclick=" . as_html_attribute_value($js_script) . ">Show greeting</a>"; $sql = "INSERT INTO html_examples VALUES(" . as_sql_string_literal($html_tag) . ")";

@arnoutboks #PHPBenelux Premature representation <?php foreach ($_REQUEST as $key =>
$value) { $_REQUEST[$key] = htmlentities( db_escape_string($value) ); } // ‘Now the input data is safe’

@arnoutboks #PHPBenelux Premature representation <?php foreach ($_REQUEST as $key =>
$value) { if ( strpos($value, "DROP TABLE") !== false ) { die("SQL injection!"); } }

What goes wrong and how to prevent that

@arnoutboks #PHPBenelux Misrepresentation Money string serialize_money_ok: (€ 10) "€ 10"

@arnoutboks #PHPBenelux Misrepresentation Money string serialize_money_bad: (€ 10) "10"

@arnoutboks #PHPBenelux Misrepresentation Money string serialize_money_bad: (€ 10) "10" ($
10)

@arnoutboks #PHPBenelux Misrepresentation Money string (€ 10) "10" ($ 10)
Money ?

@arnoutboks #PHPBenelux That doesn’t happen to me! DateTime string 2022-03-14
06:28:00 Europe/Amsterdam 2022-03-14T\ 06:28:00+01:00

@arnoutboks #PHPBenelux That doesn’t happen to me! fraction float 1/3
0.33333333333333

@arnoutboks #PHPBenelux That doesn’t happen to me! string byte[] ⛽☂️
? encode_as_iso8859_1

@arnoutboks #PHPBenelux Lossy representations cannot be re-interpreted

@arnoutboks #PHPBenelux Misinterpretation byte[] […] string "café"

@arnoutboks #PHPBenelux Misinterpretation byte[] […] string "café" utf8 decode_from_utf8 Exception!

@arnoutboks #PHPBenelux Misinterpretation byte[] […] string "café" iso8859-1 utf8

@arnoutboks #PHPBenelux Misinterpretation byte[] […] string "café" iso8859-1 utf8 "cafÃ©"

@arnoutboks #PHPBenelux Duck typing byte[] […] iso8859-1 utf8

@arnoutboks #PHPBenelux Duck typing byte[] […] iso8859-1 utf8 HOW?

@arnoutboks #PHPBenelux The meaning of data comes from our interpretation
of it…

@arnoutboks #PHPBenelux …which may very well be wrong

@arnoutboks #PHPBenelux Interpretation hints Store/transmit desired interpretation along with data
Examples: • Music staves

@arnoutboks #PHPBenelux Interpretation hints Store/transmit desired interpretation along with data
Examples: • HTTP headers • Content-Type • Content-Encoding • Content-Language • Unicode byte order mark

@arnoutboks #PHPBenelux Interpretation hints utf16 LE utf16 BE […]

@arnoutboks #PHPBenelux Interpretation hints utf16 LE with BOM utf16 BE
with BOM […]

@arnoutboks #PHPBenelux Hints by variable naming Include intended interpretation in
variable name: • $message_utf8 • $username_sql • $title_html

@arnoutboks #PHPBenelux Hints by variable naming <?php header("Content-Type: text/plain; charset=iso-8859-1");
print $message_utf8; Charset mismatch between header and content

@arnoutboks #PHPBenelux Hints by variable naming <?php $database->query("SELECT * FROM
users WHERE username = " . $username); Username is not properly represented for SQL

@arnoutboks #PHPBenelux Hints by variable naming <?php print "<h1>" .
htmlentities($title_html) . "</h1>"; Double escaping, title is already represented as HTML

PHP’s string type A strange hybrid

@arnoutboks #PHPBenelux Role overloading of string string byte[] encode_as_utf16: abstraction

@arnoutboks #PHPBenelux PHP’s string type is actually a byte array

@arnoutboks #PHPBenelux Role overloading of string string = byte[] encode_as_utf16:
abstraction

@arnoutboks #PHPBenelux Role overloading of string string = byte[] abstraction
‘real’ string use as if utf16

@arnoutboks #PHPBenelux Role overloading of string string = byte[] abstraction
‘real’ string use as if utf16 use as if utf8

@arnoutboks #PHPBenelux More accurate types • A better type system
makes mis-interpretation more difficult • If our programming language does not provide the types, we have to do it ourselves • Value Objects!

@arnoutboks #PHPBenelux More accurate types <?php class UTF8Bytes { private
string $bytes; private function __construct(string $bytes) { $this->bytes = $bytes; } public static function fromPHPString(string $bytes) { return new self($bytes); } public function toPHPString(): string { return $this->bytes; } // ... }

@arnoutboks #PHPBenelux More accurate types <?php class ISO88591Bytes { private
string $bytes; private function __construct(string $bytes) { $this->bytes = $bytes; } public static function fromPHPString(string $bytes) { return new self($bytes); } public function toPHPString(): string { return $this->bytes; } // ... }

@arnoutboks #PHPBenelux More accurate types <?php class RealString { private
string $value_utf16; private function __construct(string $value_utf16) { $this->value_utf16 = $value_utf16; } public static function fromUTF8(UTF8Bytes $utf8_bytes) { $value_utf16 = mb_convert_encoding( $utf8_bytes->toPHPString(), 'UTF-16', 'UTF-8'); return new self($value_utf16); } public static function fromISO88591(ISO88591Bytes $iso88591_bytes) { // ... } // ... }

@arnoutboks #PHPBenelux More accurate types <?php class RealString { //
... public function toUTF8(): UTF8Bytes { $value_utf8 = mb_convert_encoding( $this->value_utf16, 'UTF-8', 'UTF-16'); return UTF8Bytes::fromPHPString($value_utf8); } public function toISO88591(): ISO88591Bytes { $value_iso88591 = mb_convert_encoding( $this->value_utf16, 'ISO-8859-1', 'UTF-16'); return ISO88591Bytes::fromPHPString($value_iso88591); } // ... }

@arnoutboks #PHPBenelux More accurate types <?php class RealString { //
... public function concat(RealString $other): RealString { return new RealString($this->value_utf16 . $other->value_utf16); } public function substring(int $start, int $length): RealString { $substr_utf16 = mb_substr($this->value_utf16, $start, $length, 'UTF-16'); return new RealString($substr_utf16); } // ... }

@arnoutboks #PHPBenelux More accurate types (usage) <?php $string1_utf8 = UTF8Bytes::fromPHPString(
file_get_contents("file1.txt")); $string1 = RealString::fromUTF8($string1_utf8); $string2_iso88591 = ISO88591Bytes::fromPHPString( file_get_contents("file2.txt")); $string2 = RealString::fromISO88591($string2_iso88591); // The original charsets do not matter anymore now... $new_string = $string1->concat($string2)->substring(7, 42); header("Content-Type: text/plain; charset=utf-8"); print $new_string->toUTF8()->toPHPString();

@arnoutboks #PHPBenelux Without value objects iso8859-1 utf8 string = byte[]
abstraction

@arnoutboks #PHPBenelux With value objects abstraction UTF8Bytes ISO88591Bytes RealString

@arnoutboks #PHPBenelux Value objects • Achieve higher levels of abstraction
• Avoid misinterpretation • No silver bullet! • Comes with additional overhead

@arnoutboks #PHPBenelux Recap • Data • Functions • Interpretation and
representation • String escaping • Misrepresentation and –interpretation • The string type • Value objects

@arnoutboks #PHPBenelux The meaning of data is defined by how
we interpret it

@arnoutboks #PHPBenelux Questions @arnoutboks @arnoutboks @aboks Arnout Boks Please leave
your feedback on joind.in: https://joind.in/talk/109ec We’re hiring!

@arnoutboks #PHPBenelux Image Credits • https://pixabay.com/en/reading-relaxation-glasses-sight- 3088491/ • https://fr.m.wikipedia.org/wiki/Fichier:DARPA_Big_Data.jpg •
https://www.flickr.com/photos/elefevre/3936916711 • https://www.flickr.com/photos/perspective/9045532603 • https://www.flickr.com/photos/wwarby/11644168395/ • https://www.flickr.com/photos/opengridscheduler/1648045015 7 • https://www.flickr.com/photos/cogdog/14401469262 • https://www.flickr.com/photos/paulsimpson1976/3998279762 • https://www.flickr.com/photos/pewari/3499963407

Of representation and interpretation: A unified...

Of representation and interpretation: A unified theory - PHPBenelux meetup

More Decks by Arnout Boks

Other Decks in Programming

Featured

Transcript