Skip to content
master
Go to file
Code

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
Sep 16, 2020

README.md

pgtools

Application for debugging applications that use postgres as DBMS. The application aims to help the user to understand his application by displaying the database events triggered by the application in real time.

General

Application built with python3 (server-side) and vue.js (client-side). The sub-projects for front- and backend can be found in the respective folders.

Note

The application uses postgres trigger and trigger functions to intercept the database events and to forward them via pg_notify. For this reason, before using the application, you should check whether the used names of the trigger or trigger functions interfer with your existing ones. Names used for

  • triggers: notify_trigger
  • trigger functions: notify_event

In addition, the application should only be used for development or debugging purposes, as the application has not yet been tested with high loads.

The application is currently under development. If you find bugs or have suggestions, don't hesitate and create an issue or create a pull request.

Screenshots

Connection Manager

In the connection manager you can manage your connections. This includes the creation, activation, deactivation and deletion of said connections. Via the green play button you can activate connections to spectate them. You will only see the events of the active databases. Via the pause button you can stop listening to the database events of the connections. Connections Create connection

Trigger

In the trigger tab you can switch between all active connections in the upper right corner. In this view you can choose which tables in the database should throw events. If you want to watch the whole database you can check all connections. Detail view

Watcher - Event View

The event view shows the database events with information about time, type, database, table and the dataId. Every time an event is thrown it will appear on top of the table. In this view you can filter by database, table and dataId. In order to get to the detailed view, at least the database and the table must be selected. The detail view can be activated/deactivated by the toggle button in the upper right corner. Event view

Watcher - Detail View

The detail view shows all data of the changed entity. If specific fields changed these changes are highlighted red. Detail view

About

Gui application to monitor postgres database events in real time

Topics

Resources

License

Packages

No packages published
You can’t perform that action at this time.