# Visualization Applet

> Run data analysis & visualization, data app demo with Pigsty
---

[![pigsty-app.jpg](/img/pigsty/app.jpg)](https://github.com/Vonng/pigsty/tree/v2.7.0/app)

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 `ui` directory
- **Data Definitions (PostgreSQL DDL Files)** located in the `sql` directory
- **Data Files (various resources that need to be downloaded)** located in the `data` directory
- **Logic Scripts (scripts for executing various logic)** located in the `bin` directory

Pigsty comes with several sample applications by default:

- [`pglog`](/docs/applet/pglog): Analyzes PostgreSQL CSV log samples.
- [`covid`](/docs/applet/covid): Visualizes WHO COVID-19 data and allows you to check pandemic data by country.
- [`isd`](/docs/applet/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**](/docs/node/#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.

---

Section pages:

- [Analyse CSVLOG Sample with the built-in PGLOG](/docs/applet/pglog/): Analyse CSVLOG Sample with the built-in PGLOG
- [NOAA ISD Station](/docs/applet/isd/): Fetch, Parse, Analyze, and Visualize Integrated Surface Weather Station Dataset
- [WHO COVID-19 Data Analysis](/docs/applet/covid/): Pigsty built-in application which visualize WHO covid-19 data
- [Solve the 24-Point Card Game with One SQL Statement](/docs/applet/poker24/): A PostgreSQL solution that returns one expression for the 24-point card game using a single SQL statement.
- [StackOverflow Global Developer Survey](/docs/applet/sf-survey/): Analyze database-related data from StackOverflow's global developer survey over the past seven years
- [DB-Engines Database Popularity Trend Analysis](/docs/applet/db-engine/): Analyze database management systems on DB-Engines and browse their popularity evolution
- [AWS & Aliyun Server Pricing](/docs/applet/cloud/): Analyze compute and storage pricing on Aliyun / AWS (ECS/ESSD)