How Pinterest Uses JSON

This article discusses how implementing the Lightning Memory-Mapped Database (LMDB) improved memory management and performance for Pinterest's API service.

The article discusses Pinterest's migration from Druid to StarRocks for delivering faster analytics.

The article discusses Pinterest's development of a Text-to-SQL feature that utilizes Large Language Models (LLMs) to assist data users in generating SQL queries from natural language questions.

In 2023, Pinterest Engineering achieved significant milestones by launching various innovative products, including new ad formats and inclusive AI technology.

This article discusses the integration of Python-based anomaly detection algorithms into Pinterest's Warden platform, originally built in Java.

This article discusses the development of an end-to-end JSON logging system for client applications at Pinterest, highlighting the challenges faced with existing logging methods and the design deci...

The article discusses how Pinterest utilizes Apache Spark SQL for interactive querying, detailing the architecture, challenges faced, and solutions implemented to enhance user experience.

The article discusses the importance of quality and testing of advertising metrics on mobile devices at Pinterest.

The article discusses Pinterest's Flink Deployment Framework, which is built on Bazel and integrates with various internal services to streamline the deployment of Flink jobs.

This article discusses how Pinterest's Engineering Productivity team redesigned their Continuous Integration (CI) system to achieve over 50% faster build times.

The article discusses the implementation of pre-submit integration tests for the ads-serving platform at Pinterest, aimed at improving code quality and reducing deployment issues.

The article discusses Pinterest's transition from using Apache HBase to Apache Druid for ads analytics, highlighting the challenges faced and the benefits of Druid's capabilities in handling comple...

The article introduces Pinqueue3. 0, Pinterest's advanced content moderation platform designed to enhance the review process for abusive content.

The article discusses the importance of ad metrics quality and testing on mobile platforms at Pinterest.

The article discusses Goku, an in-house time series database developed by Pinterest to address the limitations of OpenTSDB as the company scales.

The article discusses four key lessons learned by Pinterest engineers in enhancing the performance of their Android app.

The article discusses the development of the Experience Framework at Pinterest, aimed at enhancing user experience for over 175 million monthly active users by managing various in-product experienc...

The article discusses the implementation of linting at Pinterest for their iOS codebase, focusing on the integration of Clang tools with their Bazel build system.

The article introduces Plank, an immutable model generator for iOS, developed by Pinterest to enhance app performance and safety.

This article discusses advancements in MySQL compression techniques at Pinterest, specifically focusing on improving the compression ratio of Pin data stored as JSON blobs.

The article discusses Pinterest's migration from a legacy template rendering engine to React, highlighting the performance improvements and developer efficiency gained through this transition.

The article discusses the evolution of MySQL compression techniques at Pinterest, particularly focusing on the challenges faced with InnoDB page compression and the development of a new column comp...

The article discusses the transition of Pinterest's iOS app to a completely immutable model layer, highlighting the motivations behind this architectural change and how it enhances data consistency...

The article discusses the comprehensive re-architecture of Pinterest's iOS app, emphasizing performance improvements, the adoption of AsyncDisplayKit for asynchronous UI rendering, and the implemen...

The article discusses the open-sourcing of KingPin, a toolset developed by Pinterest to enhance scalability and reliability in their infrastructure.

This article details Pinterest's approach to scaling its MySQL database through sharding, which was implemented in early 2012 and remains in use today.

The article discusses the implementation of Shared Web Credentials in iOS apps to streamline user login experiences by allowing apps to access the same password store used by Safari.

This article discusses how Pinterest improved its JavaScript testing framework, reducing test execution time from 15 minutes to just 1 minute.