B-Trees and Database Indexes
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 80,870 posts.
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
Dynamicland is still going, just quietly. We closed the Oakland space for covid, but Realtalk development and collaborations have continued -- basically as originally planned, if more slowly due to our small size.
Today, we're introducing Mercury 2 — the world's fastest reasoning language model, built to make production AI feel instant.
The issue to stabilize an initial version of async/await in Rust has left final comment period. The feature looks slated to stabilize in an upcoming release, most likely 1.39. This represents the culmination of an enormous amount of work by people all over the Rust community. But it’s also only the beginning of…
We solve 20% of ARC-AGI-1 with no pretraining by minimizing the description length during inference time, with the only data involved being the target puzzle itself.
bypassing macOS's file quarantine, gatekeeper, and notarization requirements
Servo's Windows builds are ready for public consumption.
For this Hack Week edition we decided to port the classic Wolfenstein 3D game to Rust.
In 1997, about a year after launch, Hotmail was growing exponentially, adding thousands of new users every day. We were on fire. And then one night, it all seemed to unravel. We had a program called the “janitor” that ran as an overnight batch process and it erased all of the email that users put...
It’s 2013, almost three years after we first raised money and started growing beyond the first four employees . At the time, Jeff wrote a great blog post about working remotely, basically laying out our plan for how we were going to make it work. Now we’re a few years in and it’s time to update it with, well, what…
The maker community worried Qualcomm would kill the Arduino ethos. New T&Cs confirm the community's worst fears. Here's what's at stake, what Qualcomm got wrong, and what might still be salvaged.
Today, after 1 year and 4 months of work, we are happy to announce the release of the Xfce desktop 4.16, a new stable version that supersedes Xfce 4.14.
Some months ago, Google launched their Alpha program for their upcoming CDN service. We kept a close eye to their development and in the meanwhile, in NEXT 2016 Google has already announced the Beta phase of their CDN. We already discussed how this new product will fit in the broad palette of content distribution…
The authors are pleased to announce the release of a fully-featured...
I stumbled upon this bit of wisdom in Team Geek: A Software Developers Guide to Working Well with Others, and it resonated. It comes from Google engineer Chade-Meng Tan: Do the right thing, wait t…
Prefer SVG over PNG, trust browsers to downscale, drop obscure formats—the ultimate, exhaustive guide to favicons for modern web. Includes steps for static HTML and Webpack.
Online payment processing for internet businesses. Stripe is a suite of payment APIs that powers commerce for businesses of all sizes.
Let's take a peek at how the rollback journal works.
One of the best ways to learn and come up with new ideas is to focus intensely on a problem, then let your mind wander. I’ve enjoyed doing this when problem solving and learning, and recently I’ve been thinking about how weird it is to build trust in your unconscious to do the work for you, especially when it comes to…
Dear Yancey, I love Kickstarter. When I backed my first project in 2012, I was happy and excited to be given the opportunity to support creators with my pledge. Since then, Kickstarter has been an …
Hundreds of hours, many late nights, and a working Game Boy emulator in F# with sound, running on desktop and web.
A selected list of timeless and influential papers in distributed systems that shaped the research in the field. Intended to serve as a good…
sourcehut is a network of useful open source tools for software project maintainers and collaborators, including git repos, bug tracking, continuous integration, and mailing lists.
A pause to take stock: realising that attention heads are simpler than I thought explained why we do the calculations we do.
I’m writing this post from a hospital bed. And I couldn’t be happier. You hear folks say chemotherapy sucks, but until you go through it yourself, you don’t really know how bad it can be. It remains a popular activity only because it’s better than the alternative. My first exposure to chemotherapy was with this […]
A complete guide to quantization: how LLMs store parameters as floats, why shrinking them to 4 or 8 bits barely hurts accuracy, and how to measure the tradeoff.
This app has a surprising number of anti-debugging protections. Let's figure out how to bypass them.