Server dashboard for Linux connections

Ouverte
  • Quelque chose ne va pas ?
#3,657 0 commentaires 0 réactions 0 personnes assignées Voir sur GitHub

Les mainteneurs répondent en général sous 1 jour

Personne n'a encore pris cette issue.

Évaluation

Difficulté
5/5
Temps estimé
Plus d'une semaine
Accessibilité débutants
25/100
Type d'issue
Fonctionnalité
Clarté
Plutôt claire
Activité
Active
Stack technique
clickhouse, mariadb, mysql, postgresql, swift
Domaine
database, desktop

Piste de recherche

Read linux/ROADMAP.md and the macOS reference features/server-dashboard.mdx first. The issue leaves the roadmap decision open; if the feature is accepted, inspect how Linux network connections and database-specific catalog queries are handled. Done means PostgreSQL shows running queries and blocker relationships, and can cancel a query after confirmation.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Description

enhancement platform-linux
Problem

The Linux app shows nothing about what the server is doing: no sessions, no running queries, no locks. linux/ROADMAP.md, Backlog, Ideas lists "server monitoring (sessions, locks, slow queries)" as not committed. The macOS app has a server dashboard (features/server-dashboard.mdx).

When a query hangs or a table is locked, the user has to know each engine's catalog and type the query: pg_stat_activity on PostgreSQL, SHOW PROCESSLIST on MySQL and MariaDB, sys.dm_exec_requests on SQL Server, system.processes on ClickHouse.

Proposed solution
  • Decide whether it moves from Ideas into the backlog, and record it in linux/ROADMAP.md.
  • If yes, a Server tab per network connection, refreshed every few seconds while it is in front and paused otherwise:
    • sessions, with user, client address, database and state;
    • running queries, with their text and how long they have run, longest first;
    • locks and which session blocks which, where the engine reports it;
    • server version and uptime.
  • Cancel Query and End Session on a row, each asking first and refused on a read-only connection.
  • A panel the login cannot read says so instead of showing an empty list, for example pg_stat_activity without pg_read_all_stats showing only the user's own sessions.
  • Not offered for SQLite, which has no server.

Done means: on PostgreSQL, the tab lists the running queries, shows a blocked session and its blocker, and cancels one query after asking.

Alternatives considered

Query the engine's own catalog views from the editor.

Platform

Linux

Related database type

N/A / General

Langage dominant
Swift
Étoiles
6.2k
Forks
412
Merge moyen
3 h 56 min
PR mergées (30 j)
669

Préparer son environnement

Ce projet ne fournit ni conteneur de développement, ni Dockerfile, ni guide de contribution : l'installation est à votre charge. Commencez par son README, et consultez notre guide de la première contribution pour les étapes générales.

Par où commencer

  1. Lisez l'issue en entier, puis le guide de contribution du projet.
  2. Signalez en commentaire que vous la prenez — cela évite que deux personnes fassent le même travail.
  3. Forkez le dépôt et travaillez sur une branche.
  4. Ouvrez une pull request qui référence le numéro de l'issue.

Autres issues de TableProApp/TablePro

Toutes les issues de TableProApp/TablePro

Issues similaires

Plus d'issues Swift

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.