Databases & tables

Databases & tables

The sidebar shows a tree of every database your account can see. Tables load when you expand a database, and the filter box at the top (press /) narrows the tree as you type.

#Databases

The databases page lists each database with its size, table count and default collation. From here you can:

  • Create a database with a character set and collation.
  • Rename a database.
  • Drop a database. You must type its name and re-enter your MySQL password.

#Browsing a table

Table pages have tabs: Browse · Structure · Indexes · Foreign keys · SQL · Operations.

The browser is built for big tables:

  • Keyset paging. Where the table has a usable key, DBNova pages by key instead of OFFSET, so any page of a 10M-row table loads in 3–8 ms.
  • A virtualized grid. Only visible rows and columns are drawn, so a 120-column table scrolls at 60 fps.
  • NULL is not empty. NULL shows as a muted badge, an empty string as an empty cell, and BLOBs as [BLOB 12 KB].
  • Sticky header and first column, column resize, server-side sort and a filter row per column.

#Editing rows

On tables with a primary or unique key you can:

  • double-click a cell to edit it (Enter saves, Esc cancels);
  • insert new rows;
  • select rows and delete them in bulk (with confirmation).

Saves are optimistic and roll back with the MySQL error message if the server refuses them.

#Changing the schema

Create and alter tables, columns, indexes and foreign keys from the Structure tab. Before anything runs, DBNova shows the exact SQL it will execute in a read-only editor. Online ALTERs (ALGORITHM=INSTANT or INPLACE) are used where your MySQL version supports them.

0 views Something unclear? Open an issue on GitHub