jinyangcruise
GDSQL - Ultimate Database
GDSQL, a ConfigFile-based SQL system. Pure GDScript, zero dependencies, no server required, AI friendly. Features: visual database management, Excel-like inline editing with auto-fill, MyBatis-style ORM (GBatis), code generator, and encryption. Supports csv/json/cfg import-export.SQL Query EngineA complete SQL engine built in pure GDScript, supporting:Statements: SELECT, INSERT, UPDATE, DELETE, REPLACEConditions: WHERE with AND, OR, IN, NOT INSorting & Grouping: ORDER BY (multi-column, ASC/DESC), GROUP BY with HAVINGPagination: LIMIT and OFFSETJoins: LEFT JOIN with chainable multi-table supportSet Operations: UNION ALLSubqueries: Both correlated and non-correlatedAggregates: COUNT, SUM, AVG, MIN, MAX, GROUP_CONCATExpressions: Arithmetic operators, string concatenation, function calls, type conversion, SQL-compatible NULL semantics (three-valued logic)INSERT variants: INSERT IGNORE (skip on duplicate key), INSERT ... ON DUPLICATE KEY UPDATE (upsert)LRU Cache: Auto-caches the last 1024 parsed SQL statements for faster repeated queriesYou can execute raw SQL strings directly via SQLParser.parse_to_dao(), or use the visual SQL editor in the workbench.Visual WorkbenchA dedicated main screen in the editor, consisting of integrated panels:Database Tree Browser β Navigate all databases and tables hierarchically. Right-click for context menus (create, delete, rename, etc.).Data Table Viewer β Browse and edit data in an Excel-like grid. Click any cell to edit inline with instant commit. Drag column borders to resize. Sort by clicking column headers. Supports type-appropriate editors for int, float, Vector2, and more.Table Structure Editor β View and modify column definitions: name, data type, default value, comments, primary key, and auto-increment settings.Schema Management β Visually create and delete databases and tables through dialog-based workflows.SQL Query Editor β Write and execute SQL with syntax awareness. Results appear in a grid panel below. Query history is automatically recorded. Export results as CSV, JSON, or CFG.Diff View β Compare table content between two versions with color-coded highlights: added rows (green), deleted rows (red), modified rows (yellow).Table Inspector β Detailed column definitions, table metadata, and data statistics in the right panel.Smart Auto-FillAccelerates data entry with intelligent pattern prediction:Least-squares fitting: Analyzes existing numeric samples to predict subsequent valuesMulti-type support: Numbers, strings with numeric placeholders (e.g. "enemy_001" β "enemy_002"), Vector2/3/4, Vector2i/3i/4i, Resource pathsPattern recognition: Detects numbering sequences and fills accordinglyDrag-to-fill: Select a range, drag the fill handle, and watch values populate automatically