Get the latest tech news
In Search of a Faster SQLite
Researchers at the University of Helsinki and Cambridge attempted to build a faster SQLite using modern programming paradigms like io_uring and disaggregated storage. They demonstrate up to a 100x reduction in tail latency. These are my notes.
It allows the application to submit an I/O request and concurrently perform other tasks until it receives a notification from the OS on the com- pletion of the I/O operation. The sqlite3_step() function executes the sequence of bytecode instructions until the query produces a row to read, or it com- pletes. Mapping table-like data into a KV model leads to poor developer experience and (de)serialization costs.
Or read this on Hacker News