“A modern database interface for C++"

on YouTube ↗01h 05m

" summary

A standards‑grade C++ database interface and a header‑only reference implementation live on GitHub, with working drivers for MySQL and SQLite and a growing test suite; it exposes row sets and polymorphic interface modes, uses shared_ptr reference types and policy templates, and supports connection pooling, type conversion, input/output binding and optional future ranges/variants support. A measured example shows array output binding cutting a 1,000‑row fetch from 203 ms to ~32 ms (100 rows) and down to single‑millisecond/microsecond ranges, and a polymorphic varargs path bloats compile output (tens of thousands of instantiations) requiring further work.

AI-written summary · about

" chapters (47)

1. 0:00WHY DO WE CARE
2. 1:46PREVIOUS PROPOSAL WORK
3. 2:00THE RELATIONAL MODEL
4. 2:58THE CLIENT STACK
5. 7:00COMPOSABLE
6. 8:07DIRECT VS POLY
7. 8:40THE TYPES
8. 10:27DUAL METHOD STYLES
9. 11:15FLEXIBLE
10. 12:43WHY REFERENCE TYPES?
11. 13:56DATABASE
12. 15:14CONNECTION STRING
13. 16:43TRANSACTIONS & SCOPE EXIT
14. 17:28STATEMENT
15. 19:09APPROACHES TO ROWSET TRAVERSAL / ACCESS
16. 19:41ITERATORS!
17. 20:07RANGE BASED FOR
18. 21:58ITERATOR OVERHEAD
19. 22:45STD LIBRARY ALGORITHM EXAMPLE 1
20. 23:55ITERATOR ISSUES
21. 24:39RANGES!
22. 25:26RANGE SUPPORT
23. 26:40RANGE OPTIMIZATIONS
24. 27:40RANGES: PASS RANGE INSTEAD OF PAIR
25. 28:16RANGE ADAPTORS
26. 31:58FIELD ACCESSORS
27. 32:48MORE EFFICIENT ROW FIELD INDEXING
28. 34:34ROW LEVEL into
29. 35:20INTO RANGE
30. 35:47SERIALIZATION
31. 36:48HANDLE ACCESSORS
32. 38:17ARRAY OUTPUT BINDING
33. 40:42CONTIGUOUS ARRAY BINDING
34. 41:24DETACHED ROWSETS
35. 43:12ARRAY INPUT BINDING
36. 43:52TYPE CONVERSION
37. 44:23POLICIES
38. 45:05UTILITY EXAMPLE: JOIN
39. 47:32JOIN ALGORITHMS
40. 48:05POLYMORPHIC INTERFACE
41. 49:01POLY: ADDING DRIVERS
42. 49:20REFERENCE IMPLEMENTATION TEST SUITE
43. 49:50IMPLEMENTATION DETAILS
44. 50:42DRIVER INTERFACE
45. 54:58NON-BLOCKING INTERFACE
46. 55:56REFERENCE IMPLEMENTATION ROADMAP
47. 56:50QUESTIONS

" related talks

• 01h 03mPersisting C++ Classes in Relational Databases with ODBBoris Kolpackov · CppCon 2014
• 49mC++20 ❤ SQLJohn Bandela · CppCon 2021
• 55mIn-memory database with indices from scratchHana Dusikova · NDC TechTown 2023
• 05mSimple RPC Server for Database AccessNoel Tchidjo · CppCon 2019
• 17mFast database interfacing with MySQL.jlNishanth Kottary · JuliaCon 2015
• 36mCompile-time reflection, Serialization and ORMYu Qi · CppCon 2017
• 45mdatabase/sql: the bad, the good and the ugly — developing a driver for YDBAleksey Myasnikov · HighLoad++ 2023
• 30mShared Database ConcurrencyAivars Kalvāns · Wildcard Conference 2013