PWL Sep 2023: "SQLite: Past, Present, and Future"
SQLite: Past, Present, and Future, read by Avinash
About the paper
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
Key takeaways for the audience
- 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
About the presenter and discussant
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.
RSVP and venue
This is an in-person meetup. RSVP to get the venue location.
Hosted by
What was the last paper within the realm of computing you read and loved? What did it inspire you to build or tinker with? Come share the ideas in an awesome academic/research paper with fellow engineers, programmers, and paper-readers. Lead a session and show off code that you wrote that implement…
more
About the paper
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
Key takeaways for the audience
- 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
About the presenter and discussant
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.
RSVP and venue
This is an in-person meetup. RSVP to get the venue location.
Venue
Attic Space - Chanakya
1st floor, No. 32, 2nd cross, Nanjappa Reddy Layout, Village
opp. Ganga Sagar Hotel, Koramangala 8th Block, Koramangala
Bengaluru - 560095
Karnataka, IN
Hosted by
What was the last paper within the realm of computing you read and loved? What did it inspire you to build or tinker with? Come share the ideas in an awesome academic/research paper with fellow engineers, programmers, and paper-readers. Lead a session and show off code that you wrote that implement…
more