Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Sublime Text Database Client

sequoiastudios.io

Post reply on HN
Print view View original

31–40 of 43 posts

Re: Show HN: Sublime Text Database Client

#31

Post by dontscale »

alexis-d wrote: post #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)

Nice. Great way to shit on OP and steal his/her thunder under the guise of being helpful with alternatives. "...I was simply (insert BS justification here)." Sure you were.

Re: Show HN: Sublime Text Database Client

#32

Post by fit2rule »

alexggordon wrote: post #25
mullsork wrote: post #5

Pretty cool but that pricing... I'd be happy to shell out $9 if the trial was successful and the app felt more useful than the alternatives. But $29?

To be honest the pricing was something I really struggled with. I finally ended up settling on that price as it was similar[0] to some of the other database clients on the market, and similar to the pricing of other Sublime Text plugins. After using DB1 a fair amount I think it brings a lot of value to the daily workflow of someone that uses databases a fair amount, and uses Sublime Text. In addition to that, I have…

Pricing is important. You might make 100000x the sales of a 0.99 app than you do of a 10.00 app. I closed the tab when I saw the price you'd set, and just forgot about the subject. Sublime integration just isn't worth that much money. Yet.

Re: Show HN: Sublime Text Database Client

#33

Post by fit2rule »

coldtea wrote: post #11
jbrooksuk wrote: post #8

Earlier quoted context omitted.

Sublime Text is fine :) Edit: I'm a moderator on the forums. I've been in touch.

We've had 3-4 months without a new dev release though, after it had picked some steam.

Where is the expectation that things have to happen .. perhaps a 4 month testing period is a good sign.

Re: Show HN: Sublime Text Database Client

#34

Post by saurabh »

Get dbext.vim if you are a vimmer.

http://www.vim.org/scripts/script.php?script_id=356

Current databases supported are:

ODBC / Perl DBI

Mysql

Oracle

Oracle Rdb (VMS)

SAP HANA

SAP Sybase SQL Anywhere (SA/ASA)

SAP Sybase IQ (ASA)

SAP Sybase Adaptive Server Enterprise (ASE)

SAP Sybase UltraLite (UL)

Microsoft SQL Server

IBM DB2

Interbase

SQLite

PostgreSQL

Ingres

Firebird

https://mutelight.org/dbext-the-last-sql-client-youll-ever-n...

Working with SQL in Vim, by Kris Jenkins

https://vimeo.com/76005855

Re: Show HN: Sublime Text Database Client

#35

Post by ZenoArrow »

Looks promising, could see myself using it at some point in the future.

On a related note, it's a shame SSMS doesn't work with more databases (aside from as linked databases), I haven't found any database management tools that are better (commercial or free/open-source). The only drawback I've found with SSMS so far is limited colour theme functionality and slightly awkward debugging of .NET assemblies (you'd want to use VS2013 for writing them anyway, so it's not much of an issue). I'd be interested to know what's out there, perhaps I've missed something. What do Java developers tend to use?

Re: Show HN: Sublime Text Database Client

#36

Post by imakesnowflakes »

wbond wrote: post #28
occsceo wrote: post #13

Earlier quoted context omitted.

I agree. I feel its worth the $9 price point too. $29? No way. Sublime Integration isn't worth $20 when I can just alt+tab. There are a lot of free apps that provide a ton more db functionality.

But if you are alt-tabbing, you no longer have the full suite of Sublime Text tools to work with. You don't have multiple cursors, and you can't use goto file, you don't get nice syntax highlighting, you can't select and execute SQL embedded in other source code files. In the grand scheme of things, I think it all depends on how much you interact with a db. If you just run an odd command here and there, $30 may seem…

>you can't select and execute SQL embedded in other source code files..

How is it possible anyway? Queries in source files almost always cannot be executed as such, because of placeholders/parameters. Or what am I missing?

Re: Show HN: Sublime Text Database Client

#38

Post by imakesnowflakes »

glogla wrote: post #4
gamesbrainiac wrote: post #2

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…

>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

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.

Re: Show HN: Sublime Text Database Client

#39

Post by xemoka »

dontscale wrote: post #31
alexis-d wrote: post #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)

Nice. Great way to shit on OP and steal his/her thunder under the guise of being helpful with alternatives. "...I was simply (insert BS justification here)." Sure you were.

I'm not sure if you realise how combative your comment is. You mock and belittle alexis-d with no real reason other than your own perception.

Why can we not talk about tools that we're using to get the job done, isn't this what part of HN is about? This isn't Product Hunt or a site for purely marketing products.

Re: Show HN: Sublime Text Database Client

#40

Post by mescalito »

I went ahead and gave it a try. I choose the first db in my local environment, give "select * from users" for a spin. It's a table with 84k records. It's loading for quite a bit now. I see is a big table, however isn't huge. I wonder if there's something to warn about long result queries and also if you can somehow prevent this, by adding a fixed limit to a query or something like that, maybe making this configurable?

EDIT: Might it be possible to stop a running query, still loading :).

One thing I couldn't figure out from your page is how the trial works? Would just end at some point or would you remind us to license from time to time, in the like of sublime text/svn form wbond?

Post reply on HN