Trying to keep the bugs out: Lessions learned from 22 years of working on SQLite

Базы данных и системы хранения

Базы данных

Доклад отозван

Мнение Программного комитета о докладе

Целевая аудитория

DBA, system engineers

Тезисы

SQLite is one of the most widely used pieces of software in the world. There are more instances of SQLite running right now than all other database engines combined. Because so many other systems use and depend on SQLite, it is important to keep the code as reliable and bug-free as possible. How do we do that?

This talk, by the SQLite creator and team leader, reviews what the SQLite team does in our quest to maintain the highest possible code quality. Both successes and failure will be discussed. The talk attempts to identify general principals that can be used to improve and protect code quality in other projects.

D. Richard Hipp

Hwaci

Richard Hipp is the creator and lead maintainer of the SQLite database engine - the most widely used database engine in the world. Together with a small team of talented enthusiasts, Hipp spends most of his time improving, enhancing, and testing SQLite.

He founded a small company (today known as "SQLite.org") writing software for computational linguistics. Preceiving a need for a compact and easy-to-use embedded SQL database in 2000, Hipp created SQLite and released it as open-source software and, to his surprise, it was a big hit. Within five years, Hipp had mostly stopped writing bespoke software and instead labored full-time supporting and maintaining SQLite and SQLite-related projects for commercial companies around the world.

Hipp has been working out of his home in Charlotte, North Carolina, USA, for the past 26 years. In addition to SQLite, Hipp also manages other open source projects, including the Fossil version-control system, Pikchr, Wapp, Althttpd, and Lemon. Hipp has been happily married to Ginger Wyrick (a professor of music at UNC-Charlotte) for 27 years. He teaches the 5-year-old Sunday-school class at his local church. And he enjoys running.

Hwaci

Hwaci and open source projects, including the Fossil version-control system (https://fossil-scm.org), Pikchr (https://pikchr.org), Wapp (https://wapp.tcl.tk), Althttpd (https://sqlite.org/althttpd), and Lemon (https://sqlite.org/src/doc/trunk/doc/lemon.htm)

Константин Осипов

Picodata

Основатель Picodata.

Picodata

Компания занимается разработкой и поддержкой решений для работы с быстрыми данными, а также развивает свой одноименный продукт Picodata — распределенную СУБД с плагинами на Rust.