Working With Databases in IntelliJ IDEA
summary
Live demo shows IntelliJ IDEA’s built‑in DB tool matches DataGrip feature‑for‑feature: connect to major engines, run code completion based on introspection queries, create consoles with live templates, and choose execution scope per caret. Editor can expand wildcard into qualified columns, convert selects to subqueries, name result tabs with comments, and compare data grids. Data editor supports editable grids with preview/submit, CSV/JSON/INSERT exporters, scripted extractors, copy‑result‑to‑table and simple charts/DDL‑backed schemas.
AI-written summary · about
chapters (19)
- 0:00Introduction to Database Tools
- 1:15Connecting to data sources
- 4:24Data source configuration
- 5:53Schema filtering and management
- 7:15Database explorer features
- 9:13Writing and running SQL queries
- 12:06Coding assistance and analysis
- 13:36Advanced editing and refactoring
- 16:04Handling multiple result sets
- 17:40Comparing data grids
- 18:37Database navigation
- 20:24Data grid manipulation and filtering
- 23:11Editing and updating data
- 26:33Data visualization
- 29:19Exporting and importing data
- 33:34Query history and logging
- 36:11Searching and finding objects
- 38:24Working with DDL data sources
- 40:35Q&A and closing
related talks
52mDB-first Meets Code-first: Persistence Workflows in IntelliJ IDEA
26mBuilding a MongoDB Plugin With the DataGrip Team
21mDBeaver: efficient way to work with SQL and NoSQL from Eclipse IDE
20mDatabase developer productivity tips and tricks
33mTips and tricks for SQL Developer and SQL Developer command line
01h 29mWorking with Databases and Groovy
06mBuilding a SQL editor around “fast”
56mPersistence Workflows with IntelliJ IDEA