Add chartdb (ct)

ct/chartdb.sh

@@ -0,0 +1,64 @@
+#!/usr/bin/env bash
+_cs_boot="${COMMUNITY_SCRIPTS_CORE_DIR:-$(dirname "${BASH_SOURCE[0]}")/../../core}/core/build.func"
+source "$_cs_boot" 2>/dev/null || source <(curl -fsSL "${COMMUNITY_SCRIPTS_CORE_URL:-https://raw.githubusercontent.com/community-scripts/core/main}/core/build.func")
+# Copyright (c) 2021-2026 community-scripts ORG
+# Author: MickLesk (CanbiZ)
+# License: MIT | https://github.com/community-scripts/ProxmoxVE/raw/main/LICENSE
+# Source: https://github.com/chartdb/chartdb
+
+APP="ChartDB"
+var_tags="${var_tags:-database;diagram;dev-tools}"
+var_cpu="${var_cpu:-2}"
+var_ram="${var_ram:-6144}"
+var_disk="${var_disk:-4}"
+var_os="${var_os:-debian}"
+var_version="${var_version:-13}"
+var_arm64="${var_arm64:-yes}"
+var_unprivileged="${var_unprivileged:-1}"
+
+header_info "$APP"
+variables
+color
+catch_errors
+
+function update_script() {
+  header_info
+  check_container_storage
+  check_container_resources
+
+  if [[ ! -d /opt/chartdb ]]; then
+    msg_error "No ${APP} Installation Found!"
+    exit
+  fi
+
+  if check_for_gh_release "chartdb" "chartdb/chartdb"; then
+    msg_info "Stopping ChartDB"
+    systemctl stop nginx
+    msg_ok "Stopped ChartDB"
+
+    NODE_VERSION="24" setup_nodejs
+    CLEAN_INSTALL=1 fetch_and_deploy_gh_release "chartdb" "chartdb/chartdb" "tarball"
+
+    msg_info "Building ChartDB"
+    cd /opt/chartdb
+    $STD npm ci
+    NODE_OPTIONS="--max-old-space-size=4096" $STD npm run build
+    rm -rf /opt/chartdb/node_modules
+    msg_ok "Built ChartDB"
+
+    msg_info "Starting ChartDB"
+    systemctl start nginx
+    msg_ok "Started ChartDB"
+    msg_ok "Updated successfully!"
+  fi
+  exit
+}
+
+start
+build_container
+description
+
+msg_ok "Completed Successfully!\n"
+echo -e "${CREATING}${GN}${APP} setup has been successfully initialized!${CL}"
+echo -e "${INFO}${YW}Access it using the following URL:${CL}"
+echo -e "${GATEWAY}${BGN}https://${IP}${CL}"

ct/discourse.sh

@@ -51,31 +51,16 @@ function update_script() {
   cd /opt/discourse
   export PATH="$HOME/.rbenv/bin:$HOME/.rbenv/shims:$PATH"
   export COREPACK_ENABLE_DOWNLOAD_PROMPT=0
-  export BUNDLE_SILENCE_ROOT_WARNING=1
   set -a
   source /opt/discourse/.env
   set +a
   $STD git pull origin main
-  msg_ok "Updated Discourse"
-
-  msg_info "Updating Dependencies"
-  RUBY_TARGET=$(grep -A1 '^RUBY VERSION' /opt/discourse/Gemfile.lock | grep -oE '[0-9]+\.[0-9]+\.[0-9]+' | head -n1)
-  RUBY_VERSION="${RUBY_TARGET:-4.0.7}" RUBY_INSTALL_RAILS="false" setup_ruby
-  export PATH="$HOME/.rbenv/bin:$HOME/.rbenv/shims:$PATH"
-  hash -r
-  cd /opt/discourse
-  $STD bundle install -j"$(nproc)"
+  $STD bundle install
   $STD pnpm install
-  msg_ok "Updated Dependencies"
-
-  msg_info "Running Database Migrations"
   $STD runuser -u postgres -- psql -d discourse -c "CREATE EXTENSION IF NOT EXISTS vector;"
   $STD bundle exec rails db:migrate
-  msg_ok "Ran Database Migrations"
-
-  msg_info "Precompiling Assets"
   $STD bundle exec rails assets:precompile
-  msg_ok "Precompiled Assets"
+  msg_ok "Updated Discourse"
 
   msg_info "Starting Services"
   systemctl start discourse discourse-sidekiq

install/chartdb-install.sh

@@ -0,0 +1,75 @@
+#!/usr/bin/env bash
+
+# Copyright (c) 2021-2026 community-scripts ORG
+# Author: MickLesk (CanbiZ)
+# License: MIT | https://github.com/community-scripts/ProxmoxVE/raw/main/LICENSE
+# Source: https://github.com/chartdb/chartdb
+
+source /dev/stdin <<<"$FUNCTIONS_FILE_PATH"
+color
+verb_ip6
+catch_errors
+setting_up_container
+network_check
+update_os
+
+msg_info "Installing Dependencies"
+$STD apt install -y nginx
+msg_ok "Installed Dependencies"
+
+NODE_VERSION="24" setup_nodejs
+fetch_and_deploy_gh_release "chartdb" "chartdb/chartdb" "tarball"
+
+msg_info "Building ChartDB"
+cd /opt/chartdb
+$STD npm ci
+NODE_OPTIONS="--max-old-space-size=4096" $STD npm run build
+rm -rf /opt/chartdb/node_modules
+msg_ok "Built ChartDB"
+
+msg_info "Configuring ChartDB"
+mkdir -p /opt/chartdb_data
+cat <<'EOF' >/opt/chartdb_data/config.js
+window.env = {
+    DISABLE_ANALYTICS: "true",
+    // OPENAI_API_KEY: "",
+    // OPENAI_API_ENDPOINT: "https://ollama.example.com/v1",
+    // LLM_MODEL_NAME: "qwen2.5-coder:7b",
+};
+EOF
+create_self_signed_cert "chartdb"
+# HTTPS because the AI export (crypto.subtle) and the copy buttons need a secure context
+cat <<'EOF' >/etc/nginx/sites-available/chartdb
+server {
+    listen 80 default_server;
+    server_name _;
+    return 301 https://$host$request_uri;
+}
+
+server {
+    listen 443 ssl default_server;
+    http2 on;
+    server_name _;
+
+    ssl_certificate /etc/ssl/chartdb/chartdb.crt;
+    ssl_certificate_key /etc/ssl/chartdb/chartdb.key;
+
+    root /opt/chartdb/dist;
+    index index.html;
+
+    location / {
+        try_files $uri $uri/ /index.html;
+    }
+
+    location = /config.js {
+        alias /opt/chartdb_data/config.js;
+        add_header Cache-Control "no-cache";
+    }
+}
+EOF
+nginx_enable_site "chartdb"
+msg_ok "Configured ChartDB"
+
+motd_ssh
+customize
+cleanup_lxc

install/discourse-install.sh

@@ -28,14 +28,9 @@ $STD apt install -y \
   redis-server
 msg_ok "Installed Dependencies"
 
-msg_info "Cloning Discourse"
-$STD git clone --depth 1 https://github.com/discourse/discourse.git /opt/discourse
-msg_ok "Cloned Discourse"
-
 PG_VERSION="17" PG_MODULES="pgvector" setup_postgresql
 NODE_VERSION="24" setup_nodejs
-RUBY_TARGET=$(grep -A1 '^RUBY VERSION' /opt/discourse/Gemfile.lock | grep -oE '[0-9]+\.[0-9]+\.[0-9]+' | head -n1)
-RUBY_VERSION="${RUBY_TARGET:-4.0.7}" RUBY_INSTALL_RAILS="false" setup_ruby
+RUBY_VERSION="3.4.4" setup_ruby
 
 msg_info "Configuring PostgreSQL for Discourse"
 DISCOURSE_DB_PASS=$(random_password 13)
@@ -47,6 +42,7 @@ msg_ok "Configured PostgreSQL for Discourse"
 
 msg_info "Configuring Discourse"
 DISCOURSE_SECRET_KEY=$(openssl rand -hex 64)
+$STD git clone --depth 1 https://github.com/discourse/discourse.git /opt/discourse
 cd /opt/discourse
 cat <<EOF >/opt/discourse/.env
 RAILS_ENV=production
@@ -81,7 +77,6 @@ export PATH="$HOME/.rbenv/bin:$HOME/.rbenv/shims:$PATH"
 eval "$(rbenv init - bash)" 2>/dev/null || true
 export RAILS_ENV=production
 export COREPACK_ENABLE_DOWNLOAD_PROMPT=0
-export BUNDLE_SILENCE_ROOT_WARNING=1
 $STD corepack enable
 $STD bundle config set --local deployment true
 $STD bundle config set --local without 'test development'