Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

2.6 KB
Raw Blame
import type { Metadata } from "next";

export const SITE_URL = "https://dbxio.com";
export const SITE_NAME = "DBX";
export const DEFAULT_DESCRIPTION = "DBX is a free, open-source database client for MySQL, PostgreSQL, SQLite, Redis and 100+ data systems, with SQL editing, AI assistance and Docker self-hosting.";
export const DEFAULT_OG_IMAGE = "https://dl.dbxio.com/assets/readme-hero-20260925.png";

const LOCALE_MAP: Record<string, string> = {
  en: "en_US",
  cn: "zh_CN",
};

const HTML_LANG_MAP: Record<string, string> = {
  en: "en",
  cn: "zh-CN",
};

export function getHtmlLang(lang: string): string {
  return HTML_LANG_MAP[lang] ?? "en";
}

function swapLang(path: string, to: string): string {
  return path.replace(/^\/(en|cn)(?=\/|$)/, `/${to}`);
}

interface BuildMetadataParams {
  title: string;
  description: string;
  path: string;
  lang: string;
  ogType?: "website" | "article";
  images?: string[];
  lastModified?: Date;
  markdownPath?: string;
}

export function buildMetadata({ title, description, path, lang, ogType = "website", images, lastModified, markdownPath }: BuildMetadataParams): Metadata {
  const normalizedPath = path.split(/[?#]/)[0].replace(/\/+$/, "") || "/";
  const canonical = `${SITE_URL}${normalizedPath}`;
  const locale = LOCALE_MAP[lang] ?? "en_US";
  const defaultImage = { url: DEFAULT_OG_IMAGE, width: 1792, height: 896 };
  const ogImages = images?.map((url) => (url === DEFAULT_OG_IMAGE ? defaultImage : { url })) ?? [defaultImage];

  const base: Metadata = {
    title,
    description,
    alternates: {
      canonical,
      languages: {
        en: `${SITE_URL}${swapLang(normalizedPath, "en")}`,
        "zh-CN": `${SITE_URL}${swapLang(normalizedPath, "cn")}`,
        "x-default": `${SITE_URL}${swapLang(normalizedPath, "en")}`,
      },
      ...(markdownPath ? { types: { "text/markdown": `${SITE_URL}${markdownPath}` } } : {}),
    },
    robots: {
      index: true,
      follow: true,
      googleBot: { index: true, follow: true, "max-image-preview": "large", "max-snippet": -1, "max-video-preview": -1 },
    },
    openGraph: {
      title,
      description,
      url: canonical,
      siteName: SITE_NAME,
      type: ogType,
      locale,
      alternateLocale: Object.values(LOCALE_MAP).filter((alternate) => alternate !== locale),
      images: ogImages,
    },
    twitter: {
      card: "summary_large_image",
      title,
      description,
      images: images ?? [DEFAULT_OG_IMAGE],
    },
    other: {
      "og:image:alt": title,
    },
  };

  if (lastModified) {
    base.other = { ...base.other, "article:modified_time": lastModified.toISOString() };
  }

  return base;
}