sqlpp11, An SQL Library Worthy Of Modern C++
summary
A C++11 templated EDSL called sqlpp11 claims to make SQL type-safe by building SQL expression trees at compile time so most mistakes surface as compile-time verification instead of runtime errors. It uses generated table/column definitions, prepared-parameter structs, and connector libraries that serialize expressions to vendor SQL or reinterpret them for things like std::vector backend, JSON or XML. Years of work show a working library with subqueries joins outer-join nullability tracked at compile time and growing real-world adoption.
AI-written summary · about
chapters (10)
- 0:00SQLpp11 introduction
- 1:50Problems with string SQL
- 5:07Type-safe inserts
- 13:24Type-safe selects
- 24:43Compile-time safety
- 31:42Vendor-neutral design
- 41:06Handling DB-specific features
- 48:40Extending with custom types
- 55:27Flexible statement structure
- 58:01Future possibilities
related talks
01h 07mSqlpp11, An EDSL For Type-Safe SQL In C++11
49mC++20 ❤ SQL
32mBecause SQL is everywhere but you don't want to use it
29mDuckPL: A procedural language in DuckDB
15mWhat If Writing SQL Became Cool Again?
01h 05m“A modern database interface for C++"
43mSQL vs Prejudice
45mMore Than a Query Language: SQL in the 21st Century