Hacker GitHub

← All repos

eatonphil/databases-intuition

View on GitHub ↗ ★ 54 Go

Building an intuition for latency and throughput of basic operations across SQL databases.

3 mentions on Hacker News by 1 person: 0 stories, 3 comments · first 2023-09-26 · latest 2023-12-13

Mentions per year 3 mentions · busiest year 2023 (3)
20082026
AllStoriesComments NewestTopOldest
  1. I've done some variations of this as well recently. For inserts: https://github.com/eatonphil/databases-intuition/blob/main/R... . And for selects: https://github.com/eatonphil/databases-intuition/blob/main/R... . Our workloads are a bit…
    comment by eatonphil · 2023-12-13 · in I benchmarked six Go SQLite drivers
  2. …you can get into the 100,000s inserts per second range, and even near 1M inserts per second. https://github.com/eatonphil/databases-intuition#go-mattngo-...
    comment by eatonphil · 2023-10-27 · in Why you should probably be using SQLite
  3. …postgres, and sqlite without indexes. I didn't have the patience of OP though to push it to 1B. https://github.com/eatonphil/databases-intuition
    comment by eatonphil · 2023-09-26 · in Batch size one billion: SQLite insert speedups, from the useful to the absurd