3 ms·
I have a couple of feature requests that nothing else seems to be able to do: 1. Parameterised queries (ideally with an ability to customise the syntax for the
by nicoburns 7y ago
I have a couple of feature requests that nothing else seems to be able to do:
1. Parameterised queries (ideally with an ability to customise the syntax for the placeholders - we use :param for named parameters). All of our production queries are parameterised, and it would be awesome to be able to copy and paste them into this kind of tool, and run them unmodified. Especially as they sometimes use the same parameter in multiple places, so updating them.
2. A full editor control (e.g. Code Mirror, Monaco, or Ace) for editing SQL queries. Specifically I really want multiple cursors for editing queries quickly and efficiently.
- dewey 7y agoJust in case you are not aware of it, DataGrip can do all these things: https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
- davedx 7y agoI use Rider daily and pay for it, but I found the price tag for DataGrip to be pretty steep considering what I typically use a SQL client for (running ad hoc queries mostly). The competition is not great on MacOS either so I've been using Azure Data Studio and dbBeaver mostly and not really happy with this state of affairs either. Excited to see a fresh new attempt in this space.
- fullstackchris 7y agohopping on the train here - does anyone know an editor that can do editing of postgres enums? (i know you can't 'edit' an enum in postgres, but i would love a GUI that would 'allow' this. (i.e. in the background DROP CASCADE the enum, create a new one with the same name and new value, as well as restoring to previous dependencies that the old enum had)
- absove 7y agoAs far as I can tell IntelliJ Ultimate (and therefore most likely DataGrip too) supports both. For parameterized queries you get a prompt that let you fill in values for each parameter when executing them. They're commercial products though.
- joshstrange 7y agoDataGrip does support multiple cursors, I've never done the parameterized queries but I will have to look into that. Buying the entire Jetbrains suite was one of the best decisions I made when I switched jobs and lost my old license. IDEA/Datagrip save me so much time, when I worked it out I couldn't pay for them fast enough.