How Notion uses SQLite for Caching
Notion is a popular productivity app. It’s used it for taking notes, building spreadsheets, managing calendars, tracking timelines and more. Think Google Docs, but much more versatile. Notion Branding Engineers at Notion must ensure that every user has a great experience regardless of whether they’re using Notion through the website, windows application, iOS app, macOS app etc. In 2021, Notion started using a SQLite database for caching data in the windows and macOS apps. This change made initial page loads 50% faster and also sped up navigating between pages by 50%. Objective: In 2021 Notion wanted to use caching to bring performance gains for users who use Notion through their browser. For example, caching API responses and page edits to the local file system. This means navigating between pages wouldn’t always result in an API request to Notion’s backend. Notion wrote a terrific blog post delving into how this change was implemented and why it was challenging. We will summarize the
How Notion uses SQLite for Caching Home Posts How Notion uses SQLite for Caching How Notion uses SQLite for Caching Notion uses SQLite for client-side caching. We'll talk about why they implemented this and hurdles they needed to solve Sep 7, 2024 How Notion uses SQLite for Caching Notion is a popular productivity app. It’s used it for taking notes, building spreadsheets, managing calendars, tracking timelines and more. Think Google Docs, but much more versatile. Notion Branding Engineers at Notion must ensure that every user has a great experience regardless of whether they’re using Notion th
Explore this link on the map →