Engineering Insights

Using redundant conditions to unlock indexes in MySQL

When working with MySQL (or any database!), it's essential to understand how indexes work and how they can be used to improve the efficiency of queries. An index is a separate data structure that maintains a copy of part of your data, structured to allow quick data retrieval. Usually, this structure is a B+ Tree. We have an entire post on how indexes work if you want to go into greater detail. Obfuscated indexes Creating indexes is only part of the battle. You must also know how to write your qu

DuckDB: analyze 50,000+ datasets stored on the Hugging Face Hub

Visual Editing meets Markdown

We're excited to share that now supports in Vercel Preview Deployments.TinaCMSVisual Editing The TinaCMS team is on a mission to bring visual editing to the headless CMS in a way that works for developers. So when we had the opportunity to collaborate with Vercel on this, we didn't hesitate and the results are stunning. Read more

Welcome fastText to the Hugging Face Hub

The Falcon has landed in the Hugging Face ecosystem

Designing the Vercel virtual product tour

If you've tried a new tech tool recently, this experience might sound familiar: you visit the website, skim the homepage content, but still struggle to understand what the tool will do for you. The is a key resource for prospective teams to interactively understand what Vercel can offer. It takes the breadth of information about Vercel and breaks the product down into the most relevant parts.Vercel virtual product tour First, we’ll talk about why we designed the tour the way we did. Then, for t

AI Speech Recognition in Unity

Optimizing query planning in Vitess: a step-by-step approach

Introduction In this blog post, we will discuss an example of a change to the Vitess query planner and how it enhances the optimization process. The new model focuses on making every step in the optimization pipeline a runnable plan. This approach offers several benefits, including simpler understanding and reasoning, ease of testing, and the ability to use arbitrary expressions in ordering, grouping, and aggregations. Vitess distributed query planner VTGate is the proxy component of Vitess. It