I have tried really hard to like DataGrip several times. It seems to be getting better, but there is one huge non-starter for me that doesn't seem to be getting fixed. I can not seem to get to the source code of package, views and other objects. It appears that a synchronization must complete successfully in order for this to happen? I work with a large Oracle 11G database. Not just a lot of data, but a lot of objects in one schema. I have set my JVM settings to -Xmx1024m and it still will not complete the sync after several hours.
I assume this is because you are syncing all of the objects with their source? While I understand the idea for autocomplete, I still need the ability to view source on an object even if the object is not synced. Plus if you are only showing me the synced object, what happens if the object source changes? Does a re-sync have to happen before seeing the real source? This re-sync process for me seems to take hours and while happening in the background, it still appears to keep me from seeing the current source. If this is not the case, what could I be doing incorrectly? Could the "show source" not go to the database directly to get the current source while using synced data for autocomplete?
For me, this the the last product that I have resisted switching. I use IntelliJ, Rider, PyCharm, and WebStorm daily and would not give any of them up for any other tool. PLEASE help me like DataGrip as well!!!
Database: Oracle 11G
OS: Mac OS Mojave and Ubuntu 18.04 both
Datagrip version: 2018.3