jakob / jakob/Postico

Save results for last X queries into a memory buffer to revisit without re-querying

Open
#216 2 comments 2 reactions 0 assignees View on GitHub
enhancement
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Some implementation of tracking the last X queries is already implemented.

For each of those queries, you could save the results as a .csv into a .folder, and circularly replace them when the X-sized buffer is at its end.

This way if you ran a 120 second query, followed by a 5 second query, I could revisit the results of the 120 second query without re-executing it.

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are named. Start by locating the existing implementation that tracks recent queries, then determine how query results are represented and stored. Done means retaining results for the last X queries in CSV files, replacing the oldest entry circularly, and allowing an earlier result to be revisited without re-querying.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.