Live data from Hacker News

Show HN: Sublime Text Database Client

sequoiastudios.io

1–10 of 43 posts

Re: Show HN: Sublime Text Database Client

#4

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

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.

Re: Show HN: Sublime Text Database Client

#6
post #4

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

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…

If you're paying for a JB IDE, you already have all the features of 0xDBE.

Re: Show HN: Sublime Text Database Client

#10
I've been using Jetbrains' 0xDBE recently (https://www.jetbrains.com/dbe/) and I highly recommend it:

  * it works with IDEAVim
  * it uses JDBC so you can easily connect to "non-standard" DBs by using any JDBC driver
  * it's better than psql/vsql/... for dealing with complex queries (you have a real editor rather than limited readline support, if you're lucky enough to have readline support)
Post reply on HN