SQLite: Past, Present, and Future

Summary: SQLite ubiquity: in-process, standalone, cross-platform; OLTP-optimized with row storage and B-trees. SQLite: transactional, analytical, and blob workloads; OLAP bottlenecks; up to 4.2× SSB speedups, with in-process analytics roadmap. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hafd763e250f1764a
Venue: VLDB
Year: 2022
Pagerank: 6.4318211e-05
Overall Rank: 4,758 | 68.02%
DOI: 10.14778/3554821.3554842

Incoming Non-self Citations Over Time

Authors

1. Kevin P. Gaffney (University of Wisconsin)
2. Martin Prammer (University of Wisconsin)
3. Larry Brasfield (SQLite)
4. D. Richard Hipp (SQLite)
5. Dan Kennedy (SQLite)
6. Jignesh M. Patel (University of Wisconsin)

BibTeX Citation

@article{gaffney_vldb22,
        title = {{SQLite: Past, Present, and Future}},
        author = {Gaffney, Kevin P. and Prammer, Martin and Brasfield, Larry and Hipp, D. Richard and Kennedy, Dan and Patel, Jignesh M.},
        journal = {PVLDB},
        series = {{VLDB} '22},
        volume = {15},
        number = {12},
        pages = {3535--3547},
        doi = {10.14778/3554821.3554842},
        url = {https://doi.org/10.14778/3554821.3554842},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,484	Bf-Tree: A Modern Read-Write-Optimized Concurrent Larger-Than-Memory Range Index	2024	VLDB	5.7696173e-05
6,710	Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis	2023	VLDB	5.7019157e-05
6,742	Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine	2025	SIGMOD	5.6910432e-05
7,358	Optimizing Collections of Bloom Filters within a Space Budget	2024	VLDB	5.5431911e-05
7,416	Is Perfect Hashing Practical for OLAP Systems?	2024	CIDR	5.5331654e-05
7,817	Parachute: Single-Pass Bi-Directional Information Passing	2025	VLDB	5.4477841e-05
9,022	BPF-DB: A Kernel-Embedded Transactional Database Management System For eBPF Applications	2025	SIGMOD	5.2349846e-05
9,218	EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction	2026	SIGMOD	5.2056825e-05
9,646	Are Joins over LSM-trees Ready? Take RocksDB as an Example	2025	VLDB	5.1453267e-05
10,356	I Can't Believe It's Not Yannakakis: Pragmatic Bitmap Filters in Microsoft SQL Server	2026	CIDR	4.9793485e-05
10,725	How to Write to SSDs	2026	VLDB	4.9793485e-05
10,925	The Live Database: Firestore’s Scalable and Consistent Realtime Queries	2026	VLDB	4.9793485e-05
11,467	The Tipping Point of Edge-Cloud Data Management	2024	CIDR	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037720227
969	Memory-Efficient Hash Joins	2015	VLDB	0.0001278184
2,137	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	8.9777553e-05
4,391	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	6.6214093e-05
4,786	Applying Hash Filters to Improving the Execution of Bushy Trees	1993	VLDB	6.4143659e-05
9,614	Introducing a Query Acceleration Path for Analytics in SQLite3	2022	CIDR	5.1513506e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,825	Data Management for Data Science: Towards Embedded Analytics	2020	CIDR
2	11,860	Lineage Resource Manager	2022	SIGMOD
3	4,828	Cloud-Native Transactions and Analytics in SingleStore	2022	SIGMOD
4	6,836	SQL Statement Logging for Making SQLite Truly Lite	2018	VLDB
5	3,001	ClickHouse - Lightning Fast Analytics for Everyone	2024	VLDB
6	976	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD
7	4,984	Fast In-Memory SQL Analytics on Typed Graphs	2017	VLDB
8	7,078	DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS	2023	CIDR
9	71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD
10	9,614	Introducing a Query Acceleration Path for Analytics in SQLite3	2022	CIDR