Engineering Insights

Improving query performance with database indexes using Prisma: Hash indexes

Learn how you can optimize a slow database query in your application with a Hash index using Prisma

Optimization story: Bloom inference

Optimizing queries in arewefastyet

Arewefastyet is an automatic benchmarking tool for Vitess. It runs automated micro and macro benchmarks daily to monitor the performance of Vitess. Arewefastyet uses PlanetScale for its database, which comes with an in-dashboard query monitoring tool: Insights. This tool provides a complete overview of your database's performance, including details all the way down to the individual query level. Using Insights, we were able to detect and improve the performance of two slow queries, which resulte

Introducing OG Image Generation: Fast, dynamic social card images at the Edge

We’re excited to announce – a new library for generating dynamic social card images. This approach is than existing solutions by using Vercel Edge Functions, WebAssembly, and a brand new core library for converting HTML/CSS into SVGs.Vercel OG Image Generation5x faster Try it out in seconds. Read more

Volar 1.0 "Nika" Released!

We are happy to announce that we have released v1.0 of Volar, the official IDE/TS tooling support for Vue! 🎉 This major version ships with tons of improvements across the board. In addition to improving UX, performance, and package size, we also released Plugin API v1 and refactored the core code to be framework-agnostic. 注：結尾附有中文版本 (There is Chinese version of this post at the end)。

Introduction to MySQL joins

Relational databases, such as MySQL, give you the ability to organize data into separate tables, but link the tables together to form relationships when necessary. MySQL joins give you the ability to link data together in a MySQL database. A join is a way to get columns from more than one table into a single set of results. This is usually much more efficient than trying to perform multiple queries and combining them later. This article looks at the different types of joins that can be performed

Introducing DOI: the Digital Object Identifier to Datasets and Models

Japanese Stable Diffusion