database/sql: the bad, the good and the ugly — developing a driver for YDB

on YouTube ↗45m

" summary

A talk about implementing a Go database driver for YDB using the standard library package database/sql. It covers historical evolution of database/sql, design decisions and problems encountered while building the YDB driver (starting from Go 1.11), and practical lessons learned in making a robust DB driver that fits the database/sql interface.

AI-written summary · about

" chapters (12)

1. 0:00Introduction
2. 1:59What is YDB and its features
3. 7:06Evolution of database/sql in Go
4. 16:04Retries and connection pooling
5. 19:43Context issues in database/sql
6. 24:28Named parameters and iteration
7. 27:18Why context matters
8. 30:04Error handling in database/sql
9. 33:15Developing YDB driver
10. 36:51Monitoring and debugging driver
11. 38:38Summary and future plans
12. 39:21Q&A

" related talks

• 37mBuilding Database Applications with Database/SQLBaron Schwartz · GopherCon 2014
• 44mYDB Java SDK: The Battle for PerformanceAleksandr Gorshenin · JPoint 2023
• 48mIntegrating Distributed SQL Stores with Java Frameworks: The YDB ExampleKirill Kurdyukov · Joker 2024
• 01h 27mYugabyteDB YSQL DevelopmentSeth Luersen · Distributed SQL Summit 2022
• 02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB EffectivelyFranck Pachot · Devoxx France 2023
• 01h 05m“A modern database interface for C++"Erik Smith · CppCon 2016
• 51mYandex Database: Distributed Queries in the CloudsSergey Puchin · Backend Conf 2019 (РИТ++)
• 48mCost-Based Optimizer in YDB — How, Why and What For?Pavel Velikhov · HighLoad++ 2024