Venue for SQLite paper discussion PWL session with Avinash S. on SQLite paper will take place at the Attic Space - Chanakya in Koramangala. more
How does the two decade old OLTP database engine, SQLite, fare against the new workload (OLAP)? SQLite: Past, Present and Future paper discusses performance of SQLite in various workloads (including OLAP) measured against DuckDB ‘SQLite for analytics’. How did these benchmarks and sound engineering practice enabled the SQLite core team optimize for the OLAP workload? What was not possible while maintaining SQLite’s backward compatibility? What further areas to explore to gain performance?
The paper is published at https://www.vldb.org/pvldb/vol15/p3535-gaffney.pdf
- A historical perspective of SQLite
- A thorough evaluation of SQLite on analytical workloads
- Optimisations on SQLite for analytical data processing
- Ideas on further performance improvements in SQLite
Avinash Sajjanshetty is a seasoned developer specialising in designing and scaling backend systems. His interests include databases, storage engines, and message queues. He is also one of the core maintainers for libsql, an open-source and open-contribution fork of SQLite.
Currently, he’s working with Turso, an edge-hosted, distributed database based on SQLite.
Of late, he is exploring Rust and building CaskDB, an educational project for building a KV Store from the ground up. The project offers bite-sized challenges focused on rectifying failing unit tests, making it an engaging learning experience.
Divyanshu Ranjan has been working as software engineer for almost a decade now. He has been invovled with PWL bangalore community since he presented Dafny paper last year. He is fascinated by software verification with passing interest in databases and distributed systems.
This is an in-person meetup. RSVP to get the venue location.