Hacker News new | past | comments | ask | show | jobs | submit | bddicken's comments login

The corresponding blog post covers this a bit:

https://planetscale.com/blog/btrees-and-database-indexes

In short, B+trees are good because the nodes can be set to match the size of a disk page.


The "reject all" button works better now, thanks for bringing this up.

Great to hear! Just checked it again on FF/Android and it works just how I'd have expected. Thanks for the update!

Good point! Yes, clustered index is one of the correct terms.

It's meant to represent the values associated with the keys being inserted. Having the "v" for "value" there helps to differentiate it.

I'm sorry about this! working on a fix.

You're welcome! Sharding with B tree indexes... Hmmm, I know a company that does that.

Thanks Sean! Yeah that would be very cool to have an interactive visual for that as well. So many possibilities!

That's the goal! Thanks for the kind words.

You are welcome.


You can find my email via the "Contact the Author" button at the bottom of the home page.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: