SQL Statement Logging for Making SQLite Truly Lite
Summary: SQLite/SSL logs small SQL statements at commit, reducing write amplification for durable, fast transactions. Using WAL checkpoints and NVM-backed logs, it enables redo-only recovery and beats vanilla WAL and PPL by up to 300x IO-time. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jong-Hyeok Park (Sungkyunkwan University)
- 2. Gihwan Oh (Sungkyunkwan University)
- 3. Sang-Won Lee (Sungkyunkwan University)
BibTeX Citation
@article{park_vldb18,
title = {{SQL Statement Logging for Making SQLite Truly Lite}},
author = {Park, Jong-Hyeok and Oh, Gihwan and Lee, Sang-Won},
journal = {PVLDB},
series = {{VLDB} '18},
volume = {11},
number = {4},
pages = {513--525},
doi = {10.1145/3164135.3164146},
url = {https://doi.org/10.1145/3164135.3164146},
year = {2018}
}Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,526 | Understanding the Idiosyncrasies of Real Persistent Memory | 2021 | VLDB | 7.3429293e-05 |
| 7,135 | SaS: SSD as SQL Database System | 2021 | VLDB | 5.6940523e-05 |
| 8,167 | DecLog: Decentralized Logging in Non-Volatile Memory for Time Series Database Systems | 2024 | VLDB | 5.4745703e-05 |
| 8,264 | DASH: Database Shadowing for Mobile DBMS | 2019 | VLDB | 5.4574671e-05 |
| 11,575 | In-Page Shadowing and Two-Version Timestamp Ordering for Mobile DBMSs | 2022 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 841 | Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems | 2015 | SIGMOD | 0.00013677356 |
| 5,531 | X-FTL: Transactional FTL for SQLite Databases | 2013 | SIGMOD | 6.1851294e-05 |
| 6,524 | SHARE Interface in Flash Storage for Relational and NoSQL Databases | 2016 | SIGMOD | 5.8516175e-05 |
| 6,949 | SQLite Optimization with Phase Change Memory for Mobile Applications | 2015 | VLDB | 5.7306218e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 9,443 | Introducing a Query Acceleration Path for Analytics in SQLite3 | 2022 | CIDR |
| 2 | 10,659 | Boosting OLTP Performance with Per-Page Logging on NVDIMM | 2025 | SIGMOD |
| 3 | 9,409 | NV-SQL: Boosting OLTP Performance with Non-Volatile DIMMs | 2023 | VLDB |
| 4 | 11,906 | SSD as SQLite Engine | 2018 | SIGMOD |
| 5 | 603 | Scalable Logging through Emerging Non-Volatile Memory | 2014 | VLDB |
| 6 | 4,894 | Optimizing Databases by Learning Hidden Parameters of Solid State Drives | 2020 | VLDB |
| 7 | 8,264 | DASH: Database Shadowing for Mobile DBMS | 2019 | VLDB |
| 8 | 11,575 | In-Page Shadowing and Two-Version Timestamp Ordering for Mobile DBMSs | 2022 | VLDB |
| 9 | 5,531 | X-FTL: Transactional FTL for SQLite Databases | 2013 | SIGMOD |
| 10 | 6,949 | SQLite Optimization with Phase Change Memory for Mobile Applications | 2015 | VLDB |