JevMade Sign in
← Back to guides

JevMade field notes / Technical guide

Ask Jev about selected PostgreSQL records

jevql keeps exact database filtering in PostgreSQL, then asks Jev about selected records outside the database. A preview shows the planned work before any request is sent.

Original by kylemclarenRetrieval

Listen to this guide

JevMade’s plain-English explanation

0:00 /

Our summary

PostgreSQL stores organized records and can filter them using exact conditions. jevql adds questions about meaning without making the database itself perform every model call. A separate tool collects selected records, asks Jev about them, and attaches the answers for later filtering or sorting.

The guide describes collecting records, arranging their fields consistently, and checking groups while saving reusable answers. Before sending anything, a preview shows the database request, record and group counts, approximate text volume, and estimated cost. This makes unexpectedly large jobs easier to spot.

The first version supports only some read-only database requests and stops when important details are unclear or change. Sorting by meaning may still require checking every candidate record. Set limits on records and text, and remember that selected database contents go to an outside service.

Key takeaways

  1. Apply exact database filters before asking about meaning.
  2. Limit records and text so oversized jobs stop.
  3. Inspect unsupported requests instead of accepting a guessed interpretation.

The guide describes the documented command-line behavior.

GitHub README

Read the original guide Opens the author’s site in a new tab.

Keep this for later

Sign in to bookmark experiments, guides and videos, and keep notes only you can see.

Continue to sign in

We’ll bring you back to this listing.