Jakub Pastuszek talks about using ODBC in Rust to connect to databases, and his own experience using this to ingest and analyse website logs.

00:00:00 Intro
00:00:51 Background
00:02:36 MonetDB
00:05:52 Connecting to MonetDB
00:07:26 What is ODBC?
00:10:08 ODBC crates
00:11:44 My contributions
00:13:18 Why odbc-iter
00:17:02 Example ODBC usage
00:17:56 Example odbc-iter usage
00:18:56 Initialization
00:21:04 Connecting to a database
00:23:35 String encoding
00:24:49 Working with ResultSet
00:27:52 Type conversion
00:33:24 Dynamic Typing
00:35:11 Prepared statements
00:39:17 Multithreading
00:43:27 Stats
00:43:50 Current state and future work
00:45:57 RDBC?
00:53:27 Q&A
00:53:42 Q: How about Diesel?
00:59:07 Q: Were there bottlenecks piping logs into ElasticSearch?
01:01:37 Q: Did you find any smart ways of querying?
01:03:28 Q: Does dropping the ResultSet automatically close()?

#rust #databases #odbc #connecting rust