1:"$Sreact.fragment"
2:I[75473,["/_next/static/chunks/316a3a63422f35de.js"],"default"]
3:I[78515,["/_next/static/chunks/316a3a63422f35de.js"],"default"]
4:I[30687,["/_next/static/chunks/fd0661f1506dcbc6.js"],"Toaster"]
5:I[61076,["/_next/static/chunks/fd0661f1506dcbc6.js"],"Analytics"]
7:I[47913,["/_next/static/chunks/316a3a63422f35de.js"],"OutletBoundary"]
8:"$Sreact.suspense"
a:I[47913,["/_next/static/chunks/316a3a63422f35de.js"],"ViewportBoundary"]
c:I[47913,["/_next/static/chunks/316a3a63422f35de.js"],"MetadataBoundary"]
e:I[90849,["/_next/static/chunks/316a3a63422f35de.js"],"default"]
:HL["/_next/static/chunks/609ea7bc18d0d15f.css","style"]
:HL["/_next/static/chunks/93b606aa9fdccd13.css","style"]
:HL["/_next/static/media/797e433ab948586e-s.p.479bea2b.woff2","font",{"crossOrigin":"","type":"font/woff2"}]
:HL["/_next/static/media/caa3a2e1cccd8315-s.p.3b6cae6d.woff2","font",{"crossOrigin":"","type":"font/woff2"}]
0:{"P":null,"b":"TlpKRvbES4zzM7LeczAM7","c":["","blog","async-sqlite-fastapi"],"q":"","i":false,"f":[[["",{"children":["blog",{"children":[["slug","async-sqlite-fastapi","d"],{"children":["__PAGE__",{}]}]}]},"$undefined","$undefined",true],[["$","$1","c",{"children":[[["$","link","0",{"rel":"stylesheet","href":"/_next/static/chunks/609ea7bc18d0d15f.css","precedence":"next","crossOrigin":"$undefined","nonce":"$undefined"}],["$","link","1",{"rel":"stylesheet","href":"/_next/static/chunks/93b606aa9fdccd13.css","precedence":"next","crossOrigin":"$undefined","nonce":"$undefined"}],["$","script","script-0",{"src":"/_next/static/chunks/fd0661f1506dcbc6.js","async":true,"nonce":"$undefined"}]],["$","html",null,{"lang":"en","children":[["$","head",null,{"children":[["$","script",null,{"async":true,"src":"https://www.googletagmanager.com/gtag/js?id=AW-18009878040"}],["$","script",null,{"dangerouslySetInnerHTML":{"__html":"\n          window.dataLayer = window.dataLayer || [];\n          function gtag(){dataLayer.push(arguments);}\n          gtag('js', new Date());\n          gtag('config', 'AW-18009878040');\n          gtag('config', 'G-W3XKYXV2SG');\n\n          // Persist UTM and gclid params to sessionStorage for cross-page tracking\n          (function() {\n            var params = new URLSearchParams(window.location.search);\n            var keys = ['utm_source','utm_medium','utm_campaign','utm_content','utm_term','gclid'];\n            keys.forEach(function(k) {\n              var v = params.get(k);\n              if (v) sessionStorage.setItem(k, v);\n            });\n          })();\n        "}}]]}],["$","body",null,{"className":"font-sans antialiased","children":[["$","$L2",null,{"parallelRouterKey":"children","error":"$undefined","errorStyles":"$undefined","errorScripts":"$undefined","template":["$","$L3",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":[[["$","title",null,{"children":"404: This page could not be found."}],["$","div",null,{"style":{"fontFamily":"system-ui,\"Segoe UI\",Roboto,Helvetica,Arial,sans-serif,\"Apple Color Emoji\",\"Segoe UI Emoji\"","height":"100vh","textAlign":"center","display":"flex","flexDirection":"column","alignItems":"center","justifyContent":"center"},"children":["$","div",null,{"children":[["$","style",null,{"dangerouslySetInnerHTML":{"__html":"body{color:#000;background:#fff;margin:0}.next-error-h1{border-right:1px solid rgba(0,0,0,.3)}@media (prefers-color-scheme:dark){body{color:#fff;background:#000}.next-error-h1{border-right:1px solid rgba(255,255,255,.3)}}"}}],["$","h1",null,{"className":"next-error-h1","style":{"display":"inline-block","margin":"0 20px 0 0","padding":"0 23px 0 0","fontSize":24,"fontWeight":500,"verticalAlign":"top","lineHeight":"49px"},"children":404}],["$","div",null,{"style":{"display":"inline-block"},"children":["$","h2",null,{"style":{"fontSize":14,"fontWeight":400,"lineHeight":"49px","margin":0},"children":"This page could not be found."}]}]]}]}]],[]],"forbidden":"$undefined","unauthorized":"$undefined"}],["$","$L4",null,{"position":"top-center","richColors":true,"toastOptions":{"style":{"background":"var(--popover)","color":"var(--popover-foreground)","border":"1px solid var(--border)"}}}],["$","$L5",null,{}]]}]]}]]}],{"children":[["$","$1","c",{"children":[null,["$","$L2",null,{"parallelRouterKey":"children","error":"$undefined","errorStyles":"$undefined","errorScripts":"$undefined","template":["$","$L3",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":"$undefined","forbidden":"$undefined","unauthorized":"$undefined"}]]}],{"children":[["$","$1","c",{"children":[null,["$","$L2",null,{"parallelRouterKey":"children","error":"$undefined","errorStyles":"$undefined","errorScripts":"$undefined","template":["$","$L3",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":"$undefined","forbidden":"$undefined","unauthorized":"$undefined"}]]}],{"children":[["$","$1","c",{"children":["$L6",[["$","script","script-0",{"src":"/_next/static/chunks/94245cbda44972fe.js","async":true,"nonce":"$undefined"}],["$","script","script-1",{"src":"/_next/static/chunks/af778fff4a0f4be6.js","async":true,"nonce":"$undefined"}],["$","script","script-2",{"src":"/_next/static/chunks/b096b037d08e2f31.js","async":true,"nonce":"$undefined"}]],["$","$L7",null,{"children":["$","$8",null,{"name":"Next.MetadataOutlet","children":"$@9"}]}]]}],{},null,false,false]},null,false,false]},null,false,false]},null,false,false],["$","$1","h",{"children":[null,["$","$La",null,{"children":"$Lb"}],["$","div",null,{"hidden":true,"children":["$","$Lc",null,{"children":["$","$8",null,{"name":"Next.Metadata","children":"$Ld"}]}]}],["$","meta",null,{"name":"next-size-adjust","content":""}]]}],false]],"m":"$undefined","G":["$e",[]],"S":true}
f:I[15579,["/_next/static/chunks/fd0661f1506dcbc6.js","/_next/static/chunks/94245cbda44972fe.js","/_next/static/chunks/af778fff4a0f4be6.js","/_next/static/chunks/b096b037d08e2f31.js"],"Navigation"]
10:I[3013,["/_next/static/chunks/fd0661f1506dcbc6.js","/_next/static/chunks/94245cbda44972fe.js","/_next/static/chunks/af778fff4a0f4be6.js","/_next/static/chunks/b096b037d08e2f31.js"],""]
:HL["/blog/posts/async-sqlite-fastapi/hero.jpg","image"]
:HL["/blog/posts/logo.png","image"]
6:[["$","$Lf",null,{}],["$","main",null,{"className":"pt-20 md:pt-24","children":["$","article",null,{"children":[["$","header",null,{"className":"border-b border-border","children":["$","div",null,{"className":"container mx-auto px-6 py-14 md:py-20","children":[["$","$L10",null,{"href":"/blog","className":"mb-8 inline-flex items-center text-sm font-medium text-muted-foreground transition-colors hover:text-foreground","children":[["$","svg",null,{"ref":"$undefined","xmlns":"http://www.w3.org/2000/svg","width":24,"height":24,"viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeWidth":2,"strokeLinecap":"round","strokeLinejoin":"round","className":"lucide lucide-arrow-left mr-2 h-4 w-4","aria-hidden":"true","children":[["$","path","1l729n",{"d":"m12 19-7-7 7-7"}],["$","path","x3x0zl",{"d":"M19 12H5"}],"$undefined"]}],"Blog"]}],["$","div",null,{"className":"grid gap-8 md:grid-cols-[1fr_0.9fr] md:items-start","children":[["$","div",null,{"className":"max-w-3xl","children":[["$","div",null,{"className":"mb-5 flex flex-wrap items-center gap-3 text-sm text-muted-foreground","children":[["$","span",null,{"className":"rounded-md border border-primary/40 bg-primary/10 px-2.5 py-1 text-primary","children":"Concurrency"}],["$","span",null,{"children":"2026-W20"}],["$","span",null,{"aria-hidden":"true","children":"/"}],["$","span",null,{"children":"4 min read"}],[["$","span",null,{"aria-hidden":"true","children":"/"}],["$","span",null,{"children":["by ",["$","span",null,{"className":"font-medium text-foreground","children":"delve"}]]}]]]}],["$","h1",null,{"className":"text-4xl font-bold leading-tight text-balance md:text-6xl","children":"Blocking SQLite in an Async FastAPI Route"}],["$","p",null,{"className":"mt-6 text-lg leading-relaxed text-muted-foreground md:text-xl","children":"A 2ms SQLite read becomes a 200ms tail latency on every other route. The event loop is the bottleneck, not the database. Anything that touches the filesystem or a socket inside an `async def` body belongs in `run_in_executor`."}]]}],["$","div",null,{"className":"overflow-hidden rounded-lg border border-border bg-card","children":["$","div",null,{"className":"relative aspect-[16/9] overflow-hidden","children":[null,["$","img",null,{"src":"/blog/posts/async-sqlite-fastapi/hero.jpg","alt":"A single brass funnel on a worn wooden workbench with one droplet caught mid-fall above its narrow neck, sharp focus on the droplet, soft side light, no people, editorial.","className":"h-full w-full object-cover"}],["$","img",null,{"src":"/blog/posts/logo.png","alt":"","aria-hidden":"true","className":"pointer-events-none absolute right-4 top-4 h-[50px] w-[50px] mix-blend-screen"}]]}]}]]}]]}]}],["$","div",null,{"className":"container mx-auto px-6 py-12 md:py-16","children":["$","div",null,{"className":"grid gap-10 lg:grid-cols-[minmax(0,1fr)_280px] lg:items-start","children":[["$","div",null,{"className":"max-w-3xl text-muted-foreground","children":[[["$","h2","h2-0",{"className":"mt-12 text-2xl font-semibold leading-snug text-foreground first:mt-0","children":"The problem"}],"\n",["$","p","p-0",{"className":"mt-4 text-base leading-8 md:text-lg first:mt-0 first:text-xl first:leading-relaxed first:text-foreground md:first:text-2xl","children":["You wire up a new FastAPI endpoint that needs to query a SQLite file — a job queue, feature flags, a local cache. The code looks fine: you open a connection, run ",["$","code","code-0",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"fetchone"}],", close it. Benchmarks pass. Then you put it in production and notice that under modest load every other route starts spiking in latency. The SQLite call is 2ms; the tail is 200ms. The database is not the bottleneck — the event loop is."]}],"\n",["$","p","p-1",{"className":"mt-4 text-base leading-8 md:text-lg first:mt-0 first:text-xl first:leading-relaxed first:text-foreground md:first:text-2xl","children":["FastAPI routes are ","$L11"," and run on the uvicorn event loop. The event loop is a single thread. Any synchronous I/O inside an ","$L12"," body — file reads, ","$L13",", blocking sockets — suspends the entire loop for the duration of that call. One slow SQLite read blocks every concurrent request in the process."]}],"\n","$L14","\n","$L15","\n","$L16","\n","$L17","\n","$L18","\n","$L19","\n","$L1a","\n","$L1b"],"$L1c",null]}],"$L1d"]}]}]]}]}],"$L1e"]
8e:I[41451,["/_next/static/chunks/fd0661f1506dcbc6.js","/_next/static/chunks/94245cbda44972fe.js","/_next/static/chunks/af778fff4a0f4be6.js","/_next/static/chunks/b096b037d08e2f31.js"],"Footer"]
11:["$","code","code-0",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"async def"}]
12:["$","code","code-1",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"async def"}]
13:["$","code","code-2",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"sqlite3.connect"}]
14:["$","h2","h2-1",{"className":"mt-12 text-2xl font-semibold leading-snug text-foreground first:mt-0","children":"The approach"}]
15:["$","p","p-2",{"className":"mt-4 text-base leading-8 md:text-lg first:mt-0 first:text-xl first:leading-relaxed first:text-foreground md:first:text-2xl","children":["Python's ",["$","code","code-0",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"asyncio"}]," provides ",["$","code","code-1",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"run_in_executor"}]," for exactly this case. It dispatches a callable to a thread pool and returns an awaitable, giving the event loop back while the blocking call runs on a worker thread."]}]
16:["$","div","pre-0",{"style":{"background":"hsl(220, 13%, 18%)","color":"hsl(220, 14%, 71%)","textShadow":"0 1px rgba(0, 0, 0, 0.3)","fontFamily":"\"Fira Code\", \"Fira Mono\", Menlo, Consolas, \"DejaVu Sans Mono\", monospace","direction":"ltr","textAlign":"left","whiteSpace":"pre","wordSpacing":"normal","wordBreak":"normal","lineHeight":"1.5","MozTabSize":"2","OTabSize":"2","tabSize":"2","WebkitHyphens":"none","MozHyphens":"none","msHyphens":"none","hyphens":"none","padding":"1rem","margin":"0.5em 0","overflow":"auto","borderRadius":"0.5rem","marginTop":"1.25rem","marginBottom":0,"border":"1px solid hsl(var(--border))","fontSize":"0.875rem"},"children":["$","code",null,{"style":{"whiteSpace":"pre","fontFamily":"ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace"},"children":[false,[["$","span","code-segment-0",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["import"]}],["$","span","code-segment-1",{"className":"$undefined","style":{},"children":[" asyncio\n"]}],["$","span","code-segment-2",{"className":"$undefined","style":{},"children":[""]}],["$","span","code-segment-3",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["import"]}],["$","span","code-segment-4",{"className":"$undefined","style":{},"children":[" sqlite3\n"]}],"\n",["$","span","code-segment-6",{"className":"$undefined","style":{},"children":[""]}],["$","span","code-segment-7",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["def"]}],["$","span","code-segment-8",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-9",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["_query_sync"]}],["$","span","code-segment-10",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}],["$","span","code-segment-11",{"className":"$undefined","style":{},"children":["db_path"]}],["$","span","code-segment-12",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[":"]}],["$","span","code-segment-13",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-14",{"className":"token","style":{"color":"hsl(95, 38%, 62%)"},"children":["str"]}],["$","span","code-segment-15",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}],["$","span","code-segment-16",{"className":"$undefined","style":{},"children":[" key"]}],["$","span","code-segment-17",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[":"]}],["$","span","code-segment-18",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-19",{"className":"token","style":{"color":"hsl(95, 38%, 62%)"},"children":["str"]}],["$","span","code-segment-20",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}],["$","span","code-segment-21",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-22",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["-"]}],["$","span","code-segment-23",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":[">"]}],["$","span","code-segment-24",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-25",{"className":"token","style":{"color":"hsl(95, 38%, 62%)"},"children":["str"]}],["$","span","code-segment-26",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-27",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["|"]}],["$","span","code-segment-28",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-29",{"className":"token","style":{"color":"hsl(29, 54%, 61%)"},"children":["None"]}],["$","span","code-segment-30",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[":"]}],["$","span","code-segment-31",{"className":"$undefined","style":{},"children":["\n"]}],["$","span","code-segment-32",{"className":"$undefined","style":{},"children":["    "]}],["$","span","code-segment-33",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["if"]}],["$","span","code-segment-34",{"className":"$undefined","style":{},"children":[" "]}],["$","span","code-segment-35",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["not"]}],["$","span","code-segment-36",{"className":"$undefined","style":{},"children":[" os"]}],["$","span","code-segment-37",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}],["$","span","code-segment-38",{"className":"$undefined","style":{},"children":["path"]}],["$","span","code-segment-39",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}],["$","span","code-segment-40",{"className":"$undefined","style":{},"children":["exists"]}],"$L1f","$L20","$L21","$L22","$L23","$L24","$L25","$L26","$L27","$L28","$L29","$L2a","$L2b","$L2c","$L2d","$L2e","$L2f","$L30","$L31","$L32","$L33","$L34","$L35","$L36","$L37","$L38","$L39","$L3a","$L3b","$L3c","$L3d","$L3e","$L3f","$L40","$L41","$L42","$L43","$L44","$L45","$L46","$L47","$L48","$L49","$L4a","$L4b","$L4c","$L4d","$L4e","$L4f","$L50","$L51","$L52","$L53","$L54","$L55","$L56","$L57","$L58","$L59","$L5a","$L5b","$L5c","$L5d","$L5e","$L5f","\n","$L60","$L61","$L62","$L63","$L64","$L65","$L66","$L67","$L68","$L69","$L6a","$L6b","$L6c","$L6d","$L6e","$L6f","$L70","$L71","$L72","$L73","$L74","$L75","$L76","$L77","$L78","$L79","$L7a","$L7b","$L7c","$L7d","$L7e","$L7f","$L80","$L81","$L82","$L83","$L84","$L85","$L86","$L87","$L88","$L89","$L8a","$L8b","$L8c"]]}]}]
17:["$","p","p-3",{"className":"mt-4 text-base leading-8 md:text-lg first:mt-0 first:text-xl first:leading-relaxed first:text-foreground md:first:text-2xl","children":["The synchronous function runs in the default ",["$","code","code-0",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"ThreadPoolExecutor"}]," (sized to ",["$","code","code-1",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"min(32, cpu_count + 4)"}]," on CPython). The event loop is free the entire time. If you need more control over thread count, pass a custom executor as the first argument instead of ",["$","code","code-2",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"None"}],"."]}]
18:["$","p","p-4",{"className":"mt-4 text-base leading-8 md:text-lg first:mt-0 first:text-xl first:leading-relaxed first:text-foreground md:first:text-2xl","children":["Two things worth noting: first, ",["$","code","code-0",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"get_running_loop()"}]," is the correct call inside an ",["$","code","code-1",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"async def"}]," — ",["$","code","code-2",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"get_event_loop()"}]," is deprecated in 3.10+ and raises a DeprecationWarning in 3.12. Second, the synchronous function must not touch any asyncio primitives; it runs in a thread, not a coroutine, and mixing the two without explicit synchronization is undefined behavior."]}]
19:["$","h2","h2-2",{"className":"mt-12 text-2xl font-semibold leading-snug text-foreground first:mt-0","children":"What I learned"}]
1a:["$","p","p-5",{"className":"mt-4 text-base leading-8 md:text-lg first:mt-0 first:text-xl first:leading-relaxed first:text-foreground md:first:text-2xl","children":["The tell is latency correlation rather than absolute latency. If a short database call causes long-tail spikes in ",["$","em","em-0",{"children":"unrelated"}]," routes, the event loop is blocked, not the database. The fix is always the same shape: extract the blocking code into a plain function, hand it to ",["$","code","code-0",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"run_in_executor"}],", await the result."]}]
1b:["$","p","p-6",{"className":"mt-4 text-base leading-8 md:text-lg first:mt-0 first:text-xl first:leading-relaxed first:text-foreground md:first:text-2xl","children":["SQLite is the quiet offender here because it looks fast. A 1ms read feels negligible, but at 100 req/s you are blocking the loop for 100ms every second — and that compounds with every other blocking call in the same process. The rule is simple: anything that touches the filesystem or a socket inside an ",["$","code","code-0",{"className":"rounded bg-secondary px-1.5 py-0.5 text-[0.9em] text-foreground","children":"async def"}]," body belongs in an executor."]}]
1c:["$","div",null,{"className":"mt-14 border-t border-border pt-8","children":["$","$L10",null,{"href":"/platform","className":"inline-flex items-center text-sm font-medium text-primary transition-colors hover:text-primary/80","children":["Start a build",["$","svg",null,{"ref":"$undefined","xmlns":"http://www.w3.org/2000/svg","width":24,"height":24,"viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeWidth":2,"strokeLinecap":"round","strokeLinejoin":"round","className":"lucide lucide-arrow-right ml-2 h-4 w-4","aria-hidden":"true","children":[["$","path","1ays0h",{"d":"M5 12h14"}],["$","path","xquz4c",{"d":"m12 5 7 7-7 7"}],"$undefined"]}]]}]}]
1d:["$","aside",null,{"className":"hidden lg:block","children":["$","div",null,{"className":"sticky top-24 space-y-4","children":[["$","h3",null,{"className":"text-xs font-semibold uppercase tracking-wider text-primary","children":["More in ","Concurrency"]}],["$","div",null,{"className":"space-y-4","children":[["$","$L10","bcrypt-async-event-loop",{"href":"/blog/bcrypt-async-event-loop","className":"block overflow-hidden rounded-lg border border-border bg-card transition-colors hover:border-primary/40","children":[["$","div",null,{"className":"relative aspect-[16/9] overflow-hidden bg-secondary/70","children":[["$","img",null,{"src":"/blog/posts/bcrypt-async-event-loop/hero.jpg","alt":"A solitary traffic light glowing red over an empty asphalt road at dusk, no cars, no people, sharp editorial photography.","className":"h-full w-full object-cover","loading":"lazy","decoding":"async"}],["$","img",null,{"src":"/blog/posts/logo.png","alt":"","aria-hidden":"true","className":"pointer-events-none absolute right-2 top-2 h-[24px] w-[24px] mix-blend-screen"}]]}],["$","div",null,{"className":"p-4","children":[["$","p",null,{"className":"text-xs font-medium text-primary","children":"Concurrency"}],["$","p",null,{"className":"mt-1 text-xs text-muted-foreground","children":["2026-W20"," · ","4 min"]}],["$","p",null,{"className":"mt-2 line-clamp-2 text-sm font-semibold leading-snug text-foreground","children":"bcrypt in an Async Codebase — The Three Places It Bites You"}]]}]]}],["$","$L10","toctou-async-database-handlers",{"href":"/blog/toctou-async-database-handlers","className":"block overflow-hidden rounded-lg border border-border bg-card transition-colors hover:border-primary/40","children":[["$","div",null,{"className":"relative aspect-[16/9] overflow-hidden bg-secondary/70","children":[["$","img",null,{"src":"/blog/posts/toctou-async-database-handlers/hero.jpg","alt":"A close-up macro shot of two identical brass keys sliding into the same antique brass door lock simultaneously against a dark wooden door, dramatic side lighting, no people, sharp editorial focus.","className":"h-full w-full object-cover","loading":"lazy","decoding":"async"}],["$","img",null,{"src":"/blog/posts/logo.png","alt":"","aria-hidden":"true","className":"pointer-events-none absolute right-2 top-2 h-[24px] w-[24px] mix-blend-screen"}]]}],["$","div",null,{"className":"p-4","children":[["$","p",null,{"className":"text-xs font-medium text-primary","children":"Concurrency"}],["$","p",null,{"className":"mt-1 text-xs text-muted-foreground","children":["2026-W20"," · ","4 min"]}],["$","p",null,{"className":"mt-2 line-clamp-2 text-sm font-semibold leading-snug text-foreground","children":"TOCTOU Races in Async Database Handlers"}]]}]]}],["$","$L10","fire-and-forget-asyncio",{"href":"/blog/fire-and-forget-asyncio","className":"block overflow-hidden rounded-lg border border-border bg-card transition-colors hover:border-primary/40","children":[["$","div",null,{"className":"relative aspect-[16/9] overflow-hidden bg-secondary/70","children":[["$","img",null,{"src":"/blog/posts/fire-and-forget-asyncio/hero.jpg","alt":"A paper airplane mid-flight against a slate-grey wall, sharp focus on the folded nose, no people, no hands, dramatic single-source side light, editorial.","className":"h-full w-full object-cover","loading":"lazy","decoding":"async"}],["$","img",null,{"src":"/blog/posts/logo.png","alt":"","aria-hidden":"true","className":"pointer-events-none absolute right-2 top-2 h-[24px] w-[24px] mix-blend-screen"}]]}],["$","div",null,{"className":"p-4","children":[["$","p",null,{"className":"text-xs font-medium text-primary","children":"Concurrency"}],["$","p",null,{"className":"mt-1 text-xs text-muted-foreground","children":["2026-W20"," · ","5 min"]}],["$","p",null,{"className":"mt-2 line-clamp-2 text-sm font-semibold leading-snug text-foreground","children":"Fire-and-Forget asyncio.create_task Is a Reliability Trap"}]]}]]}]]}],["$","$L10",null,{"href":"/blog?category=concurrency","className":"inline-flex items-center text-sm font-medium text-primary transition-colors hover:text-primary/80","children":["Read all in ","Concurrency","$L8d"]}]]}]}]
1e:["$","$L8e",null,{}]
1f:["$","span","code-segment-41",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
20:["$","span","code-segment-42",{"className":"$undefined","style":{},"children":["db_path"]}]
21:["$","span","code-segment-43",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
22:["$","span","code-segment-44",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[":"]}]
23:["$","span","code-segment-45",{"className":"$undefined","style":{},"children":["\n"]}]
24:["$","span","code-segment-46",{"className":"$undefined","style":{},"children":["        "]}]
25:["$","span","code-segment-47",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["return"]}]
26:["$","span","code-segment-48",{"className":"$undefined","style":{},"children":[" "]}]
27:["$","span","code-segment-49",{"className":"token","style":{"color":"hsl(29, 54%, 61%)"},"children":["None"]}]
28:["$","span","code-segment-50",{"className":"$undefined","style":{},"children":["\n"]}]
29:["$","span","code-segment-51",{"className":"$undefined","style":{},"children":["    "]}]
2a:["$","span","code-segment-52",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["with"]}]
2b:["$","span","code-segment-53",{"className":"$undefined","style":{},"children":[" sqlite3"]}]
2c:["$","span","code-segment-54",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}]
2d:["$","span","code-segment-55",{"className":"$undefined","style":{},"children":["connect"]}]
2e:["$","span","code-segment-56",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
2f:["$","span","code-segment-57",{"className":"$undefined","style":{},"children":["db_path"]}]
30:["$","span","code-segment-58",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}]
31:["$","span","code-segment-59",{"className":"$undefined","style":{},"children":[" timeout"]}]
32:["$","span","code-segment-60",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["="]}]
33:["$","span","code-segment-61",{"className":"token","style":{"color":"hsl(29, 54%, 61%)"},"children":["5"]}]
34:["$","span","code-segment-62",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
35:["$","span","code-segment-63",{"className":"$undefined","style":{},"children":[" "]}]
36:["$","span","code-segment-64",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["as"]}]
37:["$","span","code-segment-65",{"className":"$undefined","style":{},"children":[" con"]}]
38:["$","span","code-segment-66",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[":"]}]
39:["$","span","code-segment-67",{"className":"$undefined","style":{},"children":["\n"]}]
3a:["$","span","code-segment-68",{"className":"$undefined","style":{},"children":["        row "]}]
3b:["$","span","code-segment-69",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["="]}]
3c:["$","span","code-segment-70",{"className":"$undefined","style":{},"children":[" con"]}]
3d:["$","span","code-segment-71",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}]
3e:["$","span","code-segment-72",{"className":"$undefined","style":{},"children":["execute"]}]
3f:["$","span","code-segment-73",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
40:["$","span","code-segment-74",{"className":"$undefined","style":{},"children":["\n"]}]
41:["$","span","code-segment-75",{"className":"$undefined","style":{},"children":["            "]}]
42:["$","span","code-segment-76",{"className":"token","style":{"color":"hsl(95, 38%, 62%)"},"children":["\"SELECT value FROM cache WHERE key = ? LIMIT 1\""]}]
43:["$","span","code-segment-77",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}]
44:["$","span","code-segment-78",{"className":"$undefined","style":{},"children":["\n"]}]
45:["$","span","code-segment-79",{"className":"$undefined","style":{},"children":["            "]}]
46:["$","span","code-segment-80",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
47:["$","span","code-segment-81",{"className":"$undefined","style":{},"children":["key"]}]
48:["$","span","code-segment-82",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}]
49:["$","span","code-segment-83",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
4a:["$","span","code-segment-84",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}]
4b:["$","span","code-segment-85",{"className":"$undefined","style":{},"children":["\n"]}]
4c:["$","span","code-segment-86",{"className":"$undefined","style":{},"children":["        "]}]
4d:["$","span","code-segment-87",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
4e:["$","span","code-segment-88",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}]
4f:["$","span","code-segment-89",{"className":"$undefined","style":{},"children":["fetchone"]}]
50:["$","span","code-segment-90",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
51:["$","span","code-segment-91",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
52:["$","span","code-segment-92",{"className":"$undefined","style":{},"children":["\n"]}]
53:["$","span","code-segment-93",{"className":"$undefined","style":{},"children":["    "]}]
54:["$","span","code-segment-94",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["return"]}]
55:["$","span","code-segment-95",{"className":"$undefined","style":{},"children":[" row"]}]
56:["$","span","code-segment-96",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["["]}]
57:["$","span","code-segment-97",{"className":"token","style":{"color":"hsl(29, 54%, 61%)"},"children":["0"]}]
58:["$","span","code-segment-98",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["]"]}]
59:["$","span","code-segment-99",{"className":"$undefined","style":{},"children":[" "]}]
5a:["$","span","code-segment-100",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["if"]}]
5b:["$","span","code-segment-101",{"className":"$undefined","style":{},"children":[" row "]}]
5c:["$","span","code-segment-102",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["else"]}]
5d:["$","span","code-segment-103",{"className":"$undefined","style":{},"children":[" "]}]
5e:["$","span","code-segment-104",{"className":"token","style":{"color":"hsl(29, 54%, 61%)"},"children":["None"]}]
5f:["$","span","code-segment-105",{"className":"$undefined","style":{},"children":["\n"]}]
60:["$","span","code-segment-107",{"className":"$undefined","style":{},"children":[""]}]
61:["$","span","code-segment-108",{"className":"token decorator annotation","style":{"color":"hsl(220, 14%, 71%)"},"children":["@app"]}]
62:["$","span","code-segment-109",{"className":"token decorator annotation","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}]
63:["$","span","code-segment-110",{"className":"token decorator annotation","style":{"color":"hsl(220, 14%, 71%)"},"children":["post"]}]
64:["$","span","code-segment-111",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
65:["$","span","code-segment-112",{"className":"token","style":{"color":"hsl(95, 38%, 62%)"},"children":["\"/webhook\""]}]
66:["$","span","code-segment-113",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
67:["$","span","code-segment-114",{"className":"$undefined","style":{},"children":["\n"]}]
68:["$","span","code-segment-115",{"className":"$undefined","style":{},"children":[""]}]
69:["$","span","code-segment-116",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["async"]}]
6a:["$","span","code-segment-117",{"className":"$undefined","style":{},"children":[" "]}]
6b:["$","span","code-segment-118",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["def"]}]
6c:["$","span","code-segment-119",{"className":"$undefined","style":{},"children":[" "]}]
6d:["$","span","code-segment-120",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["webhook"]}]
6e:["$","span","code-segment-121",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
6f:["$","span","code-segment-122",{"className":"$undefined","style":{},"children":["request"]}]
70:["$","span","code-segment-123",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[":"]}]
71:["$","span","code-segment-124",{"className":"$undefined","style":{},"children":[" Request"]}]
72:["$","span","code-segment-125",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
73:["$","span","code-segment-126",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[":"]}]
74:["$","span","code-segment-127",{"className":"$undefined","style":{},"children":["\n"]}]
75:["$","span","code-segment-128",{"className":"$undefined","style":{},"children":["    loop "]}]
76:["$","span","code-segment-129",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["="]}]
77:["$","span","code-segment-130",{"className":"$undefined","style":{},"children":[" asyncio"]}]
78:["$","span","code-segment-131",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}]
79:["$","span","code-segment-132",{"className":"$undefined","style":{},"children":["get_running_loop"]}]
7a:["$","span","code-segment-133",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
7b:["$","span","code-segment-134",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
7c:["$","span","code-segment-135",{"className":"$undefined","style":{},"children":["\n"]}]
7d:["$","span","code-segment-136",{"className":"$undefined","style":{},"children":["    value "]}]
7e:["$","span","code-segment-137",{"className":"token","style":{"color":"hsl(207, 82%, 66%)"},"children":["="]}]
7f:["$","span","code-segment-138",{"className":"$undefined","style":{},"children":[" "]}]
80:["$","span","code-segment-139",{"className":"token","style":{"color":"hsl(286, 60%, 67%)"},"children":["await"]}]
81:["$","span","code-segment-140",{"className":"$undefined","style":{},"children":[" loop"]}]
82:["$","span","code-segment-141",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["."]}]
83:["$","span","code-segment-142",{"className":"$undefined","style":{},"children":["run_in_executor"]}]
84:["$","span","code-segment-143",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":["("]}]
85:["$","span","code-segment-144",{"className":"token","style":{"color":"hsl(29, 54%, 61%)"},"children":["None"]}]
86:["$","span","code-segment-145",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}]
87:["$","span","code-segment-146",{"className":"$undefined","style":{},"children":[" _query_sync"]}]
88:["$","span","code-segment-147",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}]
89:["$","span","code-segment-148",{"className":"$undefined","style":{},"children":[" DB_PATH"]}]
8a:["$","span","code-segment-149",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[","]}]
8b:["$","span","code-segment-150",{"className":"$undefined","style":{},"children":[" key"]}]
8c:["$","span","code-segment-151",{"className":"token","style":{"color":"hsl(220, 14%, 71%)"},"children":[")"]}]
8d:["$","svg",null,{"ref":"$undefined","xmlns":"http://www.w3.org/2000/svg","width":24,"height":24,"viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeWidth":2,"strokeLinecap":"round","strokeLinejoin":"round","className":"lucide lucide-arrow-right ml-2 h-4 w-4","aria-hidden":"true","children":[["$","path","1ays0h",{"d":"M5 12h14"}],["$","path","xquz4c",{"d":"m12 5 7 7-7 7"}],"$undefined"]}]
b:[["$","meta","0",{"charSet":"utf-8"}],["$","meta","1",{"name":"viewport","content":"width=device-width, initial-scale=1"}]]
8f:I[94060,["/_next/static/chunks/316a3a63422f35de.js"],"IconMark"]
9:null
d:[["$","title","0",{"children":"Blocking SQLite in an Async FastAPI Route — Bridgestack"}],["$","meta","1",{"name":"description","content":"A 2ms SQLite read becomes a 200ms tail latency on every other route. The event loop is the bottleneck, not the database. Anything that touches the filesystem or a socket inside an `async def` body belongs in `run_in_executor`."}],["$","meta","2",{"name":"generator","content":"v0.app"}],["$","meta","3",{"property":"og:title","content":"Bridgestack — custom software, flat prices from $9.99"}],["$","meta","4",{"property":"og:description","content":"Talk to Tom, your AI PM. A fleet of AI agents builds your product. Flat one-time price. 7 days to test before you pay. Source code is yours."}],["$","meta","5",{"property":"og:url","content":"https://www.bridgestack.systems"}],["$","meta","6",{"property":"og:site_name","content":"Bridgestack"}],["$","meta","7",{"property":"og:locale","content":"en_US"}],["$","meta","8",{"property":"og:image","content":"https://www.bridgestack.systems/bridgestack-landscape-1200x628.png"}],["$","meta","9",{"property":"og:image:width","content":"1200"}],["$","meta","10",{"property":"og:image:height","content":"628"}],["$","meta","11",{"property":"og:type","content":"website"}],["$","meta","12",{"name":"twitter:card","content":"summary_large_image"}],["$","meta","13",{"name":"twitter:title","content":"Bridgestack — custom software, flat prices from $9.99"}],["$","meta","14",{"name":"twitter:description","content":"Talk to Tom, your AI PM. A fleet of AI agents builds your product. 7 days to test before you pay. Source code is yours."}],["$","meta","15",{"name":"twitter:image","content":"https://www.bridgestack.systems/bridgestack-landscape-1200x628.png"}],["$","link","16",{"rel":"icon","href":"/icon-light-32x32.png","media":"(prefers-color-scheme: light)"}],["$","link","17",{"rel":"icon","href":"/icon-dark-32x32.png","media":"(prefers-color-scheme: dark)"}],["$","link","18",{"rel":"icon","href":"/icon.svg","type":"image/svg+xml"}],["$","link","19",{"rel":"apple-touch-icon","href":"/apple-icon.png"}],["$","$L8f","20",{}]]
