jsonb_slice

PostgreSQL extension research

One field.
Clear semantics.

Version 0.5.0 can route built-in JSONB accessors through the extension in supported plan expressions. External, uncompressed values can use TOAST slices.

0.5.0 transparent path

  1. 01PlanKeep PostgreSQL's selected plan
  2. 02CheckValidate relation and function safety
  3. 03RouteUse the matching extension accessor
  4. 04ReadSlice or use the complete-value fallback

01 / Current release

Version 0.5.0 adds optional transparent access.

The mode is off by default. Supported built-in accessor expressions can use jsonb_slice without changing the SQL text. Other expressions keep PostgreSQL's built-in functions.

02 / Versions

Documentation by version.

Published documentation stays at its versioned address.

0.1.0

Install the project shell

This release creates the extension identity and documents the problem, repository structure, and test boundary.

Read docs
0.2.0

Add the first JSONB accessor

This release reads one top-level object field after PostgreSQL detoasts the complete JSONB value.

Read docs
0.3.0

Read selected JSONB data through TOAST slices

This release reads the root directory, object keys, and selected value through TOAST slices when the input is external and uncompressed.

Read docs
0.4.0

Add JSONB accessors and operators

This release adds key, index, and path accessors with JSONB and text results. It also adds matching operators.

Read docs
0.5.0

Add optional transparent access

This release can route built-in JSONB accessors through jsonb_slice in supported plan expressions when transparent mode is enabled.

Read docs

03 / Boundary

An experiment, not a production promise.

Version 0.5.0 checks requested slice sizes in selected regression fixtures. The release makes no general performance claim.