Quick start with DataGrip

Creating a project

1. In the Welcome screen, click the New Project button.

2. In the Enter new project name field, type the name of your project.

3. Click OK to create the project.

   

1. To connect to the database, create a data source that will store your connection details. You can do this using one of the following ways:

   • In the main menu, go to File | New | Data Source | Other Data Source from URL and select SQLite.

   • In the Database Explorer ( View | Tool Windows | Database Explorer) , click the New icon () in the toolbar. Navigate to Data Source Data Source | Other Data Source from URL and select SQLite.

   

2. Check if there is a Download missing driver files link at the bottom of the connection settings area. Click this link to download drivers that are required to interact with a database. For a direct download link, refer to the JetBrains JDBC drivers page.

   Location for the downloaded JDBC drivers is the DataGrip configuration directory.

   

   You can also use your drivers for the database instead of the provided ones. For more information about connecting to a database with your driver, refer to Add a user driver to an existing connection.

   If there is no Download missing driver files link, then you already have the required drivers.

3. Specify the database connection details. Alternatively, paste the JDBC URL in the URL field.

   To create a new SQLite database, change the default identifier.sqlite name of the database, if needed. Alternatively, click the New button () and specify the name and location for your new database file.

4. Ensure that the connection to the database can be established using the provided details. To do that, click the Test Connection link at the bottom of the connection details area.

   

   In case of any connection issues, refer to the Cannot connect to a database page.

5. (Optional) By default, only the default >schema is introspected and available to work with. If you also want to work with other schemas, in the Schemas tab, select them for the introspection.

   

6. Click OK to create the data source.

1. You can open the Files tool window by doing one of the following:

   • In the main menu, go to View | Tool Windows | Files.

   • On the tool window bar, click Files.

   • Press Alt+2.

2. In the Files tool window , click the Attach Directory to Project button () in the toolbar.

   Alternatively, right-click in the area of the Files tool window and select Attach Directory to Project.

3. In the file browser, navigate to the directory that you want to attach. In our case, it is the dumps directory.

4. Click Open.

1. In the Files tool window ( View | Tool Windows | Files) , navigate to the sqlite-sakila-db tree node.

2. Expand sqlite-sakila-db tree node.

3. Right-click the sqlite-sakila-schema.sql file and select Run 'sqlite-sakila-schema...'. Alternatively, press Ctrl+Shift+F10.

4. In the Target data source / schema table of Edit Configuration dialog that opens, click the Add button () and select SQLite | main.

5. Click Run.

   You can view the output in Run tool window. For more information about tool window controls, refer to Run tool window.

Code completion

• Suggestions for code completion appear as you type your code. DataGrip has two types of code completion:

  Basic code completion Ctrl+Space helps you complete names of tables, routines, types, and keywords within the visibility scope. When you invoke code completion, DataGrip analyzes the context and suggests the choices that are reachable from the current caret position. By default, DataGrip displays the code completion popup automatically as you type.

  Smart code completion Ctrl+Shift+Space filters the suggestion list and shows only the types applicable to the current context.

  The following animation shows the difference between basic and smart completion. Notice the number of variants that are suggested for different completion types

Generating code

• DataGrip provides multiple ways to generate common code constructs and recurring elements, which helps you increase productivity. These can be either file templates used when creating a new file, custom or predefined live templates that are applied differently based on the context, various wrappers, or automatic pairing of characters.

  Go to Code | Generate Alt+Insert to open the popup menu with available constructs that you can generate.

  You can generate functions, procedures, views, and other database objects.

  To generate an object, press Alt+Insert and select the object that you want to generate.

Live templates

• Use live templates to insert common constructs into your code, such as statements or definitions of database objects.

  The following video shows how you can use live templates.

  To expand a code snippet, type the corresponding template abbreviation and press Tab. Keep pressing Tab to jump from one variable in the template to the next one. Press Shift+Tab to move to the previous variable.

  To see the list of live templates, open settings Ctrl+Alt+S and navigate to Editor | Live templates.

Inspections

• In DataGrip, there is a set of code inspections that detect and correct abnormal code in your project before you compile it. The IDE can find and highlight various problems, locate dead code, find probable bugs, spelling problems, and improve the overall code structure.

  Inspections can scan your code in all project files or only in specific scopes (for example, only in production code or in modified files).

  Every inspection has a severity level — the extent to which a problem can affect your code. Severities are highlighted differently in the editor so that you can quickly distinguish between critical problems and less important things. DataGrip comes with a set of predefined severity levels and enables you to create your own.

  To see the list of inspections, open settings Ctrl+Alt+S and navigate to Editor | Inspections. Disable some of them, or enable others, plus adjust the severity of each inspection. You decide whether it should be considered an error or just a warning.

  For example, the Redundant code in COALESCE call inspection reports all the arguments except for the first expression that does not evaluate to NULL.

  

Intention actions

As you work in the editor, DataGrip analyzes your code, searches for ways to optimize it, and detects potential and actual problems.

As soon as the IDE finds a way to alter your code, it displays a yellow bulb icon in the editor next to the current line. By clicking this icon, you can view the intention actions available in the current context. Intention actions cover a wide range of situations from warnings to optimization suggestions. You can view the full list of intentions and customize them in the Settings dialog Ctrl+Alt+S.

To see the list of intention actions, open settings Ctrl+Alt+S and navigate to Editor | Intentions.

1. Click the light bulb icon (or press Alt+Enter) to open the list of suggestions.

2. Select an action from the list and press Enter.

   For example, you can use an intention action in the INSERT statement to create a table with valid field types: