• Trends
  • Topics
  • Nodes
Search for keywords, #hashtags, $sites, add a dash to exclude, e.g. -$theonion.com

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

Galloping Search - blag

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

Zero Disk Architecture - blag

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

v

0 0

v: Go and Rust programmer from India.

on Nov 22

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

Snapshot Testing - blag

0 0

A smoll intro to snapshot testing

on Mar 3

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