Record🤔

uri:

"at://did:plc:hdhoaan3xa3jiuq4fg4mefid/app.bsky.feed.post/3lcosacefrc27"

cid:

"bafyreienaloh6sus7wrhu3zaltdpx2csbcqikdgaio6b266qn4mzz7fzri"

value:

text:

"finally getting this test going for the gold standard of kv databases, the sqlite of sqlites, it’s time for sqlite.

it actually led all the others for speed until about 1.5M entries. sqlite is fast!

at 3M bbolt and redb are faster. how’s it going to compare at 17.5M?"

$type:

"app.bsky.feed.post"

embed:

$type:

"app.bsky.embed.images"

images:

• alt:

  "sqlite disk size grows extremely linearly like the other btree dbs, but is slightly more disk efficient: about 93 bytes per entry"

  image:

  

  View blob content

  $type:

  "blob"

  ref:

  $link:

  bafkreigzi6vjmbub23uuhvpzcorylbkav5ff6orof2qxhwlgvgeu6m2hni

  mimeType:

  "image/jpeg"

  size:

  364594

  aspectRatio:

  width:

  2000

  height:

  885

• alt:

  "sqlite is fast! it leads all the kv databases until about 1.5 million entries, then keeps dropping to trail redb and bbolt, but maintaining a margin over pebble by 3 million."

  image:

  

  View blob content

  $type:

  "blob"

  ref:

  $link:

  bafkreie3cuucl3ntwfxlkvqyzxf2moct6hx6axrge5xfxchn7q7hqulwpu

  mimeType:

  "image/jpeg"

  size:

  559359

  aspectRatio:

  width:

  1986

  height:

  884

langs:

• "en"

reply:

root:

cid:

"bafyreie7fvc4s7226dpwt2wc4putdxt3oq4sfdhif763jm3nba5xzy5s2q"

uri:

"at://did:plc:hdhoaan3xa3jiuq4fg4mefid/app.bsky.feed.post/3lcj3bls2hk24"

parent:

cid:

"bafyreib5mudxavhpnzdp7cbp6fin2pc6gpqgvwfvp5iw5n6mou7s3bwqvu"

uri:

"at://did:plc:hdhoaan3xa3jiuq4fg4mefid/app.bsky.feed.post/3lcomhzat6s2t"

createdAt:

"2024-12-07T03:51:39.994Z"