Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add reset statement for prepared statements #186

Open
moshegottlieb opened this issue Apr 24, 2019 · 1 comment
Open

Add reset statement for prepared statements #186

moshegottlieb opened this issue Apr 24, 2019 · 1 comment

Comments

@moshegottlieb
Copy link

The way I would normally work with servers is to prepare statements for each connection, and then reuse these statements.
In Kuery, this is not an easy task.
While it is possible to release prepared statements using the Connection protocol, it is not possible to reset those statements and prepare them for reuse.
Imagine the following scenario:

  1. Prepare statement
  2. For each request:
    1. Execute statement
      1. Iterate results
        1. If a certain condition occurs - break

The problem here is that the statement will be left in a transient state, and cannot be reused until it is reset, because not all results were necessarily fetched.
Something like PQclear for posgresql and sqlite3_reset for sqlite.

@kilnerm kilnerm added this to the 2019.09 milestone Apr 24, 2019
@kilnerm kilnerm self-assigned this Apr 24, 2019
@kilnerm kilnerm removed this from the 2019.09 milestone Apr 24, 2019
@kilnerm
Copy link
Contributor

kilnerm commented Apr 24, 2019

This is definitely something we should look to implement.

Moving to backlog for consideration in a future sprint.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants