Skip to content Burger menu icon

The JetBrains Blog

The latest updates on all JetBrains products and topics

Database Tools

Tips for Productive Java Development With Databases in IntelliJ IDEA

9 Tips for Productive Java Development With Databases in IntelliJ IDEA

In this article, we’ll share nine time-saving ways IntelliJ IDEA can boost your productivity when developing Java applications with databases – whether you're starting a new project or diving into an ongoing one. Get IntelliJ IDEA Ultimate Create data sources automatically from properties I…

Julia Shashkova
Julia Shashkova
Streamline Your Workflow in IntelliJ IDEA’s Database Tools With AI Assistant

Streamline Your Workflow in IntelliJ IDEA’s Database Tools With AI Assistant

In IntelliJ IDEA, you can leverage AI Assistant’s capabilities within Database Tools for more efficient data querying and handling. It can significantly speed up SQL query generation, explain code, suggest fixes, and even create tables and populate them with test data on your command! Let’s get star…

Julia Shashkova
Julia Shashkova

Using PyCharm to Read Data From a MySQL DataBase Into pandas

Sooner or later in your data science journey, you’ll hit a point where you need to get data from a database. However, making the leap from reading a locally-stored CSV file into pandas to connecting to and querying databases can be a daunting task. In the first of a series of blog posts, we’ll explo…

Jodie Burchell
Jodie Burchell

Working with SQL and databases in Rider – Webinar Recording

The recording for our webinar, Working with SQL and databases in Rider with DataGrip team lead Maksim Sobolevskiy, is now available. Subscribe to our community newsletter to receive notifications about future webinars. https://www.youtube.com/embed/iNWWWj8dCfM Working with SQL and databases in R…

Khalid Abuhakmeh
Khalid Abuhakmeh

What IntelliJ IDEA 2017.3 EAP Brings to Database Tools

We’ve recently announced the opening of the EAP for IntelliJ IDEA 2017.3, and we have already even looked at some of the interesting EAP features. However, we didn’t cover changes in the database tools yet. So let’s explore the major changes in this area. Selecting schema when running SQL file …

Zlata Kalyuzhnaya
Zlata Kalyuzhnaya

Database Tools: What’s New in IntelliJ IDEA 2017.2

If you’re following our recent news, you already know that last week we released the new massive IntelliJ IDEA update, 2017.2. However, we didn’t mention its database tools much in the release announcement, so now it’s time to catch up on that, because there’s plenty of new features in that area. …

Andrey Cheptsov
Andrey Cheptsov

IntelliJ IDEA 13: What’s New in Database Tools

We hope you had enough time during the holidays to play with IntelliJ IDEA 13 and now want to try something new, like Database Tools, which has been so greatly improved in version 13 that you can now ditch your third party database client and perform all database operations right from IntelliJ IDEA …

Andrey Cheptsov
Andrey Cheptsov

Manage Your Database Schema in IntelliJ IDEA 12

As you know, IntelliJ IDEA provides built-in database tools with support for many SQL dialects, such as Oracle, PostgreSQL, MySQL, Microsoft SQL Server and others. A while ago we shared this video with a quick overview of how to set up a connection to a database, use smart completion (even for SQL …

Andrey Cheptsov
Andrey Cheptsov

IntelliJ IDEA 11: New and Noteworthy in Database Realm

There are many little things in database and SQL area that got attention in yesterday's IntelliJ IDEA 11 release but now I just want to highlight the major ones. Data Sources view got a new look and now includes stored procedures both from DDL scripts and real databases. The existing SQL dialects …

JetBrains
JetBrains

New Diff Tools in IntelliJ IDEA 10.5

We at JetBrains know how important it is to track what has been changed in your project from one version or revision to another. This is why IntelliJ IDEA 10.5 brings you new Diff Tools for comparing local directories, DB objects (Data Sources, Schemes, Tables). In later updates we're planning on in…

Konstantin Bulenkov
Konstantin Bulenkov

Database Table Editor in IntelliJ IDEA 10

IntelliJ IDEA X features a simple database table editor and viewer. You can add and remove rows, sort by specific column and choose columns to display just by pressing F4 on a table in the Data Sources view. If you find the console-like way better than the GUI way, you can still run all those de…

JetBrains
JetBrains

JPA Console is Available in IntelliJ IDEA 10

In IntelliJ IDEA 10 a new JPA Console is added to existing Hibernate and Database consoles. Now you can run and test your JPA queries in a target environment of your application. Both Hibernate and JPA consoles are available if applicable. Note the new "Run Query in Console" Intention Action that …

JetBrains
JetBrains
Load more