July 20th, 2024

PEV2: PostgreSQL Execution Plan Visualizer

The PEV2 VueJS component visualizes PostgreSQL execution plans interactively. Users access it via Dalibo service, GitHub download, or web integration. PEV2 is a revamped version of pev by Alex Tatiyants.

Read original articleLink Icon
PEV2: PostgreSQL Execution Plan Visualizer

The PEV2 VueJS component is designed to display a graphical representation of a PostgreSQL execution plan. Users can utilize the explain visualizer through various methods: accessing the Dalibo service at explain.dalibo.com, downloading the index.html file from GitHub for local use, or integrating it into a web application either with or without build tools. PEV2 is a reimagining of the Postgres Explain Visualizer (pev) project originally created by Alex Tatiyants, which has not seen recent updates for over three years. A live demo of PEV2 is available at dalibo.github.io/pev2. The tool aims to provide users with an interactive and informative way to visualize PostgreSQL execution plans.

Related

Yacv (Yet Another Compiler Visualizer): LL and LR Parser Animations

Yacv (Yet Another Compiler Visualizer): LL and LR Parser Animations

The "Yet Another Compiler Visualizer" (yacv) tool enhances understanding of LL(1) and LR parsers through syntax tree, LR automaton, parsing table visualization, and step-by-step parsing using Manim. Detailed installation and usage guidance available.

Show HN: Embedded our open-source charting lib into a no-code storytelling tool

Show HN: Embedded our open-source charting lib into a no-code storytelling tool

Vizzu is a cinematic data visualization tool that transforms data into animated presentations, enhancing data analysis with smart suggestions, animated transitions, and time-saving features. Users praise its effectiveness in conveying messages and facilitating interactive data storytelling.

We need visual programming. No, not like that

We need visual programming. No, not like that

Visual programming environments struggle due to mismatched focus on syntax. Developers prefer visualizing state transitions and code aspects. Tools like Sourcetrail aid in understanding code complexity, suggesting more visualizations for improved software comprehension and optimization.

Visual programming should start in the debugger

Visual programming should start in the debugger

Visual programming leverages visual-spatial reasoning, proposing enhanced debuggers to visualize data structures over time. Efforts prioritize debugger improvements over text editors to create a new visual programming approach.

New Gaussian Splatting viewer that allows code modification during runtime

New Gaussian Splatting viewer that allows code modification during runtime

The GitHub project "splatviz" offers an interactive viewer for 3D Gaussian Splatting scenes. It uses Python GUI library (imgui) for real-time editing and visualization, supporting scene saving and video creation. Users can clone the repository for exploration.

Link Icon 4 comments
By @justinclift - 9 months
The repo README really needs a screenshot so people immediately have an idea of whether it's worth investigating further / potentially trying out. :)
By @carderne - 9 months
Find this pretty useful for understanding query plans. There are some sample plans on their website:

https://explain.dalibo.com/