Ideas for building
better software.

Generated Hash Columns in MySQL

One of the hidden gems in the MySQL documentation is this note in section 8.3.6: As an alternative to a composite index, you can introduce a column that is “hashed” based on information from other columns. If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. We will build on this idea by creating generated hash columns for indexed lookups on large values and enforcing uniqueness across many columns. Instead of creating huge composite in

Faster Stable Diffusion with Core ML on iPhone, iPad, and Mac

Deploy Livebook notebooks as apps to Hugging Face Spaces

Announcing our new Content Guidelines and Policy

Introducing Vercel's AI Accelerator

Today, we’re announcing Vercel’s AI Accelerator – a program for the brightest AI builders and early stage startups. Over a span of 6 weeks, we aim to empower 40 of the industry's top innovators to create and develop next-generation AI apps. Applications are open for two weeks – .apply today Read more

Using PlanetScale with Serverless Framework Node applications on AWS

The Serverless Framework is great for building Node applications on AWS Lambda. The only thing missing is a serverless database. In this article, we will explore how to use PlanetScale as the database for a serverless Node application. Prerequisites Before deploying to AWS Lambda, you will need: an AWS account (to create one, go to aws.amazon.com and click Sign up), the serverless CLI installed on your computer. While the example of this article should stay under the AWS free tier (1 million fre

Function calling and other API updates

We’re announcing updates including more steerable API models, function calling capabilities, longer context, and lower prices.

Hugging Face and AMD partner on accelerating state-of-the-art models for CPU and GPU platforms