Skip to content

DataGrip

DataGrip is JetBrains’ desktop tool for inspecting databases, editing queries and exporting selected data. It supports PostgreSQL, MySQL and SQLite, among other databases.

Visit DataGrip

What should you verify before you open a data source?

A data source is the saved connection and its settings. For a server, verify the real host and database of your disposable test copy and use a login that can read only the intended tables. For a local SQLite file, verify the full path to a fictional test copy and use read-only file protection where available.

DataGrip’s read-only option protects its data editor. JetBrains says the query console can still allow writes when the driver does not support read-only status. Keep the server’s permissions restricted and stay on paper if you cannot verify the destination.

What is the difference between exporting rows and exporting structure?

Export selected rows as CSV if a teammate needs the results of a question. Export structure separately if they need to inspect definitions such as the column names and relationships. Check the output before relying on it. Neither file alone proves that you can restore the whole database.

Store reports in a place approved for the intended readers. A file outside DataGrip has its own access settings.

When do you need a commercial license?

JetBrains offers a free individual non-commercial license and a 30-day trial. For commercial development, use the applicable paid subscription after the trial. Verify the terms if a project changes from learning to a business.

JetBrains says the individual non-commercial license requires sharing anonymous usage statistics. Detailed code-related data is a separate setting, enabled by default on that license and adjustable in DataGrip. Review the data-sharing settings and any optional features before working with private code or data.

How would you identify the correct connection before a report?

Use paper cards for two fictional sources. Do not install the app, connect a database or run a query.

  1. Check the address
    Give both cards the same friendly label. Mark one server and database as the test copy and the other as the original.
  2. Check the access
    Select the exact test source and mark the intended role as allowed to read only. For a local alternative, write the full path to a separate copy.
  3. Choose the artifact
    Draw a two-column CSV for the report and a separate table definition for structure. Mark recovery unverified.