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 { Annotation, type EditorState, type Extension, type Range } from "@codemirror/state";
import { SearchCursor } from "@codemirror/search";
import { Decoration, type DecorationSet, EditorView, ViewPlugin, type ViewUpdate } from "@codemirror/view";
const MIN_SELECTION_MATCH_LENGTH = 2;
const MAX_SELECTION_MATCH_LENGTH = 200;
const MAX_SCROLLBAR_MATCHES = 1200;
const MAX_SELECTION_MATCH_HIGHLIGHTS = 500;
export const SELECTION_MATCH_SCAN_CHUNK_LENGTH = 64 * 1024;
export const SELECTION_MATCH_UPDATE_DELAY_MS = 120;
export interface SelectionMatchMarker {
from: number;
to: number;
lineNumber: number;
selected: boolean;
}
function selectedMatchQuery(state: EditorState): string | null {
const selection = state.selection.main;
if (selection.empty) return null;
if (selection.to - selection.from > MAX_SELECTION_MATCH_LENGTH) return null;
const text = state.sliceDoc(selection.from, selection.to);
if (text.length < MIN_SELECTION_MATCH_LENGTH || !text.trim() || /[\r\n]/.test(text)) return null;
return text;
}
export class SelectionMatchMarkerScan {
readonly markers: SelectionMatchMarker[] = [];
private readonly seenLines = new Set<number>();
private from = 0;
private matchesScanned = 0;
private readonly lookaheadLength: number;
constructor(
private readonly state: EditorState,
private readonly query: string,
) {
const selection = state.selection.main;
const selectedLine = state.doc.lineAt(selection.from);
this.seenLines.add(selectedLine.number);
this.seenLines.add(-selectedLine.number);
this.markers.push({ from: selection.from, to: selection.to, lineNumber: selectedLine.number, selected: true });
// SearchCursor compares NFKD text, whose source can use two UTF-16 units per normalized code point.
const normalizedQuery = typeof query.normalize === "function" ? query.normalize("NFKD") : query;
this.lookaheadLength = Math.max(query.length, normalizedQuery.length * 2) - 1;
}
scanNextChunk(): boolean {
const doc = this.state.doc;
if (this.from >= doc.length || this.matchesScanned >= MAX_SCROLLBAR_MATCHES) return true;
const chunkFrom = this.from;
const chunkTo = Math.min(doc.length, chunkFrom + SELECTION_MATCH_SCAN_CHUNK_LENGTH);
// Include enough lookahead to catch normalized matches that start in this chunk and cross its boundary.
const searchTo = Math.min(doc.length, chunkTo + this.lookaheadLength);
const selection = this.state.selection.main;
const cursor = new SearchCursor(doc, this.query, chunkFrom, searchTo);
for (let match = cursor.next(); !match.done; match = cursor.next()) {
const { from, to } = match.value;
if (from >= chunkTo) break;
if (from === to) continue;
this.matchesScanned += 1;
const line = doc.lineAt(from);
const selected = from === selection.from && to === selection.to;
const lineKey = selected ? -line.number : line.number;
if (!this.seenLines.has(lineKey)) {
this.seenLines.add(lineKey);
this.markers.push({ from, to, lineNumber: line.number, selected });
}
if (this.matchesScanned >= MAX_SCROLLBAR_MATCHES) return true;
}
this.from = chunkTo;
return this.from >= doc.length;
}
}
export function createSelectionMatchMarkerScan(state: EditorState): SelectionMatchMarkerScan | null {
const query = selectedMatchQuery(state);
return query ? new SelectionMatchMarkerScan(state, query) : null;
}
class SelectionMatchScrollbar {
private readonly layer: HTMLElement;
private readonly win: Window;
private signature = "";
private updateTimer: number | null = null;
private scanFrame: number | null = null;
private revision = 0;
constructor(view: EditorView) {
this.layer = document.createElement("div");
this.layer.className = "cm-selectionMatchScrollbarLayer";
this.win = view.dom.ownerDocument.defaultView ?? window;
view.dom.appendChild(this.layer);
this.scheduleRender(view, 0);
}
update(update: ViewUpdate) {
if (update.docChanged || update.selectionSet) this.scheduleRender(update.view);
}
destroy() {
this.cancelScheduledRender();
this.layer.remove();
}
private cancelScheduledRender() {
this.revision += 1;
if (this.updateTimer !== null) {
this.win.clearTimeout(this.updateTimer);
this.updateTimer = null;
}
if (this.scanFrame !== null) {
this.win.cancelAnimationFrame(this.scanFrame);
this.scanFrame = null;
}
}
private scheduleRender(view: EditorView, delay = SELECTION_MATCH_UPDATE_DELAY_MS) {
this.cancelScheduledRender();
const scan = createSelectionMatchMarkerScan(view.state);
this.renderMarkers([], view.state.doc.lines);
if (!scan) return;
const revision = this.revision;
this.updateTimer = this.win.setTimeout(() => {
this.updateTimer = null;
this.scanNextFrame(view, scan, revision);
}, delay);
}
private scanNextFrame(view: EditorView, scan: SelectionMatchMarkerScan, revision: number) {
if (revision !== this.revision) return;
if (scan.scanNextChunk()) {
this.renderMarkers(scan.markers, view.state.doc.lines);
return;
}
// Yield between chunks so a large document never monopolizes pointer and paint work.
this.scanFrame = this.win.requestAnimationFrame(() => {
this.scanFrame = null;
this.scanNextFrame(view, scan, revision);
});
}
private renderMarkers(markers: SelectionMatchMarker[], lineCount: number) {
const signature = `${lineCount}|${markers.map((marker) => `${marker.lineNumber}:${marker.from}:${marker.to}:${marker.selected}`).join("|")}`;
if (signature === this.signature) return;
this.signature = signature;
this.layer.replaceChildren(
...markers.map((marker) => {
const el = document.createElement("div");
el.className = marker.selected ? "cm-selectionMatchScrollbarMark cm-selectionMatchScrollbarMark-selected" : "cm-selectionMatchScrollbarMark";
const ratio = lineCount <= 1 ? 0 : (marker.lineNumber - 1) / (lineCount - 1);
el.style.top = `${Math.max(0, Math.min(1, ratio)) * 100}%`;
return el;
}),
);
}
}
const selectionMatchScrollbar = ViewPlugin.fromClass(SelectionMatchScrollbar);
interface SelectionMatchHighlightSpec {
query: string;
selectionFrom: number;
selectionTo: number;
}
const selectionMatchDecoration = Decoration.mark({ class: "cm-selectionMatch" });
/** Re-reads the pending decoration set without asking for another rescan. */
const flushSelectionMatchHighlights = Annotation.define<boolean>();
/**
* Same query rules as `@codemirror/search`'s `highlightSelectionMatches` with
* the options this app used (no whole-word filter, no word-around-cursor), so
* only the timing of the visible highlight set changes.
*/
function selectionMatchHighlightSpec(state: EditorState): SelectionMatchHighlightSpec | null {
const selection = state.selection;
if (selection.ranges.length > 1) return null;
const range = selection.main;
if (range.empty) return null;
const length = range.to - range.from;
if (length < MIN_SELECTION_MATCH_LENGTH || length > MAX_SELECTION_MATCH_LENGTH) return null;
const query = state.sliceDoc(range.from, range.to);
return query ? { query, selectionFrom: range.from, selectionTo: range.to } : null;
}
function buildSelectionMatchHighlights(view: EditorView, spec: SelectionMatchHighlightSpec): DecorationSet {
const decorations: Range<Decoration>[] = [];
for (const visible of view.visibleRanges) {
const cursor = new SearchCursor(view.state.doc, spec.query, visible.from, visible.to);
for (let match = cursor.next(); !match.done; match = cursor.next()) {
const { from, to } = match.value;
// The selected occurrence keeps the editor's own selection background.
if (from >= spec.selectionTo || to <= spec.selectionFrom) decorations.push(selectionMatchDecoration.range(from, to));
if (decorations.length > MAX_SELECTION_MATCH_HIGHLIGHTS) return Decoration.none;
}
}
return Decoration.set(decorations);
}
class DeferredSelectionMatchHighlighter {
decorations: DecorationSet;
private readonly win: Window;
private updateTimer: number | null = null;
constructor(private readonly view: EditorView) {
this.win = view.dom.ownerDocument.defaultView ?? window;
const spec = selectionMatchHighlightSpec(view.state);
this.decorations = spec ? buildSelectionMatchHighlights(view, spec) : Decoration.none;
}
update(update: ViewUpdate) {
if (update.transactions.some((transaction) => transaction.annotation(flushSelectionMatchHighlights))) {
const spec = selectionMatchHighlightSpec(update.state);
this.decorations = spec ? buildSelectionMatchHighlights(update.view, spec) : Decoration.none;
return;
}
// Clearing is cheap, so a selection that no longer has a highlightable
// query never keeps stale ranges on screen.
if (!selectionMatchHighlightSpec(update.state)) {
this.cancelScheduledUpdate();
if (this.decorations.size) this.decorations = Decoration.none;
return;
}
if (update.docChanged) this.decorations = this.decorations.map(update.changes);
if (update.docChanged || update.selectionSet || update.viewportChanged || update.geometryChanged) this.scheduleUpdate();
}
destroy() {
this.cancelScheduledUpdate();
}
private cancelScheduledUpdate() {
if (this.updateTimer === null) return;
this.win.clearTimeout(this.updateTimer);
this.updateTimer = null;
}
private scheduleUpdate() {
this.cancelScheduledUpdate();
// Rebuilding these marks re-lays out every decorated line, which on WebKit
// costs more than the drag frame itself. Wait for the selection to settle,
// then flush with one transaction so the decorations get picked up.
this.updateTimer = this.win.setTimeout(() => {
this.updateTimer = null;
this.view.dispatch({ annotations: flushSelectionMatchHighlights.of(true) });
}, SELECTION_MATCH_UPDATE_DELAY_MS);
}
}
const selectionMatchHighlighter = ViewPlugin.fromClass(DeferredSelectionMatchHighlighter, {
decorations: (plugin) => plugin.decorations,
});
export function selectionMatchOccurrences(): Extension {
return [
selectionMatchHighlighter,
selectionMatchScrollbar,
EditorView.theme({
"&": {
"--dbx-selection-match-background": "rgb(59 130 246 / 0.07)",
"--dbx-selection-match-border": "rgb(59 130 246 / 0.24)",
"--dbx-selection-match-main-background": "rgb(59 130 246 / 0.11)",
"--dbx-selection-match-main-border": "rgb(59 130 246 / 0.36)",
position: "relative",
},
".dark &": {
"--dbx-selection-match-background": "rgb(147 197 253 / 0.12)",
"--dbx-selection-match-border": "rgb(147 197 253 / 0.3)",
"--dbx-selection-match-main-background": "rgb(147 197 253 / 0.18)",
"--dbx-selection-match-main-border": "rgb(147 197 253 / 0.42)",
},
".cm-selectionMatch": {
backgroundColor: "var(--dbx-selection-match-background)",
borderRadius: "2px",
boxShadow: "inset 0 0 0 1px var(--dbx-selection-match-border)",
},
".cm-selectionMatch-main": {
backgroundColor: "var(--dbx-selection-match-main-background)",
boxShadow: "inset 0 0 0 1px var(--dbx-selection-match-main-border)",
},
".cm-selectionMatchScrollbarLayer": {
bottom: "2px",
pointerEvents: "none",
position: "absolute",
right: "2px",
top: "2px",
width: "5px",
zIndex: "40",
},
".cm-selectionMatchScrollbarMark": {
backgroundColor: "color-mix(in oklab, var(--primary) 48%, transparent)",
borderRadius: "999px",
height: "2px",
position: "absolute",
right: "0",
transform: "translateY(-50%)",
width: "3px",
},
".cm-selectionMatchScrollbarMark-selected": {
backgroundColor: "color-mix(in oklab, var(--primary) 72%, transparent)",
height: "3px",
width: "4px",
},
}),
];
}