Add support for closing a database (session)

Open
#13 15 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
25/100
Issue type
Feature
Clarity
Needs clarification
Activity status
Stale
Tech stack
cpp, postgresql
Domain
api, databases

Research direction

Start with the Apache Arrow Flight SQL format page and the linked mailing-list thread to determine the status of a standard session-close mechanism. The issue names no source files or tests; done would require an agreed interoperable approach and a concrete implementation scope for this PostgreSQL adapter.

Written by the indexing model from the issue text.

Description

It seems that Apache Arrow Flight SQL doesn't provide a command that closes the current session explicitly:
https://arrow.apache.org/docs/format/FlightSql.html

In https://lists.apache.org/thread/0w25o85y8vsndz87kpjljxz24x077o3y , using a custom (close) action was suggested.

@lidavidm Is using a custom close action still a suggested approach to close the current session? I have a concern about this approach. If each Apache Arrow Flight SQL server implementation uses different custom close action, users can't use a general Apache Arrow Flight SQL client including ADBC to use Apache Arrow Flight SQL servers. (Users need to implement a custom close action for each Apache Arrow Flight SQL server.)

Dominant language
C++
Stars
116
Forks
10
PR merge metrics
No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from apache/arrow-flight-sql-postgresql

All issues in apache/arrow-flight-sql-postgresql

Similar issues

More C++ issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.