C++20 ❤ SQL John R Bandela, MDOverview u SQL u C++ Example u Implementation techniques u fixed_string u meta_struct u Parsing compile time strings into meta_structsOverview v SQL v C++ Example language v It matches the capabilities of a relational database v Very widely used. You will be able to find all sorts of information about itExample Database Customers id INTEGER PRIMARY KEY name TEXT ing SQL Injection Attacks SELECT orders.id, name, item, price, discount_code FROM orders JOIN customers ON customers.id = customerid WHERE price > ?;SQL Library Options u Traditional database library

event in 1ms. • Allocation unpredictability: for example, ban on free store allocation “after the engine starts.” • Termination errors: a library that terminates in case of “unanticipated conditions” being break-ins • Spies (insider attacks) • Spear phishing • Door rattling • Denial of service attacks • SQL injection • Corrupted input/Data • Rule of thumb: always first attack the weakest link Stroustrup resource is something that must be acquired and released after use • E.g., files, memory, locks, database transactions, communication channels, GUI connections, threads • Explicit release is error-prone

search. gle glegle gle gle gle found 8,000,000 similar images Take a picture Add it to the database Send results Find similar pictures Send it to Ogle The Prototype� � � � � found 8,000,000 ░░░░░░░░░░▓▓▌▐ ▌ ▐█▓░░░░░░░░░░░░░░░░░░░░░░░░░░██▐ ▌█▓▌░░░░░░░░░░░░░░░░░░░░░░░░░░░▓█▐Searching database... found 4 results: catisgumpy.bmp funisawful.bmp catdoesnotlikefun.bmp from_dad.bmp OGLE Speedup Results � � � �gle gle found 8,000,000 similar images Take a picture Add it to the database Send results Find similar pictures Send it to Ogle gle glegle gle found 8,000,000 similar

consisting in 3 packages: a matrix package, emulating some mathematical library, an engine package emulating some game engine, and a sound32 package, emulating a sound library for some 32bits systems. These Release 2.0.17 engine/1.0 matrix/1.0 sound32/1.0 if arch==x86 We will start by creating the first matrix/1.0 version: $ conan create matrix --version=1.0 Now we can check in the engine folder its recipe: recipe: class Engine(ConanFile): name = "engine" settings = "arch" def requirements(self): self.requires("matrix/[>=1.0 <2.0]") if self.settings.arch == "x86": self.requires("sound32/[>=1.0 <2.0]")

consisting in 3 packages: a matrix package, emulating some mathematical library, an engine package emulating some game engine, and a sound32 package, emulating a sound library for some 32bits systems. These Release 2.1.0 engine/1.0 matrix/1.0 sound32/1.0 if arch==x86 We will start by creating the first matrix/1.0 version: $ conan create matrix --version=1.0 Now we can check in the engine folder its recipe: recipe: class Engine(ConanFile): name = "engine" settings = "arch" def requirements(self): self.requires("matrix/[>=1.0 <2.0]") if self.settings.arch == "x86": self.requires("sound32/[>=1.0 <2.0]")

consisting in 3 packages: a matrix package, emulating some mathematical library, an engine package emulating some game engine, and a sound32 package, emulating a sound library for some 32bits systems. These of lockfiles. engine/1.0 matrix/1.0 sound32/1.0 if arch==x86 We will start by creating the first matrix/1.0 version: $ conan create matrix --version=1.0 Now we can check in the engine folder its recipe: recipe: class Engine(ConanFile): name = "engine" settings = "arch" def requirements(self): self.requires("matrix/[>=1.0 <2.0]") if self.settings.arch == "x86": self.requires("sound32/[>=1.0 <2.0]")

consisting in 3 packages: a matrix package, emulating some mathematical library, an engine package emulating some game engine, and a sound32 package, emulating a sound library for some 32bits systems. These of lockfiles. engine/1.0 matrix/1.0 sound32/1.0 if arch==x86 We will start by creating the first matrix/1.0 version: $ conan create matrix --version=1.0 Now we can check in the engine folder its recipe: recipe: class Engine(ConanFile): name = "engine" settings = "arch" def requirements(self): self.requires("matrix/[>=1.0 <2.0]") if self.settings.arch == "x86": self.requires("sound32/[>=1.0 <2.0]")

consisting in 3 packages: a matrix package, emulating some mathematical library, an engine package emulating some game engine, and a sound32 package, emulating a sound library for some 32bits systems. These of lockfiles. engine/1.0 matrix/1.0 sound32/1.0 if arch==x86 We will start by creating the first matrix/1.0 version: $ conan create matrix --version=1.0 Now we can check in the engine folder its recipe: recipe: class Engine(ConanFile): name = "engine" settings = "arch" def requirements(self): self.requires("matrix/[>=1.0 <2.0]") if self.settings.arch == "x86": self.requires("sound32/[>=1.0 <2.0]")

consisting in 3 packages: a matrix package, emulating some mathematical library, an engine package emulating some game engine, and a sound32 package, emulating a sound library for some 32bits systems. These of lockfiles. engine/1.0 matrix/1.0 sound32/1.0 if arch==x86 We will start by creating the first matrix/1.0 version: $ conan create matrix --version=1.0 Now we can check in the engine folder its recipe: recipe: class Engine(ConanFile): name = "engine" settings = "arch" def requirements(self): self.requires("matrix/[>=1.0 <2.0]") if self.settings.arch == "x86": self.requires("sound32/[>=1.0 <2.0]")

consisting in 3 packages: a matrix package, emulating some mathematical library, an engine package emulating some game engine, and a sound32 package, emulating a sound library for some 32bits systems. These Release 2.10.1 engine/1.0 matrix/1.0 sound32/1.0 if arch==x86 We will start by creating the first matrix/1.0 version: $ conan create matrix --version=1.0 Now we can check in the engine folder its recipe: recipe: class Engine(ConanFile): name = "engine" settings = "arch" def requirements(self): self.requires("matrix/[>=1.0 <2.0]") if self.settings.arch == "x86": self.requires("sound32/[>=1.0 <2.0]")