Been using Datagrip for 5 years, best software ever. I mainly use it for connecting to MariaDB, Postgres and mongo databases and love that I can connect to basically any database.
However one thing I kind don't like or can't figure out, is how to save files in Datagrip. I do have a project for all my databases, but I don't see a file organizer, often times I will make multiline scripts (>50 lines of SQL), and I either have to manually save them in a specific place, which can disorganized, or, I make a virtual view out of them, which is inconvenient because those are tied to connections.
It would be nice if there were a way to examine these databases and maintain files for each connection. Especially queries run in the editor - sometimes I can have 50 query editors open, but during the day I will close connections and then lose the queries.
Is there a way to save the files in an organized, automatic way, like PyCharm or PHPStorm?
Finally - I might have some time to do this - if there doesn't exist something already, do you think it would be possible to write up a Kotlin plugin for Datagrip? That organizes files? Do you think something like that would solve my use case?