jakob / jakob/Postico

Feature request: scripting connection disconnect

Open
#669 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

I sometimes need to drop & recreate a database I like to leave open in Postico. My script hangs while waiting for open connections to close, before timing out and reminding me that I forgot to disconnect Postico. I manually disconnect with the "Connection > Disconnect" menu action (or hotkey), run my script, etc, and then eventually refresh the still-open Postico window to check the results.

I would include the disconnect command at the start of my drop & recreate script to eliminate the human error aspect of my routine.

Any kind of headless API to trigger that would be nice.

Perhaps,

- extend the connection url schemes to allow triggering disconnects
- send a signal to the Postico process
- AppleScript event
- cli utility

"Disconnect all" would be plenty for me, but being able to disconnect a specific host/database/favorite or some fuzzy match combination of that could allow for some more precise uses.

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue names no implementation files or tests. Begin by evaluating the proposed connection-URL, process-signal, AppleScript-event, and CLI entry points; done means a headless command can disconnect all Postico connections before a database script runs.

Written by the indexing model from the issue text.

Assessment

Domain
cli, database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.