Engineering Insights

Solving N+1’s with Rails `exists?` queries

We recently had a performance issue in our Rails application where we had several N+1 .exists? queries on a single API endpoint. In the following query, we check to see if the "data_imports" feature is enabled for a user:user.beta_feature.where(name: "data_imports").enabled.exists? Output:BetaFeature Exists? (0.6ms) SELECT 1 AS one FROM `beta_feature` WHERE `beta_feature`.`name` = 'data_imports' AND `beta_feature`.`target_type` = 'User' AND `beta_feature`.`target_id` = 1 AND `beta_feature`.`en

Building a global streetwear label with Next.js

is a Brooklyn-based cult streetwear label and hybrid art brand with strong ties to the music, sports, and tech communities. From collaborating with the likes of Puma and Nike to co-designing Louis Vuitton's 2023 menswear collection, founder Colm Dillane and CTO Adham Foda are known worldwide for their boundary-pushing approach to fashion. KidSuper The brand went viral in 2011 after Mac Miller wore their apparel on the cover of iTunes, and the duo knew they’d eventually require a tech solution t

Building a fast, animated image gallery with Next.js

We held our biggest ever Next.js Conference on October 25, 2022 with over 110,000 registered developers, 55,000 online attendees, and hundreds attending in person in San Fransisco. We had photographers on site to capture the experience and we wanted to share the photos they took with the community. Instead of just sharing photos with a Google Drive link, we thought it’d be good idea to showcase these 350+ amazing photos in an that was fast, functional, and beautiful. We ended up building our o

AI for Game Development: Creating a Farming Game in 5 Days. Part 2

Node.js 19.4.0 (Current)

Node.js 18.13.0 (LTS)

Faster MySQL with HTTP/3

Over here at PlanetScale, we offer you a MySQL database. As a part of this offering, it is critical that we offer you a MySQL protocol-compatible interface to access. This enables using mysql-client as well as any MySQL-compatible driver for your favorite language. But what if we weren’t constrained by this? Could we provide an alternative interface and API? Most of what I will be discussing is not publicly documented and is entirely experimental. The background As a part of some of our infrastr

Delivering nuanced insights from customer feedback

Using GPT-3 to deliver fast, nuanced insights from customer feedback.