Ideas for building
better software.

Why isn’t MySQL using my index?

One of the most frustrating experiences when dealing with databases is when you've designed the perfect index, but MySQL still doesn't use it. There are several reasons why this could be the case, and in this article, we'll explore some of the most common ones. Throughout this article, we'll be working with a very simple people table that looks like this:CREATE TABLE `people` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL

StarCoder: A State-of-the-Art LLM for Code

Serverless Laravel applications with AWS Lambda and PlanetScale

In general, PHP-based applications, like Laravel, are deployed on servers. It is also possible to run them serverless — for example, on AWS Lambda. This approach provides several benefits: Instant and effortless autoscaling to handle incoming traffic. Redundant and resilient infrastructure out of the box, without extra complexity. Pay-per-request billing. PlanetScale is a great database to pair with serverless Laravel applications running on Lambda. In this article, we will create a new Laravel

Node.js 20.1.0 (Current)

Visual Editing: Click-to-edit content for headless CMSes

Adding collaborative to Vercel Previews Deployments was our first step towards bringing the workflow of Google Docs and Figma to web development. comments Today, we're bringing content editing to your Preview Deployment interface with Visual Editing. Anyone can visually edit content and experience faster iteration—from developers to marketing teams. Read more

Quality software at scale with Vercel Spaces

As companies and codebases grow, it becomes hard to sustain a fast release cycle without letting errors slip in to production. It shouldn't be this way. We should be able to move fast breaking things—making quick updates while retaining great performance, security, and accessibility.without Today, we're introducing Vercel Spaces, the biggest evolution of Vercel's workflow yet. Introducing powerful tools and conventions designed to integrate with your setup, to help you scale efficiently while

React Canaries: Enabling Incremental Feature Rollout Outside Meta

We'd like to offer the React community an option to adopt individual new features as soon as their design is close to final, before they're released in a stable version--similar to how Meta has long used bleeding-edge versions of React internally. We are introducing a new officially supported [Canary release channel](/community/versioning-policy#canary-channel). It lets curated setups like frameworks decouple adoption of individual React features from the React release schedule.

Introducing Vercel Firewall and Vercel Secure Compute

Finding the right balance between developer experience and robust enterprise-grade security can be challenging. Developers want tools that streamline workflows and enhance productivity, while organizations prioritize security measures to protect sensitive data and meet compliance standards. At Vercel, we believe you can have the best of both worlds—exceptional developer experience and top-tier security. Read more