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.
> 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 :)
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.
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.
Since it is convenience/time save tool, price point suitability will depend largely in your price per hour.
For example, if your price per hour is $20 and this tool saves you 1.5 hours of time in your lifetime, it would make the business case. Or, if your price per hour is $5 and it saves you 6 hours in your lifetime it also would make the business case.
However, it would be a bad investment if your price per hour is $5 and it only saves you 5 hours in your lifetime.
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 like a lot. If you work with databases for an hour or more a day, this could be a huge time-saver.
I don't know that I'd save that much time switching back and forth between sublime and workbench is my typical workflow. I gain a lot from the multiple cursors when building multiple insert/delete statements...but not sure what other situations where I could leverage this plugin to save time [with sql].
I am interested to see how "version 2" of this pans out.
For the record, workbench is not the end-all. It is quite clunky.
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 plans to support 3 or 4[1] more databases soon and add a fair amount of complicated features.
That said though, if I hear from a fair amount of people that the price point is too high then I may consider lowering it.
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.
Well that's to be expected from a one-man company (IIRC). There used to be a time when you had yearly releases at best for commercial software (and you had to renew your license in order to get the new version). Not every company has to invest in continuous release.
I'm perfectly happy to get infrequent but stable evolutions for Sublime Text.
PS : However if the author could open his source code in order for me to take "inspiration from it" and improving my own Python codebase, that would be great :p
>Well that's to be expected from a one-man company (IIRC). There used to be a time when you had yearly releases at best for commercial software.
The thing is those "dev builds" are not actual releases -- the last 10 or so of them represent at most a few dozen commits, and quite small and isolated features or fixes.
So, to put it in other words, the activity is like he has abandoned coding again the last few months (after a short stint of activity that followed a year-long halt).
I also remember what the development pace was like for ST2 -- those builds were coming up several times a week even, so that's something to compare against.
* 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.
Emacs provides support for all major databases. You can interactively "send" chunks of sql to the db client, get syntax highlighting, etc. However, this seems better in that it does not rely on db clients. That said, here is a cool write-up of using emacs with postgres: https://truongtx.me/2014/08/23/setup-emacs-as-an-sql-databas...
Hey everyone! I just wanted to add a little back story to DB1
I developed DB1 mostly this summer and put a lot of work into figuring how to do the various parts of it. I posted it here looking for as much feedback as I can get on the various parts of it (the cost was something I struggled a lot with). I also have a lot of features in the pipeline for DB1 that I think add a lot of additional value to the product[0].
Feel free to let me know any questions or comments you have!
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?
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?
42 comments
[ 2.6 ms ] story [ 86.1 ms ] threadThe 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.
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 :)
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.
For example, if your price per hour is $20 and this tool saves you 1.5 hours of time in your lifetime, it would make the business case. Or, if your price per hour is $5 and it saves you 6 hours in your lifetime it also would make the business case.
However, it would be a bad investment if your price per hour is $5 and it only saves you 5 hours in your lifetime.
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 like a lot. If you work with databases for an hour or more a day, this could be a huge time-saver.
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?
I am interested to see how "version 2" of this pans out.
For the record, workbench is not the end-all. It is quite clunky.
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 plans to support 3 or 4[1] more databases soon and add a fair amount of complicated features.
That said though, if I hear from a fair amount of people that the price point is too high then I may consider lowering it.
[0] https://eggerapps.at/postico/ [1] https://github.com/sequoiastudios/DB1/issues
Edit: I'm a moderator on the forums. I've been in touch.
I'm perfectly happy to get infrequent but stable evolutions for Sublime Text.
PS : However if the author could open his source code in order for me to take "inspiration from it" and improving my own Python codebase, that would be great :p
The thing is those "dev builds" are not actual releases -- the last 10 or so of them represent at most a few dozen commits, and quite small and isolated features or fixes.
So, to put it in other words, the activity is like he has abandoned coding again the last few months (after a short stint of activity that followed a year-long halt).
This is simply not true. Jon wrote a parser for the new .sublime-syntax files, rather than using .tmTheme files.
Since then, for 7 builds, it has been small scale fixes and minor improvements, even them stopping altogether around July 10.
http://www.sublimetext.com/3dev
I also remember what the development pace was like for ST2 -- those builds were coming up several times a week even, so that's something to compare against.
https://www.jetbrains.com/dbe/download/
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.
I developed DB1 mostly this summer and put a lot of work into figuring how to do the various parts of it. I posted it here looking for as much feedback as I can get on the various parts of it (the cost was something I struggled a lot with). I also have a lot of features in the pipeline for DB1 that I think add a lot of additional value to the product[0].
Feel free to let me know any questions or comments you have!
[0] https://github.com/sequoiastudios/DB1/issues
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
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?
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?