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 { safeLocalStorageGet, safeLocalStorageSet } from "@/lib/backend/safeStorage";
export const SQL_FILE_FOLDERS_UI_STATE_STORAGE_KEY = "dbx-sql-file-folders-ui-state";
export interface SqlFileFolderUiState {
collapsed?: boolean;
expanded?: string[];
}
/**
* Load the persisted UI state (collapsed root flag and expanded subdirectory paths)
* for each external SQL file folder.
*/
export function getSqlFileFoldersUiState(): Record<string, SqlFileFolderUiState> {
try {
const raw = safeLocalStorageGet(SQL_FILE_FOLDERS_UI_STATE_STORAGE_KEY);
if (!raw) return {};
const parsed = JSON.parse(raw);
if (!parsed || typeof parsed !== "object" || Array.isArray(parsed)) return {};
const result: Record<string, SqlFileFolderUiState> = {};
for (const [key, value] of Object.entries(parsed)) {
if (!value || typeof value !== "object") continue;
const v = value as { collapsed?: unknown; expanded?: unknown };
result[key] = {
collapsed: typeof v.collapsed === "boolean" ? v.collapsed : false,
expanded: Array.isArray(v.expanded) ? v.expanded.filter((p): p is string => typeof p === "string") : [],
};
}
return result;
} catch {
return {};
}
}
/**
* Persist the UI state for all external SQL file folders.
*/
export function saveSqlFileFoldersUiState(state: Record<string, SqlFileFolderUiState>): void {
safeLocalStorageSet(SQL_FILE_FOLDERS_UI_STATE_STORAGE_KEY, JSON.stringify(state));
}