Version v2.7.0 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.
Visualization Applet
An Applet is a self-contained, data-driven mini-application that runs within the Pigsty infrastructure.
A typical Pigsty application includes at least one or all of the following components:
- Graphical Interface (Grafana Dashboard definitions) located in the
uidirectory - Data Definitions (PostgreSQL DDL Files) located in the
sqldirectory - Data Files (various resources that need to be downloaded) located in the
datadirectory - Logic Scripts (scripts for executing various logic) located in the
bindirectory
Pigsty comes with several sample applications by default:
pglog: Analyzes PostgreSQL CSV log samples.covid: Visualizes WHO COVID-19 data and allows you to check pandemic data by country.isd: NOAA ISD, which provides access to meteorological observation records from 30,000 surface weather stations worldwide since 1901.
Structure
A Pigsty applet provides an installation script in its root directory: install or a related shortcut. You need to run this script as an admin user on the admin node to execute the installation. The installation script will detect the current environment (fetching METADB_URL, PIGSTY_HOME, GRAFANA_ENDPOINT, etc.) to complete the installation.
Typically, dashboards with the APP tag will be listed in the Pigsty Grafana homepage navigation under the Apps dropdown menu, and dashboards with both APP and OVERVIEW tags will be listed in the homepage panel navigation.
Analyse CSVLOG Sample with the built-in PGLOG
Fetch, Parse, Analyze, and Visualize Integrated Surface Weather Station Dataset
Pigsty built-in application which visualize WHO covid-19 data
A PostgreSQL solution that returns one expression for the 24-point card game using a single SQL statement.
Analyze database-related data from StackOverflow’s global developer survey over the past seven years
Analyze database management systems on DB-Engines and browse their popularity evolution
Analyze compute and storage pricing on Aliyun / AWS (ECS/ESSD)
