惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Hugging Face - Blog
Hugging Face - Blog
WordPress大学
WordPress大学
Microsoft Azure Blog
Microsoft Azure Blog
F
Fortinet All Blogs
B
Blog RSS Feed
Last Week in AI
Last Week in AI
The Cloudflare Blog
大猫的无限游戏
大猫的无限游戏
人人都是产品经理
人人都是产品经理
P
Proofpoint News Feed
H
Hackread – Cybersecurity News, Data Breaches, AI and More
Microsoft Security Blog
Microsoft Security Blog
博客园 - 三生石上(FineUI控件)
Y
Y Combinator Blog
GbyAI
GbyAI
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
小众软件
小众软件
雷峰网
雷峰网
C
Check Point Blog
阮一峰的网络日志
阮一峰的网络日志
博客园 - 叶小钗
博客园 - 司徒正美
U
Unit 42
量子位

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant
Notion API Rate Limits Are Breaking Your Automation — Her...
kanta13jp1 · 2026-04-27 · via DEV Community

kanta13jp1

Notion API Rate Limits Are Breaking Your Automation — Here's the Real Fix

When 429 Becomes Your Most Common Error

Have you tried automating your life data with the Notion API?

Auto-sync health data from Apple HealthKit. Log Stripe webhook income directly to a database. Sync daily tasks with GitHub Issues.

If you've tried, you know what happens: HTTP 429 Too Many Requests shows up fast.


Notion API Rate Limits: The Precise Numbers

Notion's official docs state:

Average of 3 requests per second per integration token

The word "average" is doing a lot of work there. Short bursts are tolerated, but sustained throughput above 3 req/s triggers 429s.

Here's what that looks like in practice:

Use Case Requests Needed Problem
Write 30 days of health data 30+ reqs (1 per day) 10+ seconds
Habit tracker (10 items × 30 days) 300+ reqs 100+ seconds
Monthly finance import 50–200 reqs Burst → 429
Cross-database queries pages × tables Hits cap instantly

The Block Limit Compounds It

On top of the rate limit, each page has a 1000-block ceiling. Attempt to write dense data — long journals, bulk imports — and you hit a second wall mid-operation.


The Standard "Solutions" and Why They Fall Short

Solution 1: Queuing + Exponential Backoff

import time
import random

def notion_request_with_backoff(fn, max_retries=5):
    for attempt in range(max_retries):
        try:
            return fn()
        except Exception as e:
            if "429" in str(e):
                wait = (2 ** attempt) + random.uniform(0, 1)
                time.sleep(wait)
            else:
                raise
    raise Exception("Max retries exceeded")

Enter fullscreen mode Exit fullscreen mode

The catch: Accumulated wait time. A 30-minute sync job becomes 2–3 hours.

Solution 2: Batch Writing

Notion API lets you write multiple blocks in a single request. Compress 100 blocks into 1 request and you get 100× efficiency in theory.

The catch: Payload size limits (2000 blocks/request) + child pages require separate requests.

Solution 3: Cache + Diff Sync

Only write changes since the last sync rather than full rewrites.

The catch: Diff logic gets complex fast. Notion DB versioning is weak — collision handling is a real engineering problem.


Why These Workarounds Don't Solve the Underlying Problem

The root issue is that Notion was designed for team document management, not for programmatic data ingestion.

Team Notion Usage Personal Life Log
Humans write documents Programs write data
Dozens of writes/day Hundreds–thousands of writes/day
Someone reads the output An analytics tool reads it
Schema rarely changes Schema evolves constantly

Personal life logging needs a database. Notion is not one.


An Architecture That Bypasses Rate Limits by Design

Here's what Jibun Kaisha uses instead:

Apple HealthKit / Webhooks / External APIs
              ↓
  Supabase Edge Function (Deno)
  - Buffering
  - Batch processing
  - Direct PostgreSQL writes
              ↓
  PostgreSQL (effectively unlimited writes)
              ↓
  Flutter Web (Realtime subscriptions)

Enter fullscreen mode Exit fullscreen mode

Supabase throughput for reference:

  • Edge Function: 500 req/sec (free tier)
  • PostgreSQL: 60 pooled connections (Pgbouncer)
  • Realtime: connections × channels, practically unlimited

Compare to Notion's 3 req/sec: that's 167× the throughput.

Side-by-Side: Notion API vs. Supabase PostgreSQL

Dimension Notion API Supabase PostgreSQL
Write speed 3 req/sec Thousands of inserts/sec
Batch size 2000 blocks/req Unlimited
Transactions None Full ACID
Custom indexes Fixed Any column
Aggregate queries Impossible Full SQL
Realtime None Realtime API

If You Want to Stay on Notion: The Realistic Ceiling

If you're committed to Notion API for personal automation, here's a practical ceiling:

  • Daily batch jobs only (forget real-time sync)
  • ≤ 100 writes/day (3 req/sec × 30s = 90 req, with margin)
  • No cross-database JOINs (Notion DBs don't relate across databases natively)
  • ≤ 500 blocks/page (50% of the 1000-block limit as safety margin)

That works for: simple daily journals, weekly reviews, lightweight logs.

It doesn't work for full life-data automation.


Summary

Notion's 3 req/sec rate limit is entirely reasonable for team document workflows.

For personal automation — syncing health data, finance, habits, learning, and work into one dashboard — it breaks down immediately. Queuing and diff sync are band-aids, not solutions.

What you actually need: an architecture where your data store is a real database with direct write access — not a document tool with a public API bolt-on.

Try Jibun Kaisha free — no API limits, zero setup