Select Elasticsearch driver name from the left sidebar and add the JDBC driver in the files panel through the buttons on the right if there is no such driver name check the DbVisualizer version or create a new driver entry through Driver > Create Driver. PrerequisitesĪdd the Elasticsearch JDBC driver to DbVisualizer through Tools > Driver Manager:
Developer tools to directly access databases (CC BY‑SA 3.0/4.You can use the Elasticsearch JDBC driver to access Elasticsearch data from DbVisualizer.Įlastic does not endorse, promote or provide support for this application for native Elasticsearch integration in this product, please reach out to its vendor. (by Kapsh、 tpdi、 cletus、 gsnerf、 Kevin Williams、 majkinetor) 參考文件 Mentioned tools are not more then few MBs in size and it takes 1 minute to install them and copy them to your portable location. Sql Buddy Very nice one, has all of the above features plus its more feature filled as it was previously commercial. When it comes to stuff like this, I prefer portable tools. Installed once, you can put them on flash or CD and carry with you. Connecting to DB should be easy as filling out usual fields: server, user, pwd. I've tried the eclipse plugins as well. For me I'd rather keep eclipse optimized to do the work it's meant to do. I prefer DBVisualizer, but it's a bit of a memory hog so it might not be the right solution if your resources are an issue. Oracle SQL Developer: this is the poor man's tool you use on Linux when you don't have much other choice. It's fairly basic but OK given that it's free.Īlso a nice tool is the AquaDataStudio 方法 4:. SQL Server management Studio: comes with SQL Server. I don't think I really need much more for SQL Server than this except perhaps a better way of importing/exporting databases, soemthing for which this is garbage. Navicat for MySQL: it's OK but honestly I wouldn't pay for it. DBVisualizer: this tool isn't bad. I'm not sure the commercial version is worth the price they're asking for it. The free version is OK. It's good that it works with pretty much any database. Toad: Also Oracle‑specific. I used to be a big fan of this but it's expensive and I think more DBA‑oriented these days. For a developer I don't think it offers all that much (given the price difference) over PL/SQL Developer. PL/SQL Developer: as the name implies this is Oracle specific but is by far my favourite DB tool. It greatly simplifies import/export. It works very well for both sending SQL, rendering result sets, and allowing browsing of database objects (from a tree). For several RDBMS, it includes extensions to automatically generate common statements.Įspecially nice is that the query pane executes either the selected sql, or the line the cursor is on up to the first blank line. This allows you to write several statements, and to execute them either individually or in a batch. SQuirreL, written in java, will work with any RDBMS for which there's a JDBC driver. What tools do you use as developers to connect to the database of choice? I use Eclipse as an IDE. So any Eclipse specific tips are also appreciated.Įven if a tool were to work with one DB and not with the other, I am willing to look into it if it were more user‑friendly than the one the DB vendor provides. I am already using 3 different ones. I find these DB specific tools like SQL Query Analyzer (SQL‑Server), Oracle Enterprise Manager, MySQL Query Browser to be quite clunky and slow when it comes to running quick queries and looking at data directly. It is also hard to remember all the userids and pwds for the develop and test databases. I work with several different databases and find myself trying connecting to these quite often to test a query. I use the database specific tools to connect to the DB and run the query. 
直接訪問數據庫的開發人員工具 (Developer tools to directly access databases)
0 kommentar(er)
