Data Views

Last modified: 08 March 2021

This is a Professional feature: download PyCharm Professional to try.

File | Settings | Tools | Database | Data Views for Windows and Linux
PyCharm | 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.

ItemDescription
Limit page size to

Number of table rows that are shown on one page. If you do not want to limit the number of rows displayed simultaneously, clear the checkbox.

Also, you can change the page size by clicking the Change page size list of the pagination toolbar.

Consider the following example where Limit page size to is set to 2:

Limit page size to
Result set prefetch size

Number of rows from a database that is retrieved in one chunk.

A bigger number means less round trips between IDE and a database but more memory for storing a chunk.

Filter history size

Number of recently-used filtering conditions that are saved for a table in a data editor. Consider the following example where Filter history size is set to 2. The filter history box contains only two conditions.

To open the filter history in the editor, click the Filter Criteria field and press Alt+Down.

Filter history size
Maximum number of bytes loaded per valueMaximum size of a binary large object to be loaded in bytes.
Show boolean values as

Set how you want to display boolean values in the data editor. You can select between the following options.

  • Text: boolean values are shown as text. Click a boolean cell to select a value from the drop-down list.

    display boolean values as text

  • Checkboxes: boolean values are shown as checkboxes. If the checkbox is selected, the value is true. If the checkbox is cleared, the value is false. To set NULL or DEFAULT values, right-click a cell and select Set NULL or Set DEFAULT.

    display boolean values as checkboxes

Sort tables by numeric primary key

Configure how to sort table records by the numeric primary key. Two options is available: Ascending or Descending.
Automatically transpose tables

Configure when you want to transpose tables and views when you open them in the data editor. In a transposed view, columns and rows are interchanged. Note that this setting does not transpose query results.

  • Never: do not transpose a table.

  • If a table has one record: transpose only tables with a single record.

  • Always: always transpose tables.

Submit changes immediately

Submit changes instantly. For more information about submitting your changes to a database, see Submit changes to a database.