41084580996
95%

Ran 30 Oct 2026 03:52PM UTC

Jobs 36

Files 163

Run time 1min

Badge

Embed ▾

Committed 30 Oct 2026 03:51PM UTC coverage: 95.129% (+0.02%) from 95.108%

Build # 41084580996

Build Type

push

github

Committed by

web-flow

Commit Message

perf(postgrest): speed up JSON parsing by 22x using json.loads (#1571)

## Summary
Resolves #1486 by replacing the slow `JSONAdapter.validate_json` call in
`base_request_builder.py` with the standard library `json.loads`.

   ## Context
The current `JSONAdapter` (a Pydantic `TypeAdapter` over the `JSON` type
alias) performs redundant runtime validation. Because standard JSON
parsing already guarantees the output matches the `Union[None, bool,
str, int, float, Sequence[JSON], Mapping[str, JSON]]` schema, we can
safely skip the Pydantic validation pass entirely.

This matches the exact, proven pattern already used successfully by
`SingleAPIResponse.from_http_request_response` in the exact same file.

   ## Benchmarks
   As reported in #1486 and verified by community members:
   - **Before (JSONAdapter):** ~43ms
   - **After (json.loads):** ~1.9ms
This represents a **~22x speedup** for large payloads, requires zero new
dependencies, and maintains exact backward compatibility.

   ## Changes
1. Removed `ValidationError` from Pydantic imports as it is no longer
used.
   2. Removed unused `JSONAdapter` import.
3. Switched `APIResponse.from_http_request_response` to use `json.loads`
+ `JSONDecodeError` fallback.

---------

Co-authored-by: Lukas Klingsbo <lukas.klingsbo@gmail.com>

Coverage Stats

11953 of 12565 relevant lines covered (95.13%)

5.84 hits per line

Coverage Regressions

Lines	Coverage	∆	File
15	94.67	0.59%	src/postgrest/base_request_builder.py

Jobs

ID	Job ID	Ran	Files	Coverage
1	run-ubuntu-latest-3.9-storage - 41084580996.1	30 Oct 2026 03:53PM UTC	40	94.81	GitHub Action Run
2	run-ubuntu-latest-3.12-postgrest - 41084580996.2	30 Oct 2026 03:53PM UTC	38	97.19	GitHub Action Run
3	run-ubuntu-latest-3.13-supabase - 41084580996.3	30 Oct 2026 03:52PM UTC	20	96.67	GitHub Action Run
4	run-ubuntu-latest-3.14-auth - 41084580996.4	30 Oct 2026 03:52PM UTC	54	93.47	GitHub Action Run
5	run-ubuntu-latest-3.9-auth - 41084580996.5	30 Oct 2026 03:52PM UTC	54	93.39	GitHub Action Run
6	run-ubuntu-latest-3.12-functions - 41084580996.6	30 Oct 2026 03:51PM UTC	18	97.32	GitHub Action Run
7	run-ubuntu-latest-3.9-postgrest - 41084580996.7	30 Oct 2026 03:53PM UTC	38	97.25	GitHub Action Run
8	run-ubuntu-latest-3.11-realtime - 41084580996.8	30 Oct 2026 03:53PM UTC	17	88.39	GitHub Action Run
9	run-ubuntu-latest-3.13-realtime - 41084580996.9	30 Oct 2026 03:53PM UTC	17	88.39	GitHub Action Run
10	run-ubuntu-latest-3.9-supabase - 41084580996.10	30 Oct 2026 03:52PM UTC	20	96.6	GitHub Action Run
11	run-ubuntu-latest-3.12-auth - 41084580996.11	30 Oct 2026 03:52PM UTC	54	93.45	GitHub Action Run
12	run-ubuntu-latest-3.11-storage - 41084580996.12	30 Oct 2026 03:53PM UTC	40	94.74	GitHub Action Run
13	run-ubuntu-latest-3.10-supabase - 41084580996.13	30 Oct 2026 03:52PM UTC	20	96.67	GitHub Action Run
14	run-ubuntu-latest-3.13-storage - 41084580996.14	30 Oct 2026 03:53PM UTC	40	94.74	GitHub Action Run
15	run-ubuntu-latest-3.14-realtime - 41084580996.15	30 Oct 2026 03:53PM UTC	17	87.53	GitHub Action Run
16	run-ubuntu-latest-3.11-functions - 41084580996.16	30 Oct 2026 03:52PM UTC	18	97.32	GitHub Action Run
17	run-ubuntu-latest-3.11-postgrest - 41084580996.17	30 Oct 2026 03:53PM UTC	38	97.19	GitHub Action Run
18	run-ubuntu-latest-3.11-supabase - 41084580996.18	30 Oct 2026 03:52PM UTC	20	96.67	GitHub Action Run
19	run-ubuntu-latest-3.10-postgrest - 41084580996.19	30 Oct 2026 03:53PM UTC	38	97.19	GitHub Action Run
20	run-ubuntu-latest-3.10-realtime - 41084580996.20	30 Oct 2026 03:53PM UTC	17	88.39	GitHub Action Run
21	run-ubuntu-latest-3.9-functions - 41084580996.21	30 Oct 2026 03:52PM UTC	18	97.53	GitHub Action Run
22	run-ubuntu-latest-3.13-functions - 41084580996.22	30 Oct 2026 03:52PM UTC	18	97.32	GitHub Action Run
23	run-ubuntu-latest-3.12-realtime - 41084580996.23	30 Oct 2026 03:53PM UTC	17	88.39	GitHub Action Run
24	run-ubuntu-latest-3.14-storage - 41084580996.24	30 Oct 2026 03:53PM UTC	40	94.73	GitHub Action Run
25	run-ubuntu-latest-3.14-functions - 41084580996.25	30 Oct 2026 03:51PM UTC	18	97.32	GitHub Action Run
26	run-ubuntu-latest-3.12-supabase - 41084580996.26	30 Oct 2026 03:52PM UTC	20	96.67	GitHub Action Run
27	run-ubuntu-latest-3.10-storage - 41084580996.27	30 Oct 2026 03:53PM UTC	40	94.74	GitHub Action Run
28	run-ubuntu-latest-3.14-supabase - 41084580996.28	30 Oct 2026 03:52PM UTC	20	96.65	GitHub Action Run
29	run-ubuntu-latest-3.10-functions - 41084580996.29	30 Oct 2026 03:52PM UTC	18	97.32	GitHub Action Run
30	run-ubuntu-latest-3.11-auth - 41084580996.30	30 Oct 2026 03:52PM UTC	54	93.49	GitHub Action Run
31	run-ubuntu-latest-3.13-auth - 41084580996.31	30 Oct 2026 03:52PM UTC	54	93.49	GitHub Action Run
32	run-ubuntu-latest-3.9-realtime - 41084580996.32	30 Oct 2026 03:53PM UTC	17	88.49	GitHub Action Run
33	run-ubuntu-latest-3.12-storage - 41084580996.33	30 Oct 2026 03:53PM UTC	40	94.74	GitHub Action Run
34	run-ubuntu-latest-3.10-auth - 41084580996.34	30 Oct 2026 03:52PM UTC	54	93.45	GitHub Action Run
35	run-ubuntu-latest-3.13-postgrest - 41084580996.35	30 Oct 2026 03:53PM UTC	38	97.19	GitHub Action Run
36	run-ubuntu-latest-3.14-postgrest - 41084580996.36	30 Oct 2026 03:53PM UTC	38	97.18	GitHub Action Run

supabase / supabase-py / 41084580996
95%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 41084580996

supabase / supabase-py / 41084580996 95%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 41084580996

supabase / supabase-py / 41084580996
95%

README BADGES
x