DEV Community

Neenad Ingole
Neenad Ingole

Posted on

Keep Watch on SQL Query in Intellij/Goland or DataGrip

Are you an Intellij, Goland or DataGrip User? Like me, are you running the SQL statements every time you want to see the change reflected on the table?

If Yes, I found a small trick in Intellij and DataGrip that could watch your SQL query results. It was always there but I overlooked it. Once I discovered it, it changed my life for debugging or development.

It’s not a trick actually πŸ˜… but a feature built within the IntelliJ products. It could easily go ignored but let’s see how to use it

When you run any query you will see the Result window below:

result window

You would see this clock icon in the toolbar that does all the trick. It was always there but I never thought it would be so useful 😍

Clock Icon

When you click on it, the below options would be available. Each choice you select will refresh the query results after the selected delay.

predefined interval

A small tip to remember is to make sure you β€œPin” πŸ“Œ the result window. When you do it, you could run other queries along with the watch window.

The below video shows a small demo of this feature. In the demo, I am watching the result of a SELECT query. When I update a record it is shown in the result window without running the SELECT query again.

demo

5s seem long? What if I want to keep the watch period lower than 5s? You could use the Custom option provided. With this, you could also monitor your query changes at a 1s rate interval

custom interval

Well, that's all for this post. I hope next time this small utility will come in handy for you. Don’t run the query every time to see the change. IntelliJ tools are a powerhouse of such small utilities which are very easily ignored by us.

Thanks! and Happy Coding! Don’t forget to follow me, like (❀️) for motivation and comment on some IntelliJ utilities that helped you! 🍻

Top comments (0)