Search Results
No results found.
1. Introduction and Quick Start
FastEditor is a fast native desktop text editor for everyday editing, source code, logs, CSV files, Markdown documents, and large text files. It starts quickly, stays responsive, and does not require heavy runtimes such as Electron, .NET, or Java.
Core Philosophy
- Fast Startup: Open the editor quickly and begin working without waiting for a large runtime to load.
- Low Resource Usage: Keep memory use modest, even with multiple documents open.
- Large-File Support: Work with anything from small notes to very large log files.
Command Palette
The Command Palette gives quick keyboard access to editor commands. Press Ctrl+Shift+P, type part of a command name, and press Enter to run it. The same commands are also available from the menus and toolbar where applicable.
Help Navigation Shortcuts (Browser Built-ins)
When reading this help, you can use standard browser shortcuts to move faster without touching the mouse.
| Hotkey | Action | Why It Matters for FastEditor |
|---|---|---|
Ctrl + F (or /) |
Search the documentation | The fastest way to find a specific CLI flag or JSON key. |
Ctrl + + / Ctrl + - |
Zoom in / zoom out | Improves readability on any display, from 4K monitors to laptops. |
Ctrl + 0 |
Reset zoom to 100% | Quickly returns the page to the default layout scale. |
Alt + Left Arrow |
Back | Useful after opening another section and wanting to return immediately. |
Ctrl + W (or Ctrl + F4) |
Close help window | Instantly returns focus to the editor workflow. |
Extra Keyboard Navigation in This Help
- Vim-style: Press
Jor]for the next section, andKor[for the previous section in the sidebar order. - Numeric jump: Press
Alt + 1throughAlt + 7to jump directly to sections 1-7.
2. File Handling Modes (Core Concepts)
FastEditor uses different file handling modes to balance editing features, performance, and safety.
Normal Editing Mode
Most files open in normal editing mode. You can type, delete, copy, paste, undo, redo, search, replace, and save as usual. Copy and Paste retry automatically when another program briefly holds the clipboard. Changes are kept in the editor until you save the document.
Large File Mode (Mapped Read-Only Mode)
Files of 1 GB and larger open in Mapped Read-Only Mode. In this mode FastEditor maps the file for viewing and navigation without loading the whole file into editable memory, while indexing lines in the background. Find, Find Next, and Copy work immediately after opening and search across the whole file. Operations that need the exact number of lines (SQL query, Export with hidden columns, CSV Join, Go to Line, bookmarks, log filter and error navigation, and Print) wait until the file is indexed and show "Indexing large file... please try again when it finishes." in the meantime. Scripts also receive the exact line count.
Restrictions in Mapped Read-Only Mode
To protect performance and avoid unsafe edits, these restrictions apply in Mapped Read-Only Mode:
| Feature | Availability |
|---|---|
| Text Input & Deletion | BLOCKED |
| Paste / Cut Operations | BLOCKED |
| Markdown Live Preview | BLOCKED |
| Live Filtering | BLOCKED |
| Scrolling & Navigation | Available |
| Standard Search & Find-in-Files | Available |
| Asynchronous Diff View | Available |
Recovery Snapshots
FastEditor can create temporary recovery snapshots for modified documents. If the application or system closes unexpectedly, the editor can offer to restore available recovery data on the next startup.
Text Transformation & Editing Tools
FastEditor provides built-in utilities for common text transformations:
- Change Case: Transform the active selection via Edit > Change Case to UPPERCASE, lowercase, or Title Case (with full Unicode letter capitalization). If there is no selection, the command safely performs no operation.
- Trim Trailing Whitespace: Remove unwanted spaces and tab characters from the ends of lines across the document or active selection via Edit > Trim Trailing Whitespace. You can also enable Trim Trailing Whitespace on Save in Tools > Preferences... (Ctrl+,) to automatically clean lines before saving.
- Remove Duplicate Lines: Remove redundant identical lines from the entire file or active selection via Edit > Remove Duplicate Lines. Retains the first occurrence of each unique line while preserving original line break formats.
Tab Expansion, Indentation & Dedent
FastEditor provides full visual tab expansion and intuitive indentation controls:
- Visual Tab Expansion: When Indent Style is set to Tabs, real tab characters (
\t) visually expand to the configured tab stop width (Preferences > General > Tab size, default 4). This expansion is consistently maintained across text rendering, caret positioning, mouse clicking, and rectangular or stream selections. - Tab Indentation: Pressing
Tabadvances the caret or indents selected text to the next tab stop interval. - Dedent (Shift + Tab): Pressing
Shift + Tabremoves one indentation level (dedents) from the active line or from all lines intersecting the current selection, instead of inserting a tab character.
Indent Guides
FastEditor can display subtle vertical guide lines for leading indentation levels to visualize block hierarchies in structured documents (JSON, YAML, XML, SQL, and source code):
- Toggle Indent Guides: Press
Ctrl + Shift + I(or choose View > Indent Guides) to toggle guide lines on and off. - Word Wrap Support: Indent guides remain accurately positioned and aligned even when soft line wrapping (Word Wrap) is enabled.
- Preferences: Toggle Show indent guides in Preferences > General to control the default state.
Always on Top
Keep the main FastEditor window floating above other desktop application windows:
- Toggle: Toggle via View > Always on Top or the Command Palette.
- Persistence: State is remembered between sessions.
- Separate Windows: DB Builder and File Manager windows opened from the editor are separate windows and can appear behind it while this is on.
Line Numbers
Control the visibility of line numbers in the plain-text editor:
- Toggle: Toggle via View > Show Line Numbers or the Command Palette.
- Persistence: State is remembered between sessions.
- Marker Strip: When hidden, a narrow strip remains for bookmark and highlighting-rule markers.
- Special Views: CSV, grid and Diff views always show row numbers.
Toolbar Groups
Customize which button groups appear on the main toolbar to fit your editing workflow:
- Toggle Groups: Right-click anywhere on the toolbar, or choose View > Toolbar Groups, to display a menu of all 11 button groups and toggle their visibility.
- Reset to Default: Select Reset to Default from the toolbar context menu or the View > Toolbar Groups submenu to restore all toolbar button groups to their default state.
- Command Palette: All toolbar group toggles and the reset command are also accessible from the Command Palette (
Ctrl+Shift+P). - Persistence: Toolbar button group visibility preferences are saved automatically across sessions.
Favorites Bar
The favorites bar provides quick one-click access to frequently opened files directly below the toolbar:
- Adding Files: Right-click any open file tab and choose Add to Favorites to pin the file to the favorites bar.
- Opening Files: Click any button on the favorites bar to open that file in the editor.
- Drag to Reorder: Drag an item to a new position. A visual marker shows where it will land, including in wrapped multi-row layouts. Releasing the mouse button places the item at the marked position and saves the new order.
- Canceling a Drag: Press
Escapeor release the mouse outside the bar to cancel the drag without changing the order. - Context Menu: Right-click any favorite item to open its context menu with options to remove the item, move it left or right, or copy its file path to the clipboard.
- Persistence: The list of favorites and their custom display order are saved automatically across sessions.
3. Special Formats (CSV, Parquet, JSON, NDJSON, Logs, Markdown)
FastEditor includes dedicated high-performance modes and viewers for structured tabular data, big data columnar formats, JSON documents, streaming logs, and Markdown.
CSV Mode (Grid View)
CSV mode displays delimited text as a high-speed tabular grid. FastEditor automatically detects common delimiters (comma, semicolon, tab, pipe) and uses virtualized rendering for instant scrolling across millions of rows. Direct text editing is paused in grid mode to preserve column structure.
Column sorting, column resizing and reordering, inline cell editing (F2), per-column filtering, freeze header, extended aggregate calculations (Average, Minimum, Maximum), and layout persistence via .femeta sidecars (written only for files with a custom layout; a damaged sidecar is ignored) are included in FastEditor Core and accessible via toolbar buttons, menus, and shortcuts. Exporting filtered rows or query projections to a new file, or sending filtered rows to DB Builder, requires FastEditor Pro.
Sorting, Selection, and Exporting Filtered Rows: Automatic column sorting detects numeric columns even when the file ends with a line break or contains empty cells, and places empty cells last in both ascending and descending order. The header row stays at the top only when Freeze Header is on (also for SQL queries). A trailing empty line at the end of the file is excluded from sorting, column filters, and SQL results. Select All (Ctrl+A) in a sorted or filtered CSV view selects the visible rows. CSV > Export Filtered Rows... exports the rows in the sort and filter order shown in the grid (including for large mapped files); it is available for CSV grids only and is not offered in JSON, NDJSON, or Parquet grids.
Send to DB Builder: Choose CSV > Send to DB Builder... to send the CSV document to Database Builder for importing into a new table or the current table. Sending always writes all columns in their original file order (regardless of hidden or reordered columns on screen), and the first line of the document is always used as the header whether Freeze Header is on or off. Sending the whole CSV file (in file row order, with no active row filter) is included in FastEditor Core; sending filtered rows (column filter, Filter-as-you-type, or in-place SQL query) requires FastEditor Pro.
SQL Query Bar & Natural Language AI (NL→SQL)
Press Ctrl+Q (or choose CSV > SQL Query) to open the interactive SQL Query Bar at the bottom of the editor. Querying supports two modes:
- In-Place Fast Filter (Core): Filter, project, and sort rows in place using standard SQL syntax:
SELECT,WHERE(with=,!=,LIKE,IN, numeric comparisons),ORDER BY, andLIMIT. - Natural Language SQL Generation (Core): Click the [✨ AI] button on the SQL bar to generate queries from plain English descriptions (e.g. "show all active users in California with balance over 100"). FastEditor uses your local LLM (LM Studio, Ollama, vLLM) and supplies schema context and sample rows to produce accurate SQL without sending data to external cloud APIs.
- AI Preview Popup: Inspect the generated SQL before execution. View detected table schema, model latency, and click Run Query, Insert to SQL Bar, or Edit Prompt.
- AI Preferences: Configure your local model under Preferences > AI / Local LLM (
Ctrl+,). Specify the endpoint URL (default:http://localhost:1234/v1), model identifier, temperature, custom system prompt, request timeout, and test your connection with Test Connection.
DuckDB Analytical SQL & Multi-Tab JOINs
When query complexity exceeds simple row filtering, FastEditor automatically routes the query to its embedded DuckDB analytical engine and opens the result in a new tab:
- Aggregations & Grouping: Full support for
GROUP BY,HAVING, and aggregate functions (COUNT,SUM,AVG,MIN,MAX,ROUND,ABS,CEIL,FLOOR,SQRT,POWER). - Scalar Functions: String, regex, date, and conditional functions (
LOWER,UPPER,TRIM,LTRIM,RTRIM,LENGTH,SUBSTR,SUBSTRING,CONCAT,REPLACE,REGEXP_MATCHES,COALESCE,NULLIF,IFNULL,NVL,CAST,CASE/WHEN,STRPTIME,DATE_TRUNC,EXTRACT) are automatically executed in DuckDB. - Multi-Tab SQL JOINs: Join datasets across open tabs directly in SQL without manual export:
SELECT * FROM current JOIN orders ON current.id = orders.user_id. - SQL Bar UX: Real-time syntax highlighting, persistent query history, named query bookmarks, column autocomplete (
Ctrl+Space), and precise error highlighting.
Apache Parquet (.parquet) & JSON Lines (.jsonl / .ndjson)
Open columnar big-data files and streaming JSON Lines files directly:
- Apache Parquet: Open
.parquetfiles of any size. Column types (e.g.[INT64],[VARCHAR],[DOUBLE]) are displayed in headers, and rows are read in blocks as you scroll instead of loading the whole file into memory. - JSON Lines / NDJSON:
.jsonland.ndjsonfiles open as normal editable text tabs with full JSON: Structure Tree (F11) support, and can be converted into an editable CSV grid snapshot at any time via JSON: Open as Table (Ctrl+Shift+J) or the status-bar[Open as Table]badge.
JSON Tools, Structure Tree & JSON as Table
FastEditor provides RFC 8259-compliant streaming JSON validation, lossless formatting, minification, a docked structure tree, and editable tabular snapshots under Tools > JSON, the toolbar, and the Command Palette (Ctrl+Shift+P):
- JSON: Validate (
Ctrl+Shift+K): Validates the active document or selection against strict RFC 8259 syntax in the background without blocking the UI. Reports token count, maximum nesting depth, and elapsed time on the status bar when valid, or jumps the caret to the exact error line and column with the failure reason when invalid. PressEscto cancel an in-progress validation. - Format JSON in Place (
Ctrl+Shift+B), Format JSON to New Tab (Ctrl+J) & Minify JSON: Formats (2-space indentation, preserving the document's CRLF or LF line endings and trailing newline) or minifies the active selection or whole document up to 32 MB. Exact number text (arbitrarily long integers, trailing fractional zeros, scientific notation), key order, and duplicate keys are preserved verbatim without floating-point rounding. Numbers exceeding standard double range (e.g.1e400) and leading UTF-8 BOM are accepted cleanly. Unescaped control characters inside strings (U+0000..U+001F, including raw tabU+0009) are strictly rejected as syntax errors per RFC 8259 Section 7 across all formatting tools includingCtrl+J. In-place formatting and minification record a single Undo step (Ctrl+Z); invalid JSON leaves the document untouched and jumps to the syntax error. Minify JSON is available under Tools > JSON > Minify JSON and the Command Palette (no default keyboard shortcut). - JSON: Structure Tree (
F11): Toggles the docked JSON Tree side panel on the right side of the editor:- Modes & Size Limits: Documents under 32 MB with up to 1,000,000 nodes open in Full mode (all objects, arrays, and scalar values). Documents from 32 MB up to 50 MB (or when the 1,000,000-node cap is reached) automatically switch to Containers-only mode (objects and arrays with child counts). Above 50 MB, select a JSON range of up to 32 MB and open or refresh the tree to index that selection.
- Navigation & Value-Only Selection: Click or use
Up,Down,Left,Right,Home,End,PageUp,PageDown, andEnterto navigate nodes and jump the editor to the node's value span (selecting only the value for object members so you can immediately copy or replace it). - Live Filter: Type in the filter box to match keys and scalar previews (or start with
$or/to filter by JSONPath / JSON Pointer prefix). Matching substrings are highlighted, ancestors expand automatically, the header displaysN matches,Enter/F3/Shift+F3/Up/Downstep through matches, andEscclears the filter and restores the previous expand state. Use[-]and[+]to collapse or expand all containers. - Copy Path, Pointer, Key, Value & Open as Table: Right-click any node (or right-click the bottom path bar) to choose Copy JSONPath (
Ctrl+Con the tree canvas), Copy JSON Pointer (RFC 6901 with~0/~1escaping), Copy Key, Copy Value (Ctrl+Shift+Con the tree canvas, up to 32 MB), or Open as Table on any array or object container node. - Caret Sync: When the Sync checkbox in the panel header is enabled (remembered across restarts), moving the editor caret automatically selects and reveals the deepest containing node in the tree and updates the bottom path bar. Editing the document marks the tree as
(stale - click Refresh)until you click Refresh. - JSON Lines (
.jsonl/.ndjson): Automatically indexes each non-empty line as a top-level[line N]entry and prefixes copied paths withLine N:.
- JSON: Open as Table (
Ctrl+Shift+J) & Export Table to JSON: Opens tabular JSON or JSON Lines data as a detached, editable CSV grid snapshot tab (titled<file> [Table]or<file> [<JSONPath>]):- Supported Shapes & Candidate Picker: Converts top-level arrays of objects, single wrapper objects containing an array of objects, arrays of arrays (
col_1 .. col_N), arrays of scalars (value), objects of objects with shared keys (synthesizing a_keyfirst column), single flat objects (1 row with keys as columns), and.jsonl/.ndjsonstreams. When a document contains multiple table candidates, a picker dialog lets you choose the target JSONPath (showing row counts and sample keys). You can also right-click any array or object node in the JSON Tree and choose Open as Table. - Size Limits & Schema Inference: Supports documents up to 50 MB (or an active selection up to 32 MB), up to 1,000,000 rows, and up to 600 columns (any additional keys beyond 600 are preserved losslessly in a trailing
_overflow_jsoncolumn). Documents exceeding 50 MB are refused safely with: "JSON Open as Table supports documents up to 50 MB (or select a JSON array/object of up to 32 MB)." Selections exceeding 32 MB report: "Selected JSON range exceeds the 32 MB limit for Open as Table." Empty documents report: "Cannot open JSON as table: document is empty." Nested child objects unfold one level intoparent.childcolumns; deeper objects and arrays are stored as compact JSON strings. Embedded line breaks inside string values are escaped reversibly as\n/\rso every JSON record occupies a single grid row. - Detached Snapshot Lifecycle & Save As CSV: The snapshot tab opens clean (not modified) and never alters the source JSON tab or file. If you edit the source JSON tab afterward, the status bar displays
Snapshot from <file> (source modified since snapshot). Closing an unedited snapshot tab closes immediately without prompting; if edited, FastEditor prompts to save changes as a.csvfile (suggesting<stem>.csv). Snapshots under 32 MB of CSV live in memory; larger snapshots stream to a temporary file that is automatically deleted when the tab closes. - JSON: Export Table to JSON: Available from Tools > JSON > Export Table to JSON, the Command Palette, and the CSV grid right-click menu on any JSON table snapshot tab. Reconstructs formatted RFC 8259 JSON (or
.jsonl) in a new modified untitled.jsontab, restoring column types (demoting edited cells that no longer parse as numbers/booleans/JSON to strings and reporting demotion counts on the status bar), foldingparent.childand_overflow_jsoncolumns back into nested objects, and distinguishing empty strings ("") from absent values /null.
- Supported Shapes & Candidate Picker: Converts top-level arrays of objects, single wrapper objects containing an array of objects, arrays of arrays (
Excel Workbooks (.xlsx, .xlsm, .xltx, .xltm) as Table
FastEditor opens modern OpenXML Excel workbooks (.xlsx, .xlsm, .xltx, .xltm) directly as detached, editable CSV grid snapshot tabs via File > Open, drag-and-drop, the command line, Recent Files, Favorites, and the File Manager:
- Sheet Picker & Open Another Sheet: Workbooks with exactly one visible sheet open directly with no prompt. Workbooks with multiple visible sheets open the modal Sheet Picker dialog, listing visible sheets in workbook order followed by hidden sheets badged
[hidden](and veryHidden sheets if no visible or hidden sheets exist), preselecting the active tab or first visible sheet. UseEnteror double-click to open, orEscto cancel without creating a tab. On any open XLSX snapshot tab, choose Table: Open Another Sheet... from the Command Palette, the CSV / Table menu, or the grid context menu to pick and open another sheet from the source workbook in a new tab. - Cell Value Rules & Uncached Formulas: Cell values are extracted faithfully without requiring Excel: dates are formatted as ISO 8601 strings (
YYYY-MM-DDorYYYY-MM-DD HH:MM:SS), numbers are displayed as clean decimal values without simulated currency or percentage symbols, hidden rows and columns are included, and merged cell values appear in the top-left cell. Cells containing formulas display their cached calculation results; if formula cells have no cached value, they are shown empty and reported in the open status message ("<N> formula cells had no cached value and are shown empty"). - Limits & Refused Formats: Supports workbooks up to 50 MB, up to 1,000,000 rows, and up to 600 columns. Workbooks exceeding 50 MB are refused safely with: "XLSX Table View supports workbooks up to 50 MB. Save the sheet as CSV in Excel to open larger files in FastEditor." When sheet dimensions exceed row or column caps, rows or columns are safely truncated and indicated in the status-bar segment (
(first 1,000,000 rows)or(first 600 of N columns)). Refusal occurs only when the sheet has no data within the grid ("This sheet has no data within the first 600 columns and 1,000,000 rows.") or is empty ("The selected worksheet is empty (no cells with data found)."). Legacy Excel 97-2003 binary files (.xls), Excel binary workbooks (.xlsb), OpenDocument spreadsheets (.ods), and password-protected (encrypted) workbooks are refused with clear messages and never opened as corrupt binary text. Workbooks with uncompressed XML exceeding 512 MB or triggering ZIP decompression bombs are safely rejected. - Snapshot Tab Lifecycle & Save As CSV: Tab title displays
<file> [<sheet>]. The tab opens clean (not dirty) and leaves the source workbook untouched. If the source file on disk is modified after snapshot creation, the status bar displaysSnapshot from <file> (source modified since snapshot). Closing an unedited tab closes immediately; edited tabs promptSave changes to <title> before closing?, offering Save As.csvsuggesting<workbook stem>_<sheet>.csvin the workbook directory. XLSX snapshot tabs never write back to.xlsxfiles. Snapshots under 32 MB of CSV reside in memory; larger snapshots stream to a temporary backing file that is automatically deleted when the tab closes or the application exits. - Send to DB Builder: Choose CSV > Send to DB Builder... to import the snapshot into Database Builder. For snapshot tabs without a file path, the target table name is automatically derived from the tab title (e.g.
sales_2026.xlsx [Q1_Sales]→sales_2026_q1_sales; JSON snapshotorders.json [Table]→orders).
Join CSV Files Wizard (Pro)
Use CSV > Join Files... to merge two CSV files on a shared key column using a step-by-step visual wizard. Select files, specify key columns, choose join type (Inner, Left, Right, or Full Outer), and customize column collision suffixes.
Live Tail (Log Monitoring)
Live Tail mode monitors log files actively written by background services. When new lines are appended, FastEditor streams updates smoothly with constant low memory usage. Toggle follow mode or pause scrolling at any time from the toolbar, View menu, or Command Palette to inspect past events.
Log Analysis & Multi-Log Correlation
When opening log files, FastEditor provides specialized analysis and correlation tools:
- Severity Filtering: Filter lines instantly by severity presets: Errors only (
Ctrl+Shift+F8), Incidents (Ctrl+Shift+F9), Production (Ctrl+Shift+F10), or All Levels (Ctrl+Shift+A). - Multi-Log Timestamp Correlation: Correlate disparate log files from multiple open tabs or disk files into a single unified chronological stream (Log > Correlate Multiple Logs...). Multi-line stack traces stay cleanly attached to their parent timestamps.
- Log Navigation: Jump directly to problem areas: Next / Previous Error (
F8/Shift+F8) and Next / Previous Warning (F9/Shift+F9). - Log Analysis & Diagnostics Report: Generate comprehensive diagnostic dashboards (Log > Log Analysis & Diagnostics Report...) analyzing timestamp gaps, frequency spikes, recurring template patterns, and error distributions with Markdown/HTML export.
Markdown Preview
For Markdown files, FastEditor provides editor-only, split, and preview-only layouts. Use the View > Markdown menu, the toolbar buttons, the command palette, or Ctrl+Shift+F1, Ctrl+Shift+F2, and Ctrl+Shift+F3 to switch layouts. Markdown preview is not available in mapped large-file mode, and very large Markdown sources are capped to keep the preview responsive.
4. Search, Filtering and Diff Engine
FastEditor includes high-performance tools for searching, replacing, filtering, and comparing data across files.
Find & Replace (PCRE2 Regular Expressions)
FastEditor uses native PCRE2-16 (Perl Compatible Regular Expressions) for fast, industrial-grade pattern matching with support for capture groups ($1, $2), lookarounds, and Unicode. Standard search shortcuts include:
| Hotkey | Action | Description |
|---|---|---|
Ctrl + F |
Find | Opens the Find bar to search for plain text or regular expressions. |
Ctrl + H |
Replace | Opens the Replace bar for interactive single or batch replacements. |
Ctrl + Shift + H |
Replace All | Replaces all matching occurrences across the document or target scope. |
F3 / Shift + F3 |
Find Next / Previous | Jumps to the next or previous matching occurrence. |
Ctrl + Enter |
Apply Selected Result | Applies replacement to the currently selected search match. |
Search Scopes & Line Ranges
Search and replace operations can target the entire file, the active selection, or a bounded line range. Use Set Line Range (Ctrl+L) and Clear Line Range (Ctrl+Shift+L) to constrain replacements to a specific line interval and prevent accidental edits elsewhere in the document.
Filter As You Type
Press Ctrl+Shift+F (or select Search > Filter-as-you-type) to isolate relevant lines in real time. As you type a pattern, non-matching lines are temporarily hidden from the view. Direct text editing is paused while filtering is active to keep the filtered view consistent.
Find-in-Files
Find-in-Files searches across directories without blocking the user interface. You can filter paths with include/exclude glob masks, inspect matches in a dedicated results panel, jump directly to target lines, and apply bulk replacements after reviewing changes.
Side-by-Side Diff
FastEditor can compare large files asynchronously and display a synchronized side-by-side diff (Tools > Diff > Side-by-Side Diff View... or Ctrl+Shift+D for Diff With File...). Use Next Hunk (F7) and Previous Hunk (Shift+F7) to navigate between changes.
Go to Line & Navigation
Press Ctrl + G (or choose Search > Go to Line...) to open the jump dialog. Enter any 1-based line number to instantly scroll the viewport and position the caret at the start of that line.
Bookmarks
FastEditor supports in-memory per-document line bookmarks with visual marker badges rendered directly in the line gutter:
| Hotkey | Command | Description |
|---|---|---|
Ctrl + F2 |
Toggle Bookmark | Sets or clears a bookmark marker on the current line. |
Alt + F2 |
Next Bookmark | Jumps to the next bookmark in the file with wrap-around. |
Alt + Shift + F2 |
Previous Bookmark | Jumps to the previous bookmark in the file with wrap-around. |
| Menu | Clear All Bookmarks | Removes all bookmarks from the active document (Edit > Bookmarks > Clear All Bookmarks). |
5. Automation, Macros and Scripting
FastEditor provides built-in macro recording and an embedded JavaScript engine for automating repetitive editing workflows.
Macro Recording and Playback
| Hotkey | Command | Description |
|---|---|---|
Ctrl + Shift + R |
Start / Stop Recording | Toggles macro recording mode for commands, caret movements, and text edits. |
Ctrl + Shift + M |
Play Last Macro | Replays the most recently recorded macro sequence. |
- Macro Repeat: Use Tools > Macro > Set Macro Repeat... to execute a macro multiple times in succession.
- Save & Load (.gmacro): Save macro recordings as
.gmacrofiles and load them in future sessions via Save Macro... / Load Macro.... - Macro Hotkeys: Assign custom keyboard shortcuts to saved macros via Tools > Macro > Set Macro Hotkey.... Ctrl+Alt combinations are not accepted because they conflict with AltGr on many keyboard layouts; a saved Ctrl+Alt hotkey is ignored.
JavaScript Scripting & Macro Conversion (QuickJS-NG)
FastEditor embeds a fast QuickJS-NG (ES2023) engine, allowing users to write and run full JavaScript scripts to automate complex file transformations:
- Convert Macro to Script: Select Tools > Macro > Show Last Macro as Script to immediately generate equivalent JavaScript code from your last recorded macro actions.
- Run Scripts: Use Tools > Macro > Run Script... to execute JavaScript files against the active document.
- Scripts Directory: Access your script library with Tools > Macro > Open Scripts Folder.
- Assign Script Hotkeys: Bind frequently used JavaScript scripts to custom keyboard shortcuts with Tools > Macro > Assign Script Hotkey.... Ctrl+Alt combinations are not accepted because they conflict with AltGr on many keyboard layouts; a saved Ctrl+Alt hotkey is ignored.
Plugins & Extensibility
FastEditor features a lightweight, sandboxed JavaScript plugin architecture to extend editor capabilities without native compilation:
- Browse Plugin Catalog: Open Help > Open Plugin Catalog (or Tools > Plugins > Browse Plugin Catalog...) to discover and install plugins.
- Custom Visual Highlighters: Install domain-specific visual line and gutter highlighters (e.g.
security-cve-highlighterfor instant CVE and security advisory detection). - Custom Exporters: Extend export dialogs and CLI pipelines with custom data formatters and streaming encoders.
6. Configuration Structure (settings.json)
FastEditor stores preferences and theme settings in a JSON configuration file named settings.json.
Location, Portability, and License Binding
The editor follows a "portable-first" logic:
- Portable Mode: If
settings.jsonis found in the same directory asFastEditor.exe(pre-created as{}inFastEditor-Portable-x64.zip), FastEditor runs in Portable Mode and stores all per-user data next to the executable:settings.json,license.dat(including trial state),fm_journal\,Scripts\,plugins\, andrecipes\. If the portable directory is read-only, writes fall back cleanly to%APPDATA%\FastEditor. - Standard Mode: Otherwise, configuration and per-user data are stored in
%APPDATA%\FastEditor\on Windows or~/.config/FastEditor/on Unix-like systems. - Machine-Bound Licensing & Portable Multi-PC Support: Each license activation is bound to the computer via a salted SHA-256 hash of the machine GUID. A single
license.datstores up to 3 machine activations so a portable USB folder works seamlessly across up to 3 PCs. Once a computer has been activated online, the license works offline on that computer for up to 30 days; on a computer that has not yet been activated, FastEditor starts in Core mode until connected to the internet. Use Help > Deactivate This PC to free a slot for another computer (removing only the current PC's entry while keeping other PCs' entries intact). Existinglicense.datfiles from versions ≤ 1.2.8 are migrated automatically in place on first run without prompting or re-activating (their legacy Polar activation remains unconditioned on Polar). - Trial Reset Protection: The 14-day trial records an HMAC-protected start marker in
HKCU\Software\FastEditor\Stateper Windows user (used in both Standard and Portable Mode) so deletinglicense.dator deactivating a license does not restart the trial. - Diagnostic Logs: FastEditor does not write diagnostic log files by default. Setting the environment variable
FASTEDITOR_DIAG_LOG=1before launching FastEditor writes diagnostic logs to thelogs\subfolder of the active user data directory (%APPDATA%\FastEditor\logs\in Standard Mode, orlogs\next toFastEditor.exein Portable Mode).
Key Configuration Groups
| Group | Description |
|---|---|
Editor |
Font settings, wrap modes, tab stop widths, indent guide display, Markdown preview wrapping, and default Markdown mode. |
Theme |
Visual color definitions for the text canvas, line numbers, caret, selections, tabs, toolbar, command palette, CSV grid, diff viewer, and syntax tokens. |
AI |
Local LLM configuration: EndpointUrl, ModelName, Temperature, TimeoutSec, ApiKey, and SystemPrompt. |
recent_files |
An array of recently opened absolute file paths. Also stores favorite_files and sql_history. |
Language
FastEditor's user interface is available in the 24 official EU languages. Menus, context menus, toolbar tooltips, the Command Palette, and the File Manager keybar are translated. Dialogs and help documentation remain in English.
The display language is chosen in Tools > Preferences... (Ctrl+,), under Language. The default is English; the entry matching your Windows language is marked. Language changes take effect after restarting FastEditor.
7. File Manager
FastEditor includes a built-in, two-panel, Total Commander-style file manager for local filesystem management, remote FTP, FTPS, and SFTP operations, and directory synchronization. It offers keyboard-centric navigation, background transfers, conflict handling, and seamless integration with the editor and DB Builder.
Starting the File Manager
You can launch the File Manager using either of the following methods:
- Tools Menu: Select Tools > File Manager (or press
Ctrl+Shift+Pand choose File Manager from the Command Palette). - Command Line: Start FastEditor with the mode switch:
FastEditor.exe --mode=fm.
Panels and Navigation
The File Manager features two side-by-side file list panels (Left and Right). Each panel independently displays files and directories with columns for name, extension, size, and last modification timestamp.
- Switch Active Panel: Press
Tabto alternate focus between the left and right panels. - Open Directory / Run: Press
Enteror double-click a folder to navigate into it. Selecting..navigates to the parent directory. PressingBackspacealso navigates to the parent directory. - Drive & Connection Selector: Press
Alt + F1to change the drive or connection for the left panel, orAlt + F2for the right panel. The popup menu lists all local and network drives as well as an FTP… entry for remote connections. - Selection: Press
InsertorSpaceto select or deselect files and folders. PressingInsertautomatically advances the cursor to the next item.
Panel folders, sort column, sort direction (indicated by ▴ / ▾ in the column header), and filter masks are remembered per panel across restarts. Turning off “Remember panel folders on exit” in F9 Options keeps the folders that were last saved and starts with the left panel active. If a saved network folder is not available on start, the panel opens the home folder instead.
File Manager Options (F9)
Press F9 (or click 9 Options on the key bar) to configure File Manager behavior:
- Panels:
- Remember panel folders on exit: Saves the left and right local folders and active panel when closing the File Manager (enabled by default).
- Show hidden and system files (
Ctrl+H): Shows or hides files and folders withFILE_ATTRIBUTE_HIDDENorFILE_ATTRIBUTE_SYSTEMon local drives, and dotfiles (names starting with., except..) on FTP and SFTP panels (disabled by default). When shown, hidden entries are rendered in a dimmed color. Hiding applies only to the panel list display, quick-search, and+select-all; directory enumeration, recursive copy/move/delete,Alt+F7search, andF2folder synchronization always include hidden items inside operated folders.
- Open files (When pressing Enter on a file):
- Open in FastEditor (edit): Default. Opens files in FastEditor for editing (
.sqliteand.dbopen in DB Builder). - View read-only (F3): Opens files in FastEditor in read-only viewer mode (
--view;.sqliteand.dbstill open in DB Builder). - Open with Windows default program: Opens regular documents and media with their associated Windows application via the shell, while enforcing built-in safety rules:
.sqliteand.dbalways open in DB Builder; script files (.bat,.cmd,.ps1,.psm1,.vbs,.vbe,.js,.jse,.wsf,.wsh,.reg) always open in the FastEditor text editor and are never executed; executable, installer, and link files (.exe,.com,.scr,.pif,.msi,.msp,.cpl,.lnk,.url,.appref-ms) always prompt for confirmation (Run <name>?, with Cancel as the default button) before launching. ExplicitF3(View) andF4(Edit) keys always keep their direct meaning regardless of this setting.
- Open in FastEditor (edit): Default. Opens files in FastEditor for editing (
- Confirmations:
- Individual toggles to confirm before Copy (
F5), Move (F6), Delete to Recycle Bin (F8), and Permanent delete (Shift+F8) (all enabled by default). When turned off, the operation starts immediately using the opposite panel folder as the default destination. - Mandatory safety prompts: Even when confirmation checkboxes are turned off, FastEditor always shows the confirmation dialog when
F8would result in a permanent deletion (such as on an FTP or SFTP panel or when paths exceed 248 characters and cannot use the Recycle Bin), when Copy/Move has the same source and destination folder or an unreachable target folder, when renaming withShift+F6, and when a destination file conflict occurs.
- Individual toggles to confirm before Copy (
Key Bar and Keyboard Shortcuts
The bottom key bar provides quick reference and one-click access to standard file operations:
| Hotkey | Command | Description |
|---|---|---|
F1 |
Help | Opens the FastEditor Help documentation for the File Manager. |
F3 |
View | Opens the highlighted file in FastEditor in read-only mode. |
F4 |
Edit | Opens the file in FastEditor for editing. SQLite database files open in DB Builder. |
F5 |
Copy | Copies selected files and directories to the destination panel with background progress and collision handling. |
F6 |
Move | Moves selected files and directories to the opposite panel. |
Shift + F6 |
Rename | Renames the highlighted item in place. |
F7 |
New Folder | Prompts for a folder name and creates a new directory in the active panel. |
F8 |
Delete | Deletes selected files or folders to the Windows Recycle Bin (local only). |
Shift + F8 |
Permanent Delete | Permanently deletes selected items without sending them to the Recycle Bin (after confirmation). |
F9 |
Options | Opens the File Manager Options dialog (panel folder persistence, hidden/system files, Enter action on files, and operation confirmations). |
Ctrl + H |
Hidden Files | Toggles displaying hidden and system files in both panels and saves the setting immediately. |
F10 |
Quit | Exits the File Manager and returns to the editor or closes the window. |
Alt + F1 / Alt + F2 |
Drive / FTP List | Opens the drive and remote FTP connection selection menu for the left / right panel. |
Alt + F7 |
Search | Opens the advanced file search dialog across panels and subdirectories. |
F2 |
Synchronize | Opens the folder synchronization dialog (FastEditor Pro). |
Ctrl + S |
Quick Filter | Toggles the active panel quick filter input box. |
Ctrl + C |
Copy Paths | Copies the full paths of selected items to the clipboard. |
Ctrl + F |
Filter Mask | Sets a filename display filter mask (e.g. *.log or *.pbi;*.pb). |
Ctrl + Shift + F |
Disconnect FTP | Disconnects the active panel from the remote FTP server and returns it to its last local directory. |
Ctrl + R |
Refresh | Refreshes the active panel directory listing from disk or server. |
Insert / Space |
Select / Deselect | Toggles selection of the current item; Insert advances down one row. |
Tab |
Switch Panel | Moves focus between the left and right panels. |
Quick-Search and File Masks
FastEditor makes finding files within large directories effortless:
- Quick-Search: Start typing any alphanumeric characters while browsing a panel. The cursor immediately jumps to the first matching entry. Pressing
Esccancels quick-search. - Panel Filter Masks: Press
Ctrl + Fto apply a wildcard mask (e.g.*.txtor*.csv). Only matching files remain visible in the active panel. Use*.*or clear the mask to restore the full directory listing.
Advanced Search Options (Alt + F7)
Press Alt + F7 to open the multi-threaded File Search dialog. Capabilities include:
- Name & Wildcards: Search by exact filename, extensions, or wildcard patterns across entire subfolder hierarchies.
- Date and Size Constraints: Filter results by file modification date range and minimum/maximum byte size thresholds.
- Content Search: Search for specific text strings or hex bytes inside files, with optional case sensitivity or PCRE2 regular expression pattern matching.
- Direct Action: Jump directly to matched files in the panel, or view/edit matches instantly.
FTP, FTPS & SFTP Remote Connections
FastEditor integrates high-performance remote FTP, FTPS, and SFTP (SSH File Transfer Protocol over SSH, default port 22) connectivity powered by bundled libcurl and libssh2:
- Connection Profiles: Configure saved connection profiles with protocol (FTP / FTPS on default port
21or SFTP (SSH) on default port22), host, port, remote path, user credentials, SSH private key file, and passive mode settings. Saved passwords and key passphrases are encrypted on disk using Windows DPAPI (leaving Save password or Save passphrase unchecked keeps the secret in memory for the current session only). - SFTP Host Key Trust (TOFU) & Verification: SFTP connections verify the server's SSH host key against a per-profile SHA-256 fingerprint pin before sending any authentication credentials. When connecting to a server for the first time (unpinned profile), or if the server's host key no longer matches the stored pin, FastEditor aborts the pre-authentication probe and opens the modal SFTP Host Key Trust dialog showing the host, port, key algorithm (such as
ssh-ed25519,ecdsa-sha2-nistp256, orssh-rsa), and SHA-256 fingerprint (SHA256:<base64>), with Cancel as the default button:- New host key (first connection): Offers Trust and save key, which pins the server's SHA-256 fingerprint in the profile and proceeds with the connection, or Cancel, which aborts without sending credentials or modifying the profile.
- Host key changed (pin mismatch): Displays the stored fingerprint alongside the server's current fingerprint and warns that a changed host key can indicate either a legitimate server reinstall/key rotation or a man-in-the-middle (MITM) interception. Choosing Replace stored key updates the saved pin only after explicit confirmation; choosing Cancel aborts immediately with zero credentials transmitted.
- SFTP Authentication & Private Key Formats: SFTP supports password authentication and SSH private key file authentication (selecting a key file uses public-key authentication only and never silently falls back to password authentication). When a matching
<keyfile>.pubfile is present alongside the private key, FastEditor automatically supplies it tolibcurl; otherwise, the public key is derived in memory without writing anything to disk. Supported private key formats with the bundledlibcurl 8.22.0/libssh2 1.11.1/LibreSSL 4.3.2runtime are OpenSSH Ed25519 and OpenSSH ECDSA keys (-----BEGIN OPENSSH PRIVATE KEY-----) and PEM / PKCS#8 ECDSA keys (-----BEGIN EC PRIVATE KEY-----or-----BEGIN PRIVATE KEY-----). FastEditor inspects the key file before connecting and refuses unsupported formats with clear guidance:- PuTTY
.ppkkeys: Refused before connection; convert to OpenSSH format withputtygen key.ppk -O private-openssh -o id_ed25519_sftpor create a separate key withssh-keygen -t ed25519 -f id_ed25519_sftp. - RSA private keys (PEM, PKCS#8, or OpenSSH
ssh-rsa): Refused before connection because RSA private-key signing causes a heap fault in the bundledlibssh2 1.11.1/LibreSSL 4.3.2runtime; create a separate dedicated Ed25519 or ECDSA key (for example,ssh-keygen -t ed25519 -f id_ed25519_sftp). - Passphrase-encrypted private keys: Refused before connection because the bundled
libssh2 1.11.1/LibreSSL 4.3.2runtime cannot decrypt passphrase-protected OpenSSH or PEM/PKCS#8 private keys; create a separate dedicated key for the SFTP profile (for example,ssh-keygen -t ed25519 -f id_ed25519_sftp).
- PuTTY
- FTPS / TLS Encryption: Full support for explicit FTPS (AUTH TLS) to ensure end-to-end encrypted control and data channels.
- Certificate Trust & Verification: When connecting via FTPS to a server whose certificate cannot be verified, FastEditor prevents transmitting login credentials and presents an interactive Certificate Trust dialog. The certificate probe operates strictly at the TLS handshake layer—it never sends login credentials (
PASS) and aborts immediately upon handshake completion. The dialog displays the Subject Common Name (CN), Issuer (including Organization), validity date range, Subject Alternative Names (SANs, formatted with one name per line), SHA-256 certificate fingerprint, and Subject Public Key Info (SPKI) pin. Three certificate states are distinguished:- Untrusted Issuer: The certificate is self-signed or signed by an untrusted Certificate Authority.
- Hostname Mismatch: The certificate is signed by a valid, trusted CA, but does not cover the connection hostname (evaluated per RFC 6125 wildcard matching rules).
- Undetermined: A pre-TLS network or transport error occurred before the certificate could be examined.
- Trust this certificate (or Replace stored certificate): Pins the certificate's public key (SPKI SHA-256). For self-signed or untrusted-issuer certificates, it stores the pin and marks the profile to authenticate against the pinned key. If the server later changes or renews its cryptographic key, FastEditor detects the pin mismatch and re-prompts you before sending any credentials. This action is disabled when the certificate state is undetermined.
- Don't verify hostname: Only enabled when the certificate chain is signed by a valid, trusted Certificate Authority but does not match the server's domain name (common in shared hosting). This waives domain name verification for that profile while strictly preserving CA chain validation. This option is disabled if the CA chain itself is invalid, expired, or undetermined.
- Retry: Displayed and enabled when an undetermined network or connection error prevents certificate examination, allowing you to retry the connection probe immediately.
- Cancel: Aborts the connection attempt immediately. No credentials (
USER/PASS) are transmitted, and profile settings remain completely untouched.
- Filename Encodings: Supports both standard UTF-8 and legacy CP1251 (Cyrillic) server encodings, preventing garbled filenames when communicating with legacy systems.
- Background Transfers & Resume: Uploads and downloads run asynchronously with real-time transfer progress, speed metrics, cancel controls, and automatic resume of partially transferred files.
Folder Synchronization (FastEditor Pro)
Press F2 (or Ctrl + S) to open the bidirectional Folder Synchronization tool between the two panels (Local ↔ Local or Local ↔ FTP/SFTP):
- Comprehensive Comparison: Compares directory trees by relative path, exact size, and high-precision timestamps (with a 2-second tolerance window to account for FAT/FTP time step differences). Files are classified into Left Only, Right Only, Newer Left, Newer Right, Equal, or Different.
- Mandatory Preview: Before any file operations take place, an interactive preview table displays every file difference, source/target timestamps, file sizes, and proposed copy direction arrows (
→,←, or skip). - Interactive Controls: Filter the diff table by class, toggle all or individual items, and reverse sync directions per item.
- Delete Synchronized Files: An optional Deletes checkbox allows removing orphaned destination files. For safety, this requires explicit confirmation before execution.
Crash Recovery & Cleanup Notices
FastEditor protects against data corruption during transfer or synchronization interruptions:
- Staging & Directory Sweeps: In-flight transfers stage through temporary files in the staging directory (
xfer_*.tmp) before being committed to the destination on completion. Orphaned staging files from interrupted sessions are cleaned up automatically via directory sweep. - Crash Recovery & Cleanup: Active transfer operations maintain state in a crash journal folder (
%APPDATA%\FastEditor\fm_journal\). If the application is closed abruptly during a transfer, FastEditor detects unfinalized operations on next startup, automatically removes incomplete local destination files while leaving source files intact, and displays a recovery notice summarizing the cleaned items.
- No Elevation / UAC: The File Manager runs under standard user privileges. Modifying protected system directories (such as
C:\WindowsorC:\Program Files) will fail gracefully with an access error rather than triggering a UAC elevation prompt. - No FXP (Site-to-Site): Direct transfer between two remote FTP/FTPS/SFTP servers is not supported. Remote operations require one panel to be a local filesystem path.
- No Archive Browsing: Compressed archives (
.zip,.tar,.7z) are treated as standard files and cannot be browsed as virtual folders inside the panels. - No Remote Recycle Bin: Deleting files or folders on a remote FTP, FTPS, or SFTP server is permanent; the Windows Recycle Bin is only available for local filesystem deletions.
- Remote File Viewing / Editing (F3 / F4): Viewing (
F3) and editing (F4) are restricted to local filesystem panels. Remote FTP, FTPS, and SFTP files cannot be directly opened in the editor without first downloading or staging them to a local panel.
8. Database Builder
Database Builder is a built-in visual database environment for SQLite files. It provides spreadsheet and card layouts, visual table and relationship design, multi-request find queries, calculated fields, automation scripts, and paginated report printing.
Opening Database Builder
You can open Database Builder from within FastEditor or directly from the command line:
- Tools & File Menu: Select Tools > Database Builder... from the editor window, or select File > Open Demo Database or File > Open Small Business Demo from within Database Builder.
- File Manager: Press
EnterorF4on any.sqliteor.dbfile containing a Database Builder metadata marker. - Command Line: Launch
FastEditor.exe --mode=dbto open an empty workspace, orFastEditor.exe --demoto open the bundled demonstration database. You can also pass a SQLite database path as an argument. - Help (
F1): PressF1(or select Help > Documentation) inside Database Builder to open the local Help documentation directly at the Database Builder section.
View Modes
Database Builder provides three view modes for working with tables:
- Grid View: Displays table records in a spreadsheet grid with inline editing, resizable columns, sortable headers, and cell-level keyboard navigation.
- Form View: Displays records as visual cards. Supports text inputs, multi-line notes, date pickers, dropdown lists, foreign-key lookups, portals, and media attachment boxes. When a table's active layout is configured as a List layout, Form View displays a continuous vertical scrolling list with repeated record rows.
- Toggle View Mode (
Ctrl+T): Toggles between Grid View and Form View. When toggling into Form View for a table with a List layout, the continuous list is shown; toggling back to Grid View preserves your selected row. - Layout Designer (
Ctrl+L): A visual editor for arranging form layouts. Select, drag, resize, align, group, and adjust the stacking order of form widgets. PressDel(or select Edit > Delete Widget) to delete selected widgets (when typing in a text box,Deldeletes text instead). Layout modifications support multi-level Undo (Ctrl+Z) and Redo (Ctrl+YorCtrl+Shift+Z), available exclusively while in Layout Designer.
Creating Tables and Fields
Database Builder allows you to create SQLite databases, add tables, and configure schemas:
- Creating a Database: Select File > New Database... to specify where to save a new SQLite database file in the New SQLite Database dialog. When opened, an empty database displays the notice: "This database has no tables yet. Choose Table → New Table... to create one."
- Creating a Table: Select Table > New Table... to open the New Table dialog. Enter the name in the Table name: field. The dialog notes: "The table is created with an ID field. Add your own fields in the next step." Every new table is initialized with an
id INTEGER PRIMARY KEY AUTOINCREMENTcolumn. - Table Naming Rules: Names entered when creating or renaming tables are validated against strict database rules. An error is shown if a name violates any of the following constraints:
"Table name cannot be empty.""Table name cannot start with reserved prefix '_'.""Table name cannot start with reserved prefix 'sqlite_'.""Table name must start with a letter (A-Z or a-z).""Table name contains invalid character '<c>'. Only letters, numbers, and underscores are allowed.""Table name cannot be a SQL keyword ('<name>').""A table named '<name>' already exists."or"A view named '<name>' already exists."
- Table Settings: Select Table > Table Settings... to open the Table Settings - <table> dialog:
- Display name: Enter an optional friendly name (hint: "Leave empty to use the table name."). The display name is shown in the window title (
"DB Builder - <display name>") and in the table selector dropdown. - Description: An optional table description displayed as a tooltip on the table selector.
- Serial Numbering: When a column is configured with auto-enter serial numbering, the dialog displays Serial Numbering (Field: <f>): with options for Prefix:, Minimum digits:, Next number:, Increment:, and Next value preview:. The dialog notes: "Changing prefix or width affects new records only. Existing records are never rewritten." If no column uses serial numbering, the dialog displays "This table has no field configured with auto-enter serial numbering." Serial numbers are padded with leading zeros up to the minimum width; numbers requiring more digits are never truncated. Databases created with earlier versions are upgraded automatically when opened.
- Display name: Enter an optional friendly name (hint: "Leave empty to use the table name."). The display name is shown in the window title (
Editing Schema, Renaming, and Deleting Tables
To design or modify table schemas, select Table > Edit Schema... (Ctrl+Shift+S). The dialog top row provides the Table Name: field and the Delete Table... button. All structural changes are committed when you click Apply Changes:
- Renaming a Table: Enter a new name into the Table Name: field and click Apply Changes. The new name is validated against the table naming rules. A backup copy of the database file is made before renaming. Applying the rename automatically updates the table's fields, layouts, relationships, attachments, import maps, value lists, layout and script references, and formulas.
- Deleting a Table: Click Delete Table.... The dialog asks: "Are you sure you want to permanently delete table '<name>'? This action cannot be undone once applied." Upon confirmation, the status line indicates: "Table marked for deletion. Click 'Apply Changes' to confirm." A backup copy is created before the table is permanently deleted on Apply Changes.
- Deletion Dependencies: If other database objects depend on the table, deletion is refused on Apply Changes and the first blocking reason is displayed in the status line:
"Table '<t>' has a foreign key referencing '<table>' (column '<c>')""Value list '<n>' takes values from table '<table>'"or"Related value list '<n>' takes values from table '<table>'""Calculated field '<t>.<c>' refers to '<table>' (formula: ...)"- Layouts containing a portal that uses the table.
- Adding and Modifying Columns: Use + Add Calculated... to add calculated columns. For generated
VIRTUALorSTOREDcolumns, the formula is read-only (remove and re-add the column to alter its expression). For calculated fields (CALC), click Edit Formula... to modify the formula. When adding aUNIQUEconstraint to an existing column, the database pre-checks existing records; if duplicates exist, the modification is refused with:"Cannot add UNIQUE to "<col>": <n> values occur more than once (e.g. ...).". - SQLite Storage Types:
- TEXT: Used for general text, notes, and ISO 8601 date/time values (such as
2026-09-20 14:30:00). Because SQLite does not have native date storage types, dates and timestamps are stored and queried as text. - INTEGER: Used for whole numbers, auto-increment primary keys, and boolean values (stored as
0or1). - REAL: Used for floating-point numeric and monetary decimal values.
- BLOB: Used for binary media files and documents managed by the attachment engine.
- TEXT: Used for general text, notes, and ISO 8601 date/time values (such as
Managing Records
Use standard menu actions and keyboard shortcuts to navigate and edit table records:
- New Record: Press
Ctrl+Nto append a new blank record to the active table. - Duplicate Record: Press
Ctrl+D(Records > Duplicate Record) to duplicate the selected record and its column values. - Delete Record: Press
Ctrl+Delto delete the active record. A confirmation dialog appears before removal. - Commit Edits: Press
Ctrl+Enter(Records > Commit Record) to save staged field modifications to the database file. - Revert Edits and Escape Discipline: Press
Esc(Records > Revert Record) to discard unsaved edits. In Form view, the firstEsccancels editing in the active field; a secondEscrestores the entire record to its saved state. In Grid view,Esccancels active cell editing, while a subsequentEscreverts the row. When keyboard focus is inside a child portal, pressingEscreverts only the active portal row. - Automatic Commit: Pending edits are saved automatically before moving to another record, switching tables or layouts, toggling view modes, entering Find mode, duplicating a record, opening Table > Field Options... or Table > Edit Schema..., importing records, closing the database or exiting, and when a button script switches tables. If auto-commit fails validation, a
"DB Builder - Validation Error"alert appears, the view stays on the record, and edits are kept. - Constraint Validation Messages: When saving records, values are validated against table rules and database constraints. If an edit violates a constraint, a specific error message is displayed:
- Rule or CHECK:
"Field '<f>' violates rule (<expr>)."(or"Record violates rule (<expr>).") - NOT NULL:
"Field '<f>' cannot be empty (NOT NULL constraint)." - UNIQUE:
""<v>" already exists in <f>."(or"Field '<f>' must be unique. A record with this value already exists.") - Foreign Key:
"Field '<f>' references a record in '<t>' that does not exist."
- Rule or CHECK:
Find Mode
Find Mode provides form-based record querying without writing SQL statements. Press Ctrl+F to switch the form into search criteria entry mode.
Type matching criteria into any field. Supported search operators include:
| Operator | Meaning | Example |
|---|---|---|
= |
Exact match | =California |
<, > |
Less than, Greater than | > 500 |
<=, >= |
Less than or equal, Greater than or equal | <= 100 |
.. |
Range between two values | 2026-01-01..2026-06-30 |
* |
Zero or more characters (wildcard) | *corp* |
Press Ctrl+N while in Find Mode to add additional find requests (combined using logical OR). Press Enter to execute the search, or press Esc to cancel and restore all records.
Relationships and Portals
Select Table > Relationship Graph... (Ctrl+Shift+R) to create visual connections between tables:
- Foreign Key Joins: Link a parent table's primary key to a child table's foreign key column.
- Cascade Deletion: Optionally configure child records to delete automatically when the parent record is deleted.
- Portals: Embed child tables directly inside parent form cards. For example, an order form can display an embedded list of related line items. Use
F6to cycle keyboard focus between the parent form and the child portal.
To place a portal on a form layout, switch to Layout Designer (Ctrl+L) and click Add Portal... (or select Edit > Add Portal...). Adding a portal is available only when the layout's table is the parent of a relationship. The Portal Properties dialog lets you choose the child relationship, select and reorder visible columns, toggle Show header, specify row height in DIPs (minimum 16), configure a sort column and direction, and set row permissions: Allow adding rows, Allow editing, and Allow deleting rows.
To place static text or merge labels on a form layout, switch to Layout Designer (Ctrl+L) and click Add Text... (or select Edit > Add Text...). The Text Properties dialog lets you enter multi-line text with word wrapping, and use Insert field: to insert field merge tokens (such as <<field_name>>) that evaluate dynamically in Form View.
To place a button on a form layout, switch to Layout Designer (Ctrl+L) and click Add Button... (or select Edit > Add Button...). The Button Properties dialog lets you specify a button caption and configure an Action: Run script (to trigger a database automation script), Go to layout (to switch to another layout), or Open report (open_report, to open a saved report layout in the Report Viewer; the target dropdown lists only report layouts in the database). In Form View, clicking a button commits any pending field edits before executing the action, and buttons are included in keyboard Tab navigation order.
Value Lists, Validation, and Formatting
Select Table > Field Options... (Shift+F2) to configure automated field behavior and control rendering:
- Edit As Control Types: Depending on the field type, fields can be configured to edit as:
Automatic,Text,Multiline text,Date,Date and time,Number,Checkbox,Currency,Dropdown list,Radio buttons, orCheckbox set. When switching a whole-number (INTEGER) column with existing values toCurrency, DB Builder asks whether to convert whole amounts to cents (multiplying all values by 100 after creating a backup) or keep existing values as cents. - Value Lists: Under Value list:, select an existing list or click Manage lists... to define choice sources. The Manage Lists dialog offers three sources under Source::
- Values entered here: Enter items into Values (one per line):. Check Show different text than the stored value to use pair line syntax (
stored | shown text, split at the first vertical bar). Entries containing commas in the stored value or duplicate keys are refused with:"Commas are not supported in stored values (found in '<v>')."and"Duplicate stored value: '<v>'.". - Values from a field: Populate options dynamically from another table column by selecting Table:, Field:, and Text shown:, with an interactive Preview:.
- Values from related records: Populate options through relationships by specifying Table:, Field:, Text shown:, and Only records where: <field> equals record's <field>.
- Values entered here: Enter items into Values (one per line):. Check Show different text than the stored value to use pair line syntax (
- Display Text in Grids and Portals: In Grid view, List view, and embedded child portals, cells automatically display the value list's shown text or the related record's display field instead of raw stored keys. If a record holds a stored value that is not in the value list, the value is kept unchanged; in Form view the field shows the tooltip
"Stored value kept as is: <value>". - Checkbox Set Searching: In Find Mode, selecting options in a checkbox set creates one search pattern per checked item joined with
AND, finding records that contain all of the selected options. - Refused Input and Error Highlighting: Input that fails validation is kept without being saved so you can correct it. In Grid view, the cell displays the entered text with a red bottom bar; while actively editing, the cell turns red and shows the validation error as a tooltip. In Form view, the field preserves the entered text in red.
- Date Validation: Date inputs must conform to ISO 8601 formatting. Invalid date values are rejected with:
"Invalid date/time value '<v>' for column '<c>'. Expected ISO-8601 (YYYY-MM-DD).". - Auto-Enter: Automatically populate fields on record creation or modification with timestamps, account names, serial numbers, or calculation expressions.
- Validation: Enforce data integrity with mandatory non-empty rules, unique constraints, numeric ranges (
min..max), value list membership, and custom calculation expressions. Set custom alert messages when validation fails. - Conditional Formatting: Define rules that apply custom text colors or background highlights when cell values satisfy specified conditions.
- Date Functions in Expressions: Calculation fields, report expressions, report filters, and report group expressions support built-in ISO 8601 date functions (with
,or;argument separators):Today(): Returns the current local date asYYYY-MM-DDtext (same source as@CurrentDate). In SQL queries it is passed as a bound parameter.Today()is allowed in virtual calculation fields, report expressions, report filters, and report group expressions, and is refused in stored SQL-generated columns or schema DDL because SQLite would reject or freeze the date at insert time.DaysBetween(a; b): Whole days from dateato dateb(b - a; negative whenbis earlier thana). For example,DaysBetween(due_date; Today())computes days overdue for an unpaid invoice. Empty or invalid date inputs return empty rather than an error.Year(d)andMonth(d): Return the integer year and month (1–12) of dated.YearMonth(d): Returns the month of datedasYYYY-MMtext (for example,YearMonth(issue_date)returns"2026-09").
- Two-Link Related Fields (
rel1::rel2::column): Calculation fields, report expressions, and report filters can traverse up to two many-to-one relationships towards parent tables—for example,invoices::customers::nameorinvoices::customers::cityoninvoice_lines(child → parent → grandparent). Report field widgets ("type": "field") may also name a related field directly (such as"column_name": "invoices::number"or"invoices::customers::name"). Limits: At most two relationship links are allowed (three or more links such asa::b::c::dare refused), every link must move in the many-to-one direction towards a parent table (a link towards child rows without an aggregate function is refused), aggregates can traverse only one relationship link towards child records, and if more than one foreign key connects the same two tables, referencing the target by table name is refused as ambiguous—specify the explicit relationship ID (rel_id::column) instead.
Exact Number Storage: Number fields keep values exactly—whole numbers up to ±9,223,372,036,854,775,807, decimal numbers up to 15 significant digits, and currency amounts up to their configured decimal places; any value outside these limits is refused with a validation message rather than rounded or truncated.
Global Variables
Database Builder supports session-scoped and file-persisted global variables prefixed with $$ (such as $$CurrentTaxRate). Single-dollar variables ($var) are reserved for local script variables. Manage global variables by selecting Table > Global Variables... (Shift+F3) or set them within scripts. Global variables are accessible across layouts and calculations, but cannot be used in table-level SQL-generated columns.
Script Builder and Debugger
Database Builder includes an integrated visual script engine and debugger:
- Script Builder (
Shift+F4): Construct sequential automation routines from action steps including navigation, record creation, field assignment, conditional checks (If/Else), loops, opening reports (openreport/db.openReport(reportName)), and user dialog prompts. - Script Debugger (
Shift+F5): Step through scripts line-by-line, set breakpoints, and view real-time values of local variables ($var) and global variables ($$var).
Deleting All Records of a Table Safely
Scripts can clear all records from a table using the deleteAll API:
- API Syntax: Call
db.table("Orders").deleteAll()ordb.deleteAll("Orders")(ordb.deleteAll()for the currently active table). In visual action trees, use theDelete All Recordsaction step. - Safety and Confirmation: The method always displays a modal confirmation dialog specifying the target table, the number of records to be deleted, the number of associated attachments, and any affected child rows. Cancel is always the default button; deletion cannot be defaulted or skipped with a force flag. If the user cancels, the method returns
0and setsdb.cancelled = true. - Single Transaction: Deletions occur within a single atomic database transaction. If any error occurs, the entire operation is rolled back and no records or attachments are partially deleted.
- Foreign Key Protection: If any child table references the target table with
RESTRICTorNO ACTION(including default foreign key constraints) and contains referencing records, the call is immediately refused and deletes nothing, reporting the blocking child table and record count. If child relationships specifyCASCADEorSET NULL, the affected records are updated accordingly and their count is included in the confirmation dialog. - Attachments: Embedded attachment records stored in the database catalog (
_dbb_attachments) are safely removed within the transaction. Linked external files on disk are never deleted. - Triggers: Bulk table deletion fires no per-record triggers.
Data Import and Export
Import and export records without manual SQL commands:
Import into New Table: Choose File > Import into New Table... to create a new table from a CSV or tab-delimited file and import its records in one step (included in FastEditor Core). The delimiter (comma, semicolon, or tab) is detected automatically from the header line, both for Import into New Table and for Import Records (Ctrl+I). Column names are sanitized from the header row (an incoming id column is renamed to source_id, SQL keywords receive a _col suffix, and duplicates receive _2, _3, etc.) while original header names are kept as field display labels. Column types are inferred from the first 1,000 data rows: whole numbers become INTEGER and dot-decimal numbers become REAL, while values with leading zeros (such as 007), values with more than 15 digits, decimal-comma values (such as 1,5), and dates stay TEXT. A header-only file creates the table and columns with zero rows. Quoted cells containing line breaks are not supported by the line-by-line importer.
- Import (
Ctrl+I): Import records from CSV or tab-delimited files (delimiter detected automatically from the header line). A column mapping dialog matches incoming file fields with existing database columns. - Export Records: Use File > Export Records > CSV... or File > Export Records > JSON... to export the records currently found in the active table, in their current sort order, including only visible fields (using each field's display label as the header). Value-list fields export their stored database value rather than the display label, and currency fields are written as plain numbers with
.as the decimal separator. CSV files are saved in UTF-8 with a byte-order mark (BOM) for spreadsheet compatibility. - Open Found Set in Editor: Choose Records > Open Found Set in Editor to export the active table's current found set (in its current sort order, visible fields only) to a CSV file and open it in FastEditor for SQL queries, profiling, diffs, or further export. The opened editor tab is an independent CSV copy, so editing or saving it in the editor does not change the database. Copies are stored in
%TEMP%\FastEditor\dbb_export\and matching copies older than 24 hours are removed automatically the next time the command runs. When DB Builder was opened from the editor, the file opens as a new tab in that editor window; when DB Builder was started on its own, it launches a separate FastEditor editor window. - Clone and Compact: Use File > Save a Clone... to export a copy containing schema, layouts, and scripts with all record data emptied. Use File > Save a Compacted Copy... to execute a database compaction and rebuild file indices.
- Database Settings: Select File > Database Settings... to configure database-level preferences, including the Show on open startup layout. Choosing (First table, Grid view) retains the default behavior of opening the first table alphabetically in Grid view, while selecting any specific Form or List layout automatically displays that layout in its matching view mode whenever the database is opened. If the saved startup layout has been deleted, the dialog shows
"The saved startup layout no longer exists."A changed setting takes effect the next time the database is opened. The Currency section configures the per-database currency (two-decimal currencies USD, EUR, GBP, CHF, SEK, NOK, DKK, PLN, and CZK, plus zero-decimal currencies JPY and HUF which have no decimals), the amount display style (code after amount such as15.00 EUR, symbol before amount such as€15.00or¥1500, or symbol after amount such as15.00 €or1 500 Ft), and an optional Use thousands separator toggle with a live preview. Changing between currencies with and without decimals asks whether to convert stored integer amounts (dividing or multiplying by 100 after creating a backup) or keep stored numbers unchanged. Currency formatting applies immediately across Grid view, Form view, and Reports (including currency totals), while editing and CSV/JSON export always use plain numbers without currency codes, symbols, or thousands separators.
Reports and Mailing Labels
Create printable reports and adhesive mailing labels:
- Report Designer (
Shift+F6): Design banded layouts containing title headers, page headers, body data bands, group summaries, and page footers. - Report Viewer (
Shift+F7): Preview paginated report pages on screen with page navigation and zoom controls. - Opening a Report from a Button or Script: You can open any saved report layout directly from a layout button configured with the Open report (
open_report) action, or from a script using the Open Report (openreport) action-tree step or the JavaScript calldb.openReport("Report Name"). Pending edits on the active record are committed first. Which records are shown:- If the report has its own
"filter"expression: the report runs on the whole table with that filter, ignoring the window's current found set. - Otherwise, if the button (or active window) sits on a layout whose table is the report's table: the report uses the current found set of that window.
- Otherwise (the active window is on a different table and the report has no filter): the report runs on all records of the report's table.
- If the report has its own
- Grouping by a Column or an Expression (
"group_expr"): In the Report Designer, double-click a group header band to open Band Properties. A group header can group either by a table column ("group_field") or by a calculation expression ("group_expr", validated with the Check button). For example, setting the group expression toYearMonth(issue_date)oninvoicessorts records by the transpiled SQL expression, breaks groups whenever theYYYY-MMmonth changes, and displays the month in the group header through the existing{group_value}merge placeholder (or a field widget with"column_name": "group_value"). Expressions referencing a cross-table calculated column (such astotal_cents) are refused ingroup_exprjust as in sort rules. Definitions that group by a column omit"group_expr"when saved so existing report definitions round-trip byte-identically. - Start Each Group on a New Page: In the Report Designer, double-click a group header band to open Band Properties and check Start each group on a new page (
"page_break_before": true) so that every group at that level—except the first group of the report—starts on a new page. The report title band stays on page 1 together with the first group (producing no empty first page), page headers and footers render normally on every page with continuous page numbering, and groups spanning more than one page continue onto the next page. - Stored Filter and Sort (Report Properties): In the Report Designer toolbar, click Report Properties... to configure a report-level Filter expression and Sort order:
- Filter: Enter a calculation-style expression (such as
status <> "Paid") and click Check to validate the formula with the expression transpiler; the dialog displaysOKor the exact error message. - Sort: Build an ordered list of
column (asc | desc)sort rules using the column selector, Ascending / Descending direction selector, and the Add, Remove, Up, and Down buttons. Cross-table calculated columns are not offered and are refused with the engine's error message.
"page_break_before","filter", and"sort"to the report JSON only when set, so untouched reports save byte-identically. Records are ordered by group levels first, then the report's"sort"rules, thenrowid. Invalid filter expressions or unsupported sort columns halt pagination and display a clear error message in the Report Viewer. - Filter: Enter a calculation-style expression (such as
- Money Totals: For columns with the
currencywidget stored asINTEGERminor units (cents), including cross-table calculated currency columns such asinvoices.total_cents, report aggregates (sum,min,max) accumulate in exact 64-bit integer minor units without floating-point conversion, andavgis computed from the integer sum and count rounded half away from zero to whole minor units. All four are formatted with the same currency display function as Grid View and Form View (for example,370.00 USD), whilecountstays a plain integer andREALcurrency or standard numeric columns keep two-decimal numeric formatting. - Label Designer (
Shift+F8): Lay out multi-column adhesive label sheets matching standard commercial paper dimensions. - Export and Print (Pro): Opening and viewing reports on screen (including from a layout button or script) works in the free build (FastEditor Core). Exporting reports to PDF files (using the Export PDF... button in the Report Viewer toolbar) and sending pages to physical printers (using the Print... button) require a commercial FastEditor Pro license.
Attachments and Media
Columns declared as Attachment (or SQLite BLOB) store binary documents, images, and files directly within the database. The form displays embedded image thumbnails. Double-clicking an attachment opens it in the default system viewer, and right-clicking allows saving a copy to disk.
Walkthrough: Exploring the Demo Database
FastEditor includes a pre-built demonstration database showcasing relational tables, forms, portals, reports, and scripts. Follow these steps to explore it:
- Open the Demo: Select File > Open Demo Database (or run
FastEditor.exe --demofrom the terminal). FastEditor creates a safe working copy in your temporary directory so you can edit freely without altering the original template. - Browse Contacts in Grid View: The window opens displaying the
contactstable (25 records) in Grid View. Click on column headers to sort by name, company, or date added. - Switch to Form View: Press
Ctrl+T. The display switches toContacts Form, rendering each customer as a record card with contact details. Click Next or pressReturnto browse records. - Inspect Orders and Portals: Select Invoices & Orders from the table selector dropdown at the top left. The form shows order headers (60 records) with customer links and order totals. The portal at the bottom displays related items for each invoice. Press
F6to cycle focus into the portal. - Perform a Find Query: Press
Ctrl+Fto enter Find Mode. Click the Status field, typePending, and pressEnter. The found set updates to show only pending orders. PressEscto restore the full record set. - View Order Line Items and Photos: Select Order Items from the table selector. This table contains 180 records with embedded product photos stored in the database. Double-click a photo thumbnail to open it in your system image viewer.
- Preview Reports: Press
Shift+F7to open the Report Viewer. Preview the pre-configured Invoice Line-Item Report or Orders Summary Report with calculated column totals. (Exporting to PDF via Export PDF... or printing to paper via Print... requires FastEditor Pro). - Inspect Automation Scripts: Press
Shift+F4to open the Script Builder and inspect the pre-configured automation scripts (Demo_Child_AuditandDemo_M4_Master). - Open Layout Designer: Press
Ctrl+Lfrom Form View to open the visual Layout Designer for the form layout. Inspect how fields and portal containers are arranged, then pressCtrl+Lagain to return to data editing.
Small Business Demo Database
In addition to the standard demo, FastEditor includes a second bundled database demonstrating a complete small business invoicing workflow with customers, products, line items, and payment tracking:
- Opening the Demo: Select File > Open Small Business Demo from Database Builder. FastEditor creates an ephemeral working copy in your temporary directory so you can test, modify, and experiment freely without affecting the bundled template.
- Startup Dashboard: The database automatically opens to the Getting started layout, a guided dashboard providing an overview of the business model and one-click navigation buttons to Customers, Products, and Invoices.
- Relational Schema: Five connected tables model a real-world invoicing workflow:
customers: 15 customer accounts with contact details and account history. Includes an embedded portal showing all invoices for the selected customer.products: 12 product catalog items with unit prices stored as integer cents and active/inactive status flags.invoices: 30 customer sales invoices with automated 4-digit serial numbering (INV-1001throughINV-1030), issue and due dates, and status tracking (Draft,Sent,Paid,Overdue). The form features dual portals for line items and payments.invoice_lines: 90 invoice line items referencing products and quantities, featuring SQLite generated stored columns for line totals.payments: 21 payment transactions linked to invoices, tracking payment dates, amounts, and methods (Bank transfer,Card,Cash).
- Integer Currency & Calculated Fields: All currency amounts are stored as integer cents (
unit_price_cents,line_total_cents,amount_cents) to eliminate floating-point rounding drift. Invoices compute total amounts dynamically via cross-table calculation metadata (Sum(invoice_lines::line_total_cents)). - Resetting Demo Data: Use the built-in Clear demo data button on the Getting Started screen (or run the script via Script Builder,
Shift+F4) to reset sample data after confirmation. Reopening File > Open Small Business Demo restores a fresh copy of the original data at any time.
Database Builder Keyboard Shortcuts
| Hotkey | Command | Action |
|---|---|---|
Ctrl + O |
Open Database | Open an existing SQLite database file. |
Ctrl + W |
Close Database | Close the currently active database and return to an empty workspace. |
Ctrl + T |
Toggle View Mode | Switch between Grid View and Form View. |
Ctrl + L |
Layout Designer | Toggle between the visual Layout Designer and Form View. |
Del |
Delete Widget | Delete the selected widget(s) in Layout Designer. |
Ctrl + Shift + Z |
Redo | Redo the previously undone layout action in Layout Designer. |
Ctrl + N |
New Record | Create a new record in the active table, or add a request in Find Mode. |
Ctrl + D |
Duplicate Record | Duplicate the currently selected record and its data. |
Ctrl + Del |
Delete Record | Delete the active record after confirmation. |
Ctrl + Enter |
Commit Record | Save staged field changes to the database. |
Esc |
Revert Record | Discard active field edits, restore record data, or exit Find Mode. |
Ctrl + F |
Find Mode | Switch Form View into multi-criteria query mode. |
F6 |
Cycle Pane | Move keyboard focus between parent form controls and child portals. |
Shift + F2 |
Field Options | Open options, validation, and auto-enter settings for the selected column. |
Shift + F3 |
Global Variables | Open the Global Variables dialog to inspect and manage $$ variables. |
Ctrl + Shift + S |
Edit Schema | Open Table Designer to add tables or alter columns. |
Ctrl + Shift + R |
Relationship Graph | Open visual relationship and foreign key diagram editor. |
Shift + F4 |
Script Builder | Open the visual automation script builder dialog. |
Shift + F5 |
Script Debugger | Open interactive script breakpoint and variable debugger. |
Shift + F6 |
Report Designer | Open the banded visual report designer. |
Shift + F7 |
Report Viewer | Open on-screen report preview. |
Shift + F8 |
Label Designer | Open adhesive label layout designer. |
Ctrl + I |
Import Records | Import rows from a CSV or tab-delimited file. |
F1 |
Help | Open FastEditor Help to the Database Builder section. |
9. Command-Line Interface (CLI)
FastEditor provides a headless command-line interface for tabular data transformations, queries, format conversions, log reporting, and automated text pipelines.
General Invocation
Invoke FastEditor CLI commands from PowerShell, Windows Command Prompt, or terminal scripts using the following syntax:
FastEditor.exe <command> [options] [--in <file>] [--out <file>]
When --out is omitted, output writes to standard output (stdout). Use --in - to read input from standard input (stdin) when piping commands.
Command Reference
| Command | Description | Key Options |
|---|---|---|
--convert |
Convert between CSV, TSV, JSONL, Parquet, Markdown, SQL INSERT, and XLSX formats. (Pro license required for files over 50 MB). | --format <fmt>, --encoding <enc>, --delimiter <d>, --parquet-infer-types |
--sql <query> |
Execute analytical or filter SQL queries against tabular input files. (Pro license required for files over 50 MB). | --format <fmt>, --limit <N> |
--join |
Join two datasets on key columns. (Pro license required for files over 50 MB). | --file2 <f2>, --on <col1=col2>, --type inner|left|right|full |
--diff |
Compare two tabular datasets side-by-side on key columns. (Pro license required for files over 50 MB). | --file2 <f2>, --format <fmt> |
--filter <regex> |
Filter rows by regular expression pattern or column value in constant memory. (Pro license required for files over 50 MB). | --column <col>, --invert, --limit <N> |
--stream-replace |
Perform streaming find-and-replace transformations. (Pro license required when any input file exceeds 50 MB). | --pattern <find>, --replace-pattern <repl> |
--split |
Split large files into chunks by line count, file size, or unique column values. (Pro license required for files over 50 MB). | --lines <N>, --size <MB>, --by-col <col>, --out-dir <dir> |
--merge |
Merge multiple text or delimited files into a single destination file. (Pro license required when any single input file exceeds 50 MB). | --schema-mode strict|union, --header, --no-header |
--log-report |
Analyze log files and generate statistical reports covering log levels, time spans, and error clusters. (Pro license required for files over 50 MB). | --time-col <col>, --json |
--correlate-logs |
Merge and correlate timestamps across multiple log files into a chronological stream. (Pro license required when any single input file exceeds 50 MB). | --time-col <col>, --format <fmt> |
--script <file.js> |
Execute headless automation scripts using the embedded QuickJS JavaScript engine. (Pro license required when --in or any file passed to a batch host function exceeds 50 MB). |
--args "<parameters>" |
--help |
Display command-line summary and supported options. | -h |
--version |
Display CLI contract version. | -v |
Global Options
| Option | Short | Description |
|---|---|---|
--in <file> |
-i |
Input file path. Specify - to read from standard input. |
--out <file> |
-o |
Output file path. Defaults to standard output if omitted. |
--format <fmt> |
-f |
Data format: csv, tsv, jsonl, parquet, markdown, sql, or xlsx. |
--encoding <enc> |
-e |
Text character encoding: utf-8, utf-16le, cp1251, latin1, or ascii. |
--delimiter <c> |
-d |
Field delimiter character for delimited text (such as ,, \t, or ;). |
--limit <N> |
-n |
Stop processing after outputting N data rows. |
--quiet |
-q |
Suppress informational progress messages to stderr. |
--json |
Output structured machine-readable JSON status and metrics envelope. | |
--license-key <k> |
Commercial FastEditor Pro license key for processing files larger than 50 MB. Once activated, FastEditor binds the activation to this machine, caches it locally (up to 3 machines per license.dat), re-validates online once a day when connected, and continues working offline for up to 30 days on activated machines. To free a slot on an activated PC, use Help > Deactivate This PC or your Polar account. |
|
--license-file <p> |
Path to activated license container file (valid offline for up to 30 days from the last online check). |
GUI Launch Switches
The following switches control graphical interface startup behavior:
--mode=db: Launch directly into Database Builder mode.--mode=fm: Launch directly into dual-pane File Manager mode.--mode=editor: Force standard text editor mode.--demo: Launch Database Builder and open the bundled demonstration database.--view <file>: Open the specified file in read-only view mode.--tail <file>: Open the specified file in live-tail follow mode.
Process Exit Codes
FastEditor CLI returns deterministic process exit codes for script and CI pipeline branching:
| Exit Code | Name | Meaning |
|---|---|---|
0 |
Success | The operation completed successfully. |
1 |
Runtime Error | Execution failed due to missing file, I/O error, or query syntax failure. |
2 |
Invalid Usage | Invalid arguments, missing required options, or unrecognized flag. |
3 |
License Limit | An input file exceeds 50 MB on any CLI batch command (requires FastEditor Pro). |
Worked Examples
The following examples demonstrate common automated command-line workflows:
Example 1: Converting CSV to Markdown Table
FastEditor.exe --convert --in test_sample.csv --format markdown
Output:
| Name | Age | City |
| :--- | :--- | :--- |
| Alice | 30 | London |
| Bob | 25 | Paris |
| Carol | 35 | Berlin |
Example 2: Filtering Rows by Regular Expression
FastEditor.exe --filter "Berlin|London" --in test_sample.csv
Output:
Alice,30,London
Carol,35,Berlin
Example 3: Running Analytical SQL with JSON Telemetry
FastEditor.exe --sql "SELECT Name, City FROM active_table WHERE Age > 28" --in test_sample.csv --format csv --json
Output:
Name,City
Alice,London
Carol,Berlin
{
"version": "1.0",
"command": "sql",
"status": "success",
"exit_code": 0,
"metrics": {"elapsed_ms": 18},
"warnings": [],
"errors": []
}
10. Known Limitations
This section summarizes known technical limitations, operating system boundaries, and architectural constraints across FastEditor features.
File Manager Constraints
- Remote File Viewing & Editing (F3 / F4): Remote FTP, FTPS, and SFTP files cannot be viewed or edited directly and must be downloaded to a local panel first (see File Manager Limitations in Section 7).
- Standard User Privileges & Elevation: The File Manager does not trigger UAC elevation prompts; accessing protected system folders fails with an access error (see File Manager Limitations in Section 7).
- Site-to-Site Remote Transfers (FXP): Direct transfer between two remote FTP, FTPS, or SFTP servers is not supported; one panel must be a local filesystem directory (see File Manager Limitations in Section 7).
- Remote File Deletion: Deleting files on remote FTP, FTPS, and SFTP servers is permanent; the Windows Recycle Bin is available only for local filesystem items (see File Manager Limitations in Section 7).
- Single Background Operation: The File Manager executes one background file operation (copy, move, delete, or synchronize) at a time and rejects starting a second operation while one is running.
- Long Path Recycle Bin Boundary: Local files or folders with full path lengths of 248 or more characters bypass the Recycle Bin and are deleted permanently.
Database Builder Constraints
- In Database Builder, DATE and TIME column values are stored internally as ISO 8601 text strings because SQLite does not have dedicated date or time storage types.
- Cross-table calculated fields in Database Builder cannot be searched or filtered in Find Mode queries.
- Global variables (
$$name) and system variables (@name) cannot be used in table-level SQL-generated column calculation expressions. - Printing reports or label layouts on paper dimensions smaller than the layout scales output to fit the printable area, but physical printer hardware margins may clip outer borders.
CLI Constraints
- All headless CLI batch commands (
--convert,--sql,--join,--diff,--filter,--stream-replace,--split,--merge,--log-report,--correlate-logs,--export, and--scriptwhen--inor a batch host function input exceeds 50 MB) require a FastEditor Pro license when any single input file exceeds 50 MB.
Data Format Constraints
- JSON Tools and JSON as Table: numbers (integers of arbitrary length, fractional values, and scientific notation) are preserved and displayed exactly without floating-point precision loss. Format in Place (
Ctrl+Shift+B), Minify JSON, and Format to New Tab (Ctrl+J) format numbers without alterations. JSON as Table (Ctrl+Shift+J) converts documents up to 50 MB (or 32 MB selection) into editable CSV grid snapshots with up to 1,000,000 rows and 600 columns. Documents exceeding 50 MB or selections exceeding 32 MB are refused safely with an explanatory message. - Excel workbooks (
.xlsx,.xlsm,.xltx,.xltm) open as detached CSV grid snapshot tabs with up to 50 MB file size, 1,000,000 rows, and 600 columns. Workbooks exceeding 50 MB are refused safely ("XLSX Table View supports workbooks up to 50 MB. Save the sheet as CSV in Excel to open larger files in FastEditor."). Sheets exceeding 1,000,000 rows or 600 columns safely load the first 1,000,000 rows or first 600 columns with status-bar notices. Refusal occurs only when the sheet has no data within the first 600 columns and 1,000,000 rows, or is empty. Legacy Excel (.xls), Excel binary (.xlsb), OpenDocument spreadsheets (.ods), and password-protected workbooks are not supported and show clear refusal messages directing users to save as.xlsxor.csv. Other Office documents (.docx,.pptx,.odt,.odp) are not text files and are skipped by Find in Files. - ZIP archives (
.zip) are searched by Find in Files but cannot be opened as documents; FastEditor shows a notice when you try. Single-file archives (.gz,.zst,.bz2,.xz) still open their content.