Gist 0c7905cc49971a9f3b6c86550eb67a35

100%

Gist 0c7905cc49971a9f3b6c86550eb67a35

✓ Published0🌍 Public

Last edited Apr 7, 2021

Created on Apr 7, 2021

This example shows how to set up a PostgreSQL database named `hubs` and configure it for use with the Polycosm platform, storing configuration results in `/hab/svc/ita/files/stack-configs.json`. The visualization relies on shell scripting to automate database creation and user authorization, using commands like `createuser`, `createdb`, and `psql` to manage roles and passwords. It also includes a link to a video demonstration, while the code itself focuses on backend infrastructure rather than graphical rendering, making no use of visualization libraries such as D3 or Three.js.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist ec3b35b83d07ef1d37a4af819723842b

This example demonstrates how to set up a PostgreSQL foreign data wrapper for staging data access. It shows the process of creating a foreign server, mapping users, and importing an external schema into a local staging schema. The code uses the `postgres_fdw` extension, along with SQL commands such as `CREATE SERVER`, `CREATE USER MAPPING`, and `IMPORT FOREIGN SCHEMA`. It also includes a commented example of querying imported tables, like selecting from `staging.users` to create a local table. The approach relies on PostgreSQL’s FDW API to connect to a remote database and expose its tables locally.

XXXX

59% match

Loading thumbnail…

Gist 4a460749f5f2d01019812d536ed42648

This example showcases a set of PostgreSQL client configuration settings designed to format query output for readability and analysis. It defines a custom prompt, enables timing information, sets unicode and wrapped table borders, and activates expanded display for wide results. A slow-query log pulls the top 100 queries by total time from the `pg_stat_statements` view, calculating average execution time per call. The configuration relies on standard `psql` meta-commands like `\pset`, `\set`, and `\x`, with no external visualization libraries involved.

XXXX

58% match

Loading thumbnail…

Gist 38a5a981b671bf09a7b9e76eeebc2294

This example visualizes a system-administration script that automates the setup of an Ambari-managed Hadoop cluster. The code shows a sequence of shell commands and configuration steps, including disabling SELinux and iptables, installing Java and MySQL, and configuring databases and users. It uses the `awk` utility to edit `sshd_config` and the `mysql` command-line client to create and grant privileges on the `ambaridb`, `hivedb`, and `ooziedb` databases. The visualization maps the script’s control flow and dependencies, likely through a node-link diagram, to illustrate how each step builds on prior ones.

FFred-Fan

58% match

Loading thumbnail…

Gist 0c701eddfaa4b93ee172

Two terminal sessions show failed attempts to import OpenStreetMap data into a PostgreSQL database using Osmosis, a Java command-line tool. The visualization captures log output from sequential runs of the `osmosis` command, displaying errors from Java's `java.net.ConnectException` when the database connection is refused. The first attempt fails because the `--truncate-pgsql` task receives an unexpected `port` argument, while the second fails because PostgreSQL is not running. The display highlights the pipeline's reliance on database configuration and connection handling, rendered as plain terminal text.

CCaged

58% match

Loading thumbnail…

PostgreSQL command line cheatsheet

This example presents a text-based cheat sheet for PostgreSQL command-line tools, rendering a curated list of psql commands, configuration snippets, and handy SQL queries in a plain markdown document. It shows the core syntax for database management tasks, such as connecting to databases, listing tables and views, managing user roles, and adjusting server logging verbosity, alongside query examples for inspecting indexes, active sessions, and table sizes. The visualization relies on static code blocks and inline formatting, with no interactive graphics or JavaScript libraries; instead, it leverages the raw text content from a gist, emphasizing practical API references like `psql` meta-commands and `pg_stat_activity` queries.

AAngieLiang

57% match

Loading thumbnail…

Gist 5bcd3b7a6ccdbf67fc2cf7e8683ef7b7

This visualization shows the deployment steps of a cloud-init configuration for setting up a Hetzner server with Docker services. It maps the sequence of shell commands, package installations, and Docker Compose operations that migrate existing web applications (Peertube, Jitsi, Dockprom) from a remote source. The code demonstrates Docker CLI usage, docker-compose for service orchestration, and SSH key management for automated transfers. The visualization likely uses a flowchart or timeline representation to display the command order, with plain text annotations highlighting long-running steps and networking setup like custom bridge networks.

UUtopiah

57% match

Loading thumbnail…

Gist db569066a21ec6afce10f185d9c1f60b

This example demonstrates a text-based bot connecting to a Mozilla Hubs room, logging presence updates and chat messages, and sending a greeting after a delay. It uses the ReticulumClient and HubState classes from the Hubs Discord Bot libraries to establish a Phoenix channel connection, while HubStats and PresenceRollups track room occupancy over time. The bot reads configuration from dotenv files and logs timestamped events to the console, showing real-time hub activity without any visual rendering.

UUtopiah

56% match

Loading thumbnail…

PostgreSQL installation tutorial

This example presents a step-by-step guide for installing PostgreSQL across macOS, Linux, and Windows. It shows the terminal command `psql -U postgres` as the target for verifying a successful setup, then details OS-specific actions, such as using the Postgres.app on macOS, compiling from source via `wget` on Linux, and using the EnterpriseDB installer on Windows. The tutorial also covers checking the `$PATH` variable and verifying the server port with `lsof`.

115Dkatz

56% match