PhpStorm 2018.3 Help

Data Views

File | Settings | Tools | Database | Data Views for Windows and Linux
PhpStorm | Preferences | Tools | Database | Data Views for macOS


The settings on this page define how table data are shown and modified in your database consoles and data editors.

Item

Description

Result set page size

The number of table rows to be shown at a time, on one "page". Here is an example when this number is set to 2:
PageSize2

If you don't want to limit the number of rows displayed simultaneously, specify zero (0).

Result set prefetch size

Data from databases are retrieved in chunks. The number in this field defines the number of rows in such chunks.

A bigger number means fewer IDE - DB round trips but more memory for storing a chunk.

Filter history size

The number of most recently used filtering conditions to memorize for a table in a data editor. Here is an example when this number is set to 2. (The filter history box contains two most recently used conditions.)

DBFilterHistorySize2

Max LOB length (bytes)

The maximum size of a binary large object to be loaded in bytes.

Data Modification / Submit changes immediately

Submit changes automatically

By default, changes are not submitted to a database unless you press the Submit icon (The Submit icon), or pressCtrl+Enter. You can enable the Submit changes immediately option to submit your changes automatically.

  1. In settings (Ctrl+Alt+S), navigate to Database | Data Views.

  2. Select Submit changes immediately.

  3. Click OK.

When this option is on, the changes are submitted right away.

See .

Last modified: 16 January 2019