From avi.im
How bloom filters made SQLite 10x faster - blag
2 19
This is the fascinating story of how researchers used Bloom filters cleverly to make SQLite 10x faster for analytical queries. These are my five-minute notes on the paper SQLite: Past, Present, and Future
#sqlite #database #programming
on Sun, 4PM
From avi.im
In search of a faster SQLite - blag
0 4
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.
on Dec 14
From avi.im
0 0
I recently learned about Galloping Search while building a distributed log called s3-log. It’s used to search sorted items when the upper bound is unknown. In this short post, I will share my notes and other alternatives I discovered for searching over unbounded items
on Dec 7
From avi.im
Building a distributed log using S3 (under 150 lines of Go) - blag
0 0
In this third part of the series, I will show how we can implement a durable, distributed, and highly available log using S3
on Dec 1
From avi.im
0 1
State is pain. The next generation of infrastructure tools will be built on diskless paradigm. In this short post I will explain what is Diskless / Zero Disk Architecture
on Nov 24
From avi.im
PSA: Most databases do not do checksums by default - blag
0 0
Most databases don’t do checksums by default. Disk corruptions go silently unnoticed.
on Nov 10
From avi.im
PSA: SQLite does not do checksums - blag
0 0
SQLite does not do checksums by default. Disk corruptions go silently unnoticed.
on Nov 9
From avi.im
Disaggregated Storage - a brief introduction - blag
0 0
a brief introduction to disaggregated storage systems in context of database systems
on Nov 3
From avi.im
Towards Inserting One Billion Rows in SQLite Under A Minute - blag
0 0
This is a chronicle of my experiment where I set out to insert 1B rows in SQLite
on Aug 6
From avi.im
Why does SQLite (in production) have such a bad rep? - blag
0 0
My answer to a question online, why?
on Jun 26
From avi.im
It is becoming difficult for me to be productive in Python - blag
0 1
It’s harder to refactor a large Python codebase. Type hints won’t save you, and you need a lot of unit tests. But how does that work in practice? Is Python fast to ship?
on Oct 6, 2023