jakob / jakob/Postico

Opening new tabs is slow over VPN because it reconnects to the server and reloads the list of tables

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

Description

## What did you do?

- Clicked cmd+T to open a new tab.

## What did you expect to happen?

- I expected to quickly open a new tab to see data in a different table in the same database schema.

## What actually happened?

- The app opened a new tab but started from scratch, reconnecting to the same database and reloading all tables from scratch, which took several seconds over VPN.

## What software versions are you using?

Postico version: 2.1 dev
macOS version: 14.1.2
PostgreSQL version: PostgreSQL 9.6.24

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce cmd+T in Postico 2.1 dev against PostgreSQL 9.6.24 over a VPN, then trace the new-tab flow to identify where the existing connection and table list are discarded. Done means opening a tab for another table in the same schema without reconnecting or reloading the table list.

Written by the indexing model from the issue text.

Assessment

Tech stack
macos, postgresql, python
Domain
databases, desktop, networking
Issue type
Bug
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.