avi.im - Profile | ThreadSky | a Reddit-style client for Bluesky

If you're looking for fun side project ideas, consider adding the try(?) operator to the Go compiler. I saw a recent proposal by the core team about adding it, which reminded me of this.

submitted 2 days ago • 1 comment

What do you want to learn in 2025? (I asked my fren last month, but he said to ask him after a month because in the first week of January he is full of optimism which dies by the month's end)

submitted 18 days ago • 3 comments

Have there been any serious attempts at writing a database that uses the Postgres protocol backed by Vitess (MySQL)?

submitted 28 days ago • 1 comment

Incredible Zig project: Lightpanda Browser for headless usage. It is built from scratch, no Chromium / Webkit dependency Superfast! 11x faster than Chrome while keeping super low memory footprint (9x less)

submitted 31 days ago • 2 comments

this madlad typed out entire codebase of SQLite to learn

submitted 35 days ago • 0 comments

TIL

submitted 36 days ago • 2 comments

[new blog post] Use of Time in Distributed Databases (part 5): Lessons learned muratbuffalo.blogspot.com/2025/01/use-...

submitted 41 days ago • 0 comments

locked in

submitted 51 days ago • 2 comments

2025 is a special year for databases. If you insert birth year and age, their sum using a SELECT returns 2025! Magical ✨

submitted 52 days ago • 2 comments

Collection of insane and fun facts about SQLite This is a fun one. 24 more or less useful sqlite facts. Thanks for collecting @avi.im!

submitted 52 days ago • 0 comments

What was the fun research paper / article / post you read about databases in 2024?

submitted 52 days ago • 0 comments

Random Trivia: SQLite experimented with adding LSM Trees, which they called SQLite4. DRH wasn't happy with its performance in insert-heavy use cases (I don't have a source right now). However, they took all the lessons learned from the experiment and applied them to the B-Tree

submitted 53 days ago • 1 comment

I would welcome an empirical study or survey paper comparing B-Trees and LSM Trees, focusing on performance, resource utilization, and code complexity

submitted 53 days ago • 0 comments

I've finally finished my Advent of Code optimization blog post, just in time before the new year cprimozic.net/blog/optimiz...

submitted 55 days ago • 0 comments

I wish they had also compared Microsoft Garnet (FASTER) with DragonFly and Redis, because Garnet claims to beat both microsoft.github.io/garnet/docs/...

submitted 54 days ago • 1 comment

If you want to read one article to get all the juice from last year's database landscape, then check out Andy's article It has everything, from Redis' license change to Larry Ellison's love life www.cs.cmu.edu/~pavl...

submitted 54 days ago • 1 comment

2024 Wrapped Here are the top five blog posts that people loved reading on my blog (avi.im/blag)

submitted 54 days ago • 1 comment

Buckle up because we're banging into the new year with my annual retrospective of the last year in databases! Highlights include license change blowback, Databricks vs. Snowflake gangwar, @duckdb.org's shotgun weddings, and buying a quarterback to impress your lover: www.cs.cmu.edu/~pavlo/blog/...

submitted 55 days ago • 11 comments

2024 Wrapped The year was great in terms of learning! Just a few days ago, I was reading a research paper (on databases, ofc) and many things made sense to me instantly. I had read the same paper at the start of this year, but it was different earlier. 1/2

submitted 55 days ago • 1 comment

ngl, made me chuckle

submitted 56 days ago • 2 comments

btw, JWT is supposed to be pronounced as jot

submitted 56 days ago • 2 comments

The top Reddit comment

submitted 56 days ago • 1 comment

Published a new blog post: Some insane facts about SQLite! avi.im/blag/2024/sq...

submitted 57 days ago • 2 comments

I found this comparison between Postgres and SQLite. It covers latency and throughput measurements for reads and writes.

submitted 58 days ago • 1 comment

Advent of Code 2024 in pure SQL (by TUM folks) 💀 databasearchitects.blogspot.com/2024/12/adve...

submitted 58 days ago • 1 comment