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: 13017
Venue: VLDB
Year: 2022
Pagerank: 6.2827906e-05
Overall Rank: 5,284 | 63.75%
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 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,593	Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis	2023	VLDB	5.8297039e-05
6,614	Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine	2025	SIGMOD	5.8216658e-05
6,742	Bf-Tree: A Modern Read-Write-Optimized Concurrent Larger-Than-Memory Range Index	2024	VLDB	5.7862414e-05
7,287	Is Perfect Hashing Practical for OLAP Systems?	2024	CIDR	5.6544795e-05
7,469	Optimizing Collections of Bloom Filters within a Space Budget	2024	VLDB	5.609743e-05
8,074	Parachute: Single-Pass Bi-Directional Information Passing	2025	VLDB	5.4929961e-05
8,863	BPF-DB: A Kernel-Embedded Transactional Database Management System For eBPF Applications	2025	SIGMOD	5.3551396e-05
9,465	Are Joins over LSM-trees Ready? Take RocksDB as an Example	2025	VLDB	5.2634238e-05
10,135	I Can't Believe It's Not Yannakakis: Pragmatic Bitmap Filters in Microsoft SQL Server	2026	CIDR	5.093636e-05
10,235	EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction	2026	SIGMOD	5.093636e-05
10,543	How to Write to SSDs	2026	VLDB	5.093636e-05
11,119	The Tipping Point of Edge-Cloud Data Management	2024	CIDR	5.093636e-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
103	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00034161428
959	Memory-Efficient Hash Joins	2015	VLDB	0.00012953588
2,156	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	9.0635624e-05
4,849	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	6.4803828e-05
5,014	Applying Hash Filters to Improving the Execution of Bushy Trees	1993	VLDB	6.4002123e-05
9,443	Introducing a Query Acceleration Path for Analytics in SQLite3	2022	CIDR	5.2676282e-05

Semantically Similar Papers

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