Feature request: scripting connection disconnect
- 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