The Curious Engineer

All blogs / Databases

blag

avi.im/blag

Recent content on blag

DatabasesStorage / filesystemsDistributed systems / cloudGo

’15’20’25
Posts
67 from 5 Dec 2013 to 18 Apr 2026
Posting
now and then (1 in the last year)
Kind
personal blog
Feed
https://avi.im/blag/index.xml

2026 1

  1. SQLite prefixes its temp files with `etilqs_`

2025 6

  1. Setsum - order agnostic, additive, subtractive checksum
  2. Oldest recorded transaction
  3. Replacing a cache service with a database
  4. SQLite commits are not durable under default settings
  5. PSA: SQLite WAL checksums fail silently and may lose data
  6. Rickrolling Turso DB (SQLite rewrite in Rust)

2024 14

  1. Collection of insane and fun facts about SQLite
  2. How bloom filters made SQLite 10x faster
  3. In search of a faster SQLite
  4. Galloping Search
  5. Building a distributed log using S3 (under 150 lines of Go)
  6. Zero Disk Architecture
  7. PSA: Most databases do not do checksums by default
  8. PSA: SQLite does not do checksums
  9. Disaggregated Storage - a brief introduction
  10. Why does SQLite (in production) have such a bad rep?
  11. SQLite Slaps
  12. Learning C
  13. Snapshot Testing
  14. Win: contribution to libSQL (SQLite) codebase

2023 3

  1. Errata in Hekaton MVCC paper
  2. Internet is wholesome: MVCC edition
  3. It is becoming difficult for me to be productive in Python

2022 3

  1. MongoDB secondary only index
  2. Introducing CaskDB – a project to teach you writing a key-value store
  3. Recurse Center: Winter Break

2021 27

  1. Recurse Center Day 24: Hacking Go compiler to add a new keyword
  2. Recurse Center Day 20: Django v4 upgrade (from v1)
  3. Recurse Center Day 19
  4. Recurse Center Day 18
  5. Recurse Center Day 17
  6. Recurse Center Day 16: Open Source
  7. Recurse Center Day 15: B Tree Algorithms
  8. Recurse Center Day 14: NoSQL Transactions
  9. Recurse Center Day 13: Why 'Raft'?
  10. Recurse Center Day 12: Isolation Anomalies
  11. Recurse Center Day 11: B Tree Insertions
  12. Recurse Center Day 10: Learning Distributed Systems
  13. Recurse Center Day 9: Papers We Love
  14. Recurse Center Day 8: B Tree Fill Factor (Part 2)
  15. Recurse Center Day 7: Basics of ncurses
  16. Recurse Center Day 6: B Tree Root
  17. Recurse Center First Week
  18. Recurse Center Day 5: Garbage Collection Algorithms
  19. Recurse Center Day 4: B Tree fill factor
  20. Recurse Center Day 3: Hammock Driven Development
  21. Recurse Center Day 2: BTree Node
  22. Recurse Center Day 1: init
  23. What I want to do at Recurse Center
  24. Accepted to the Recurse Center!
  25. Towards Inserting One Billion Rows in SQLite Under A Minute
  26. Marshaling Struct with Special Fields to JSON in Golang
  27. I ended up adding duplicate records on a unique index in MongoDB

2020 2

  1. Setting up Github Actions for Hugo
  2. Moving to Hugo

2016 2

  1. Catching SIGTERM in Python
  2. Git/Github fork-pull request-update cycle

2015 6

  1. Using uWSGI with Python 3
  2. When is my Cake Day?
  3. Staying Ahead of Amazon, in Amazon Treasure Hunt Contest
  4. How I Am Maintaining Multiple Emails For Git On A Same Machine
  5. An exploit on Gaana.com gave me access to their entire User Database
  6. Flashing Asus-WRT Merlin by XVortex on NetGear NightHawk R7000

2014 2

  1. Install Windows 8 UEFI on Legacy BIOS with Clover (and Dual boot with Yosemite)
  2. Scraping Javascript page using Python

2013 1

  1. Installing Transmission (remote and CLI) client on Raspberry Pi