How realzachi/pg-jev works
jev is a PostgreSQL extension for filtering, ranking, and classifying table rows with plain-language questions. A SQL query invokes its functions; on a cache miss, jev reads rows ahead, batches questions, and sends requests to a Jev-compatible API. Returned probabilities support boolean predicates, ranking, and choice classification, and answers are cached per backend session. The README documents this runtime flow and configuration, but no implementation excerpts were supplied, so the graph uses the extension SQL path and cites only documented relationships.
Main entry points: jev--0.2.1.sql Answer cache
Components 14
SQL interface
- jev predicate
sql/jev--0.2.1.sql - jev probability
sql/jev--0.2.1.sql - jev choice
sql/jev--0.2.1.sql - jev score
sql/jev--0.2.1.sql
Row evaluation
- Row read-ahead
sql/jev--0.2.1.sql - Question batching
sql/jev--0.2.1.sql - Row probabilities
sql/jev--0.2.1.sql
API connections
- HTTPS connection pool
sql/jev--0.2.1.sql - Runtime settings
sql/jev--0.2.1.sql
Session state
- Answer cache
sql/jev--0.2.1.sql - Cache clear
sql/jev--0.2.1.sql
Other components
- SQL query
- PostgreSQL
- Jev-compatible API
Connections 18
- SQL query → PostgreSQL: submits query
README.md - PostgreSQL → jev predicate: invokes
README.md - PostgreSQL → jev probability: invokes
README.md - PostgreSQL → jev choice: invokes
README.md - PostgreSQL → jev score: invokes
README.md - jev predicate → Row read-ahead: starts on miss
README.md - Row read-ahead → Question batching: supplies rows
README.md - Question batching → HTTPS connection pool: dispatches requests
README.md - HTTPS connection pool → Jev-compatible API: sends HTTPS
README.md - Jev-compatible API → Row probabilities: returns answers
README.md - Row probabilities → Answer cache: caches answers
README.md - Answer cache → jev predicate: serves cached answers
README.md - Answer cache → jev probability: serves cached answers
README.md - Answer cache → jev choice: serves cached answers
- Answer cache → jev score: serves cached answers
- Cache clear → Answer cache: clears
README.md - Runtime settings → HTTPS connection pool: configures
- Runtime settings → Jev-compatible API: selects endpoint
README.md