BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//HasGeek//NONSGML Funnel//EN
DESCRIPTION:SQLite: Past\, Present\, and Future\, read by Avinash
X-WR-CALDESC:SQLite: Past\, Present\, and Future\, read by Avinash
NAME:PWL Sep 2023: "SQLite: Past\, Present\, and Future"
X-WR-CALNAME:PWL Sep 2023: "SQLite: Past\, Present\, and Future"
REFRESH-INTERVAL;VALUE=DURATION:PT12H
SUMMARY:PWL Sep 2023: "SQLite: Past\, Present\, and Future"
TIMEZONE-ID:Asia/Kolkata
X-PUBLISHED-TTL:PT12H
X-WR-TIMEZONE:Asia/Kolkata
BEGIN:VEVENT
SUMMARY:PWL Sep 2023: "SQLite: Past\, Present\, and Future"
DTSTART:20230908T113000Z
DTEND:20230909T130000Z
DTSTAMP:20260422T035527Z
UID:session/MPFBt3NSL6bpv15mumMqMc@hasgeek.com
SEQUENCE:34
CREATED:20230818T124554Z
DESCRIPTION:## About the paper\nHow does the two decade old OLTP database 
 engine\, SQLite\, fare against the new workload (OLAP)? SQLite: Past\, Pre
 sent 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 cor
 e team optimize for the OLAP workload? What was not possible while maintai
 ning SQLite’s backward compatibility? What further areas to explore to g
 ain performance?\n\nThe paper is published at <https://www.vldb.org/pvldb/
 vol15/p3535-gaffney.pdf>\n\n## Key takeaways for the audience\n- A histori
 cal perspective of SQLite\n- A thorough evaluation of SQLite on analytical
  workloads\n- Optimisations on SQLite for analytical data processing\n- Id
 eas on further performance improvements in SQLite\n\n## About the presente
 r and discussant\nAvinash Sajjanshetty is a seasoned developer specialisin
 g in designing and scaling backend systems. His interests include database
 s\, storage engines\, and message queues. He is also one of the core maint
 ainers for libsql\, an open-source and open-contribution fork of SQLite. \
 n\nCurrently\, he's working with Turso\, an edge-hosted\, distributed data
 base based on SQLite. \n\nOf late\, he is exploring Rust and building [Cas
 kDB](https://github.com/avinassh/py-caskdb)\, an educational project for b
 uilding a KV Store from the ground up. The project offers bite-sized chall
 enges focused on rectifying failing unit tests\, making it an engaging lea
 rning experience.\n\nDivyanshu Ranjan has been working as software enginee
 r for almost a decade now. He has been invovled with PWL bangalore communi
 ty since he presented Dafny paper last year. He is fascinated by software 
 verification with passing interest in databases and distributed systems. \
 n\n## RSVP and venue\nThis is an in-person meetup. RSVP to get the venue l
 ocation. 
LAST-MODIFIED:20231121T072411Z
LOCATION:Bureau Office\, Koramangala - https://hasgeek.com/pwl_bangalore/0
 9-23/
ORGANIZER;CN="Papers We Love Bangalore":MAILTO:no-reply@hasgeek.com
URL:https://hasgeek.com/pwl_bangalore/09-23/
BEGIN:VALARM
ACTION:display
DESCRIPTION:PWL Sep 2023: "SQLite: Past\, Present\, and Future" in 5 minut
 es
TRIGGER:-PT5M
END:VALARM
END:VEVENT
END:VCALENDAR