4 ms·

I think pgcli (for postgres) still remains a better option. It has code completion.

• glogla 11y ago
  Pgcli is good, but there are two "modes" to use DB. One is interactive querying, which pgcli is good for. The other is developing a complex query and running it again and again, while watching the result, or maybe running multiple queries and comparing the result, etc. That is more of a task for text editor that can execute queries than a CLI query tool. Now, I don't think this is worth the 30 USD. Something like the upcoming 0xDBE might be worth it, especially since you can avoid stupid Oracle SQL Developer that hands every time there's a network problem.
  • gamesbrainiac 11y ago
    If you're paying for a JB IDE, you already have all the features of 0xDBE.
  • mbreese 11y ago
    > developing a complex query and running it again and again, while watching the result, or maybe running multiple queries and comparing the result Or maybe you should just script that so that you have the entire process automated? You could even write the script in Sublime Text if that makes you feel better :)
  • imakesnowflakes 11y ago
    >The other is developing a complex query and running it again and again, while watching the result... I created a small Python/Flask application with integrated Ace editor that run in tabs for this exact use case.. https://pypi.python.org/pypi/Pygmie https://pypi.python.org/pypi/Pygmie It has been a HUGE time saver for me. It also has a query history that is saved to browsers local storage. So no more lost queries due to a system/server crash.