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 {price_from_user};Avoiding 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 Lots of information available u Vulnerable to sql injection of developer not careful u Use dynamic typingDomain Specific Language u Use types to encode SQL u Looks more like regular C++ u Typically requires

my editor SAN DIEGO, CA JULY 25 2019 REBECCA STAMBLER Go, Go, please Go, please stop breaking my editor! Rebecca Stambler Software Engineer, Google @stamblerre Why doesn’t my editor have saying? Quotes from Go survey, 2018 Hard to install and configure Inadequate documentation My editor isn’t working! 1. There are many different editors and many different features What are users saying? Pretty slow in large projects Performance is very poor Quotes from Go survey, 2018 My editor isn’t working! 1. There are many different editors and many different features 2. Many features

第三届中国Rust开发者⼤会 ⽤ egg 孵化你的 SQL 优化器 王润基 RisingWave 内核开发⼯程师 ? Parser Binder Optimizer Executor SQL AST Logical Plan Physical Plan Table Catalog Storage RisingLight 查询引擎的整体结构 SELECT name, url url FROM t1 JOIN t2 WHERE t1.id = t2.id AND name = ‘Bob’ SQL Logical Plan Physical Plan Projection name, url Filter t1.id = t2.id name = “Bob” Join Scan t1(id, name) Scan t2(id, url) Filter #1 = “Bob” Hash Join #0 = #2 Scan $1.1, $1.2 Scan $2.1, $2.2 Projection #1, #3 ⼀个 SQL 语句优化的例⼦ 基于规则的优化 (RBO) 基于代价的优化 (CBO) 谓词下推 Join Filter A B Join Filter A B Filter Join A Join

springframework.beans * BeanWrapperImpl keeps registered editors in a linked Map: the first registered editor that matches will be used * BeanWrapperImpl caches registered editors that match superclass or interface "messageSource" bean even through an alias Package org.springframework.jdbc * added further default SQL error codes for MS SQL, MySQL, and Oracle * OracleLobHandler lazily initializes Oracle driver classes, always SqlFunction's constructors that expect a SQL return type, in favor of specifying a result type Class * added overloaded constructor to SqlCall, with DataSource and SQL arguments (for consistency with SqlFunction

Connection proxy implements "equals" and "hashCode" based on proxy equality * worked around "oracle.sql.DATE" problem on certain Oracle driver versions, extracting it as timestamp when appropriate * Ro with unknown SQL type on Informix * JdbcTemplate by default uses "PreparedStatement.setString" for any CharSequence (including String and StringBuilder) * JdbcTemplate does not check static SQL for bind parameters building correct relative paths for them Package org.springframework.jdbc * added further default SQL error codes for DB2 and HSQLDB * refined NativeJdbcExtractorAdapter to retry with DatabaseMetaData

building correct relative paths for them Package org.springframework.jdbc * added further default SQL error codes for DB2 and HSQLDB * refined NativeJdbcExtractorAdapter to retry with DatabaseMetaData ResultSetExtractor rse)" method public * improved JdbcTemplate's logging of ignored SQLWarnings, including SQL state and error code in the log output * JdbcTemplate's "queryForObject"/"queryForInt"/etc methods correct exception (DataAccessException) * fixed BlobStringType for Hibernate2/3 to correctly handle SQL NULL Package org.springframework.remoting * RmiClientInterceptorUtils throws clearer exception message

SqlFunction's constructors that expect a SQL return type, in favor of specifying a result type Class * added overloaded constructor to SqlCall, with DataSource and SQL arguments (for consistency with SqlFunction springframework.mail * added InternetAddressEditor to JavaMail support package, to be registered as custom editor (e.g. for form objects) Package org.springframework.orm * extended doc coverage regarding plain SQLState/SQLErrorCodeSQLExceptionTranslator always include SQL in message, even for generic DataAccessExceptions * UncategorizedSQLException includes SQL state and error code in message, to indicate potential

SqlFunction's constructors that expect a SQL return type, in favor of specifying a result type Class * added overloaded constructor to SqlCall, with DataSource and SQL arguments (for consistency with SqlFunction springframework.mail * added InternetAddressEditor to JavaMail support package, to be registered as custom editor (e.g. for form objects) Package org.springframework.orm * extended doc coverage regarding plain SQLState/SQLErrorCodeSQLExceptionTranslator always include SQL in message, even for generic DataAccessExceptions * UncategorizedSQLException includes SQL state and error code in message, to indicate potential

springframework.mail * added InternetAddressEditor to JavaMail support package, to be registered as custom editor (e.g. for form objects) Package org.springframework.orm * extended doc coverage regarding plain SQLState/SQLErrorCodeSQLExceptionTranslator always include SQL in message, even for generic DataAccessExceptions * UncategorizedSQLException includes SQL state and error code in message, to indicate potential depend on ResourceLoader only and moved it to package "beans.factory.xml" * factored out resource editor registration from AbstractApplicationContext into ConfigurableBeanFactoryUtils helper * fixed D

SqlFunction's constructors that expect a SQL return type, in favor of specifying a result type Class * added overloaded constructor to SqlCall, with DataSource and SQL arguments (for consistency with SqlFunction springframework.mail * added InternetAddressEditor to JavaMail support package, to be registered as custom editor (e.g. for form objects) Package org.springframework.orm * extended doc coverage regarding plain SQLState/SQLErrorCodeSQLExceptionTranslator always include SQL in message, even for generic DataAccessExceptions * UncategorizedSQLException includes SQL state and error code in message, to indicate potential