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.
Tag: Visualization
-
AWS & Aliyun Server Pricing
Overview Historical source note: the advertised pigsty-app/cloud directory was not present in the last immutable app repository snapshot before v2.7.0; the SQL and recovered images below come from the frozen documentation repository. Online Demo: …
Overview Historical source note: the advertised pigsty-app/cloud directory was not present in the last immutable app repository snapshot before v2.7.0; the SQL and recovered images below come from the frozen documentation repository. Online Demo: …
-
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) …
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) …
-
Solve the 24-Point Card Game with One SQL Statement
Problem The challenge is described in Database Programming Contest: Calculate 24 with One SQL Statement. A cards table has an auto-incrementing id and four columns, c1 through c4; each card is a random integer from 1 to 10. One SQL statement must …
Problem The challenge is described in Database Programming Contest: Calculate 24 with One SQL Statement. A cards table has an auto-incrementing id and four columns, c1 through c4; each card is a random integer from 1 to 10. One SQL statement must …
-
DB-Engines Database Popularity Trend Analysis
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/db-engine
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/db-engine
-
StackOverflow Global Developer Survey
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/sf-survey
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/sf-survey
-
Analyse CSVLOG Sample with the built-in PGLOG
PGLOG is a sample application included with Pigsty that uses the pglog.sample table in MetaDB as the data source. Simply populate this table with logs and access the corresponding Dashboard. Pigsty provides some handy commands to fetch CSV logs and …
PGLOG is a sample application included with Pigsty that uses the pglog.sample table in MetaDB as the data source. Simply populate this table with logs and access the corresponding Dashboard. Pigsty provides some handy commands to fetch CSV logs and …
-
WHO COVID-19 Data Analysis
The on-line demo：https://demo.pigsty.cc/d/covid-overview Installation 在管理节点上进入应用目录，执行make以完成安装。 make # 如果本地数据可用 make all # 完整安装，从WHO官网下载数据 makd reload # 重新下载并加载最新数据 其他一些子任务： make reload # download latest data and pour it again make ui # install …
The on-line demo：https://demo.pigsty.cc/d/covid-overview Installation 在管理节点上进入应用目录，执行make以完成安装。 make # 如果本地数据可用 make all # 完整安装，从WHO官网下载数据 makd reload # 重新下载并加载最新数据 其他一些子任务： make reload # download latest data and pour it again make ui # install …
-
NOAA ISD Station
Including 30000 meteorology station, daily, sub-hourly observation records, from 1900-2023. https://github.com/Vonng/isd It is recommended to use with Pigsty, the battery-included PostgreSQL distribution with Grafana & echarts for visualization. It …
Including 30000 meteorology station, daily, sub-hourly observation records, from 1900-2023. https://github.com/Vonng/isd It is recommended to use with Pigsty, the battery-included PostgreSQL distribution with Grafana & echarts for visualization. It …