DBNova

Appearance

The left panel is for Database Navigation, and the right panel hosts Query Tabs.

project_details

Database Navigation ​

To create a new database: ​

create_database_form

Database Operations ​

database_record
    1. New query

    For SQL databases, you can select SQL or TypeScript, or specify the default in the database's UI configuration.

    Feat SQL

    Feat TypeScript

    1. Open query
    1. Refresh database type

    Accurate database types are used to provide a better TypeScript IntelliSense experience.

    To minimize database load, DBNova does not auto-refresh database types. Please refresh manually if changes occur.

    1. Test Connection
    1. Modify database configuration

Click a database name to toggle the table list. Hold Ctrl and click a database name to refresh when collapsed.

table_list

Table Operations ​

    1. Browse

    Open a new tab and view all records.

    1. New Record
    1. Load

    Import data from a file (Excel, JSON or JSONL).

    1. Structure Information

    Show the structure information.

    1. Soft drop

    Rename to soft_dropped_${table_name} and hide by default.

    1. Drop

    Permanently delete the table. (Disabled in production environments).

Query Tab ​

query_tab

The code editor is implemented based on Monaco Editor. When editing SQL, there is no auto-completion functionality. When editing TypeScript, basic auto-completion is available, but it is not as comprehensive as in VSCode. I am considering leveraging the typescript-go project to customize the lsp once it is completed, which may enable more robust auto-completion capabilities.

The table supports vertical virtual scrolling.

For horizontal scrolling: Shift + mouse wheel is the default browser behavior. Additionally, hovering the mouse over the table header or the bottom scrollbar will also trigger horizontal scrolling.

Toolbar ​

toolbar
    1. Start Transaction

    The transaction scope is the entire tab, All database operations will be executed within this transaction.

    If you want to ensure that multiple statements are executed within the same session, you must start a transaction.

    1. Execute

    If there is only one statement in the current file, it will be executed directly.

    If there are multiple statements, you can select one or more to execute.

    TIP

    Running multiple statements simultaneously will trigger 'Exec' mode, which does not return any result sets for each query.

    1. Re-Execute

    TIP

    Hold Ctrl to re-enter parameters before execution.

    1. Show Args

    View current execution parameters.

    1. Time Status

    Show execution completion time and duration.

    1. More

    If there are more rows, this indicator will be displayed.

    1. Dump

    Export results to Excel/JSON.

    1. Collapse Table
    1. Commit Transaction
    1. Rollback Transaction

Cell Operations ​

cell_ops
    1. Display

    For large data values, content is truncated. Click it to show the full content in a popup.

    1. Edit

    Modify the cell value. Feats CellEdit

    1. Copy

    Copy cell value.

    1. Copy Row

    Copy the entire row.