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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
import type { KvKeyMetadata } from "@/lib/backend/api";
import { safeJsonFormat } from "@/lib/common/safeJsonFormat";
export interface PrettyPrintJsonResult {
ok: boolean;
value?: string;
error?: "invalid_json";
}
export type Base64Utf8PreviewResult = { ok: true; value: string; lossy: boolean } | { ok: false; error: "invalid_base64" };
export interface DisplayItem {
label: string;
value: string;
}
export interface ZooKeeperSummaryLabels {
revision?: string;
version?: string;
lease?: string;
size?: string;
}
const strictBase64Pattern = /^(?:[A-Za-z0-9+/]{4})*(?:[A-Za-z0-9+/]{2}==|[A-Za-z0-9+/]{3}=)?$/;
export function decodeBase64Utf8Preview(value: string): Base64Utf8PreviewResult {
const normalized = value.replace(/\s+/g, "");
if (!strictBase64Pattern.test(normalized)) return { ok: false, error: "invalid_base64" };
try {
const binary = atob(normalized);
const bytes = Uint8Array.from(binary, (character) => character.charCodeAt(0));
try {
return {
ok: true,
value: new TextDecoder("utf-8", { fatal: true }).decode(bytes),
lossy: false,
};
} catch {
return {
ok: true,
value: new TextDecoder("utf-8").decode(bytes),
lossy: true,
};
}
} catch {
return { ok: false, error: "invalid_base64" };
}
}
export function prettyPrintJsonText(text: string): PrettyPrintJsonResult {
try {
return { ok: true, value: safeJsonFormat(text, 2) };
} catch {
return { ok: false, error: "invalid_json" };
}
}
function valueLabel(value: string | number | null | undefined): string {
return value == null ? "-" : String(value);
}
function byteLabel(value: number | null | undefined): string {
return value == null ? "- B" : `${value} B`;
}
function hexLabel(value: number | null | undefined): string {
if (value == null) return "-";
return `0x${Math.trunc(value).toString(16)}`;
}
function dateTimeLabel(value: number | null | undefined): string {
if (value == null) return "-";
const date = new Date(value);
if (Number.isNaN(date.getTime())) return "-";
const pad = (part: number) => String(part).padStart(2, "0");
return `${date.getFullYear()}-${pad(date.getMonth() + 1)}-${pad(date.getDate())} ${pad(date.getHours())}:${pad(date.getMinutes())}:${pad(date.getSeconds())}`;
}
function metadataNumber(metadata: KvKeyMetadata | null | undefined, key: keyof KvKeyMetadata): number | null | undefined {
return metadata?.[key] as number | null | undefined;
}
export function formatZooKeeperSummaryBadges(metadata: KvKeyMetadata | null | undefined, labels: ZooKeeperSummaryLabels = {}): DisplayItem[] {
return [
{ label: labels.revision ?? "rev", value: valueLabel(metadata?.modRevision ?? metadata?.mzxid) },
{ label: labels.version ?? "ver", value: valueLabel(metadata?.version) },
{ label: labels.lease ?? "lease", value: valueLabel(metadata?.lease) },
{ label: labels.size ?? "size", value: byteLabel(metadata?.valueSize ?? metadata?.dataLength) },
];
}
export function formatZooKeeperMetadataRows(metadata: KvKeyMetadata | null | undefined): DisplayItem[] {
return [
{ label: "ephemeralOwner", value: hexLabel(metadata?.ephemeralOwner) },
{ label: "mtime", value: dateTimeLabel(metadata?.mtime) },
{ label: "ctime", value: dateTimeLabel(metadata?.ctime) },
{ label: "mZxid", value: hexLabel(metadata?.mzxid) },
{ label: "pZxid", value: hexLabel(metadataNumber(metadata, "pzxid")) },
{ label: "cZxid", value: hexLabel(metadata?.czxid) },
{ label: "dataLength", value: valueLabel(metadata?.dataLength) },
{ label: "numChildren", value: valueLabel(metadata?.numChildren) },
{ label: "dataVersion", value: valueLabel(metadata?.version) },
{ label: "aclVersion", value: valueLabel(metadata?.aversion) },
{ label: "cVersion", value: valueLabel(metadata?.cversion) },
];
}