ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #datagrip
Connection Pool Timeout The goal is to ensure that the production database connection pool applies the same 30‑second timeout that works locally. In the production project the JDBC URL overrides the default timeout, and the project’s connection‑pool settings do not contain a timeout property, so DataGrip inherits the server’s default and connections hang unt
DataGrip Data Editor supports bounding result sets through a configurable maximum rows to fetch and a per-query limit override, and provides First/Prev/Next/Last navigation with a selectable page size in the result grid. For databases with native LIMIT/OFFSET support, pagination can be implemented by rewriting the query on execution. Fetch size is configurab
The goal is to define the default behavior for rollback script generation in DataGrip’s migration tool when handling straightforward DDL changes such as adding a column or altering a data type. The decision must preserve the existing safety guarantee that only reversible changes are marked safe, while avoiding accidental data loss from automatically produced
When utilizing the schema comparison tool in DataGrip to synchronize a source database with a target environment, the IDE generates DDL scripts based on detected differences. While the tool identifies structural discrepancies, it does not inherently account for data transformation logic required to maintain data integrity during non-destructive schema change
DataGrip 2023.3 fetch size default change when Limit rows is enabled Goal: determine the actual fetch size applied to large result sets when the 'Limit rows' option is turned on, considering version‑dependent defaults, server‑side cursor mode, and the undocumented registry key. Constraints: the default fetch size switched from 50 rows to 0 (driver‑dependent)
Goal Recover a DataGrip project after a failed upgrade while retaining database connection passwords. Constraints & Uncertainty DataGrip’s automatic project settings backup creates a snapshot before applying updates, but it does not guarantee that encrypted password data is preserved. The IDE lacks a dedicated option to re‑enter or re‑encrypt passwords d
jetbrains