I've been using Jetbrains' 0xDBE recently (<a href="https://www.jetbrains.com/dbe/" rel="nofollow">https://www.jetbrains.com/dbe/</a>) and I highly recommend it:<p><pre><code> * 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)</code></pre>
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?
Hey everyone! I just wanted to add a little back story to DB1<p>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].<p>Feel free to let me know any questions or comments you have!<p>[0] <a href="https://github.com/sequoiastudios/DB1/issues" rel="nofollow">https://github.com/sequoiastudios/DB1/issues</a>
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?<p>EDIT: Might it be possible to stop a running query, still loading :).<p>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?
Looks promising, could see myself using it at some point in the future.<p>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?
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: <a href="https://truongtx.me/2014/08/23/setup-emacs-as-an-sql-database-client/" rel="nofollow">https://truongtx.me/2014/08/23/setup-emacs-as-an-sql-databas...</a>
Get dbext.vim if you are a vimmer.<p><a href="http://www.vim.org/scripts/script.php?script_id=356" rel="nofollow">http://www.vim.org/scripts/script.php?script_id=356</a><p>Current databases supported are:<p>ODBC / Perl DBI<p>Mysql<p>Oracle<p>Oracle Rdb (VMS)<p>SAP HANA<p>SAP Sybase SQL Anywhere (SA/ASA)<p>SAP Sybase IQ (ASA)<p>SAP Sybase Adaptive Server Enterprise (ASE)<p>SAP Sybase UltraLite (UL)<p>Microsoft SQL Server<p>IBM DB2<p>Interbase<p>SQLite<p>PostgreSQL<p>Ingres<p>Firebird<p><a href="https://mutelight.org/dbext-the-last-sql-client-youll-ever-need" rel="nofollow">https://mutelight.org/dbext-the-last-sql-client-youll-ever-n...</a><p>Working with SQL in Vim, by Kris Jenkins<p><a href="https://vimeo.com/76005855" rel="nofollow">https://vimeo.com/76005855</a>