Shulou(Shulou.com)06/01 Report--

Southbank Software recently released dbKoda 0.6.0, the first release of the software. DbKoda is an open source MongoDB development tool developed using JavaScript, React and Electron. The following figure shows the graphical user interface of dbKoda, which is characterized by the provision of a connection manager (Connection Manager) and a code editor (Code Editor), in which the code editor gives rich MongoDB data manipulation features.

Connection Manager

The connection manager maintains configuration information (Profile) for multiple database connections. In the lower half of the connection manager window, a list of each active database connection and its corresponding collection (Collection) is displayed. Clicking the right mouse button brings up a series of menu options, including building queries, performing CRUD operations, indexing, and importing and exporting data (as shown on the left side of the figure below). The connection configuration information editor is used to create a new database connection, which supports all forms of database connection syntax (as shown on the right side of the following figure).

Code editor

The code editor includes a query input and output window, which is used to write and execute Shell commands for MongoDB. The editor's features include code formatting, code completion, code folding, and syntax highlighting. Users can manually write the query in the code editor, or you can use the query builder to build the query, as shown in the following figure. The query builder can dynamically generate the corresponding MongoDB Shell commands in the code editor. This feature is useful when writing complex MongoDB Shell commands, eliminating a series of tedious operations on how to format braces and parentheses correctly.

In Southbank Software's latest release of dbKoda version 0.7.0, the following new features are provided:

Aggregation Builder (Aggregation Builder); Storage drilldown (Storage Drilldown); SSH Tunnel connection (SSH Tunneling Connections); improved JSON Viewer; Import and Export.

The aggregation builder functions like a query builder, supporting the construction of more complex queries that require aggregate aggregate functions. In the following example, the publications collection (Collection) uses the $lookup operator to perform an inner join operation with the authors collection.

Db.publications.aggregate ({"$lookup": {"localField": "author_id", "from": "authors", "foreignField": "_ id", "as": "authorinfo"}})

As shown in the following figure, the aggregation builder can dynamically generate internal join operations by entering only what is required for key ranges such as localField, from, foreignField, and as.

CTO Guy Harrison of Southbank Software gave an interview to InfoQ about dbKoda products.

InfoQ: where is the inspiration for developing dbKoda products?

Guy Harrison: when I wrote next Generation Database (Next Generation Databases), I was acutely aware that we were in the middle of a third revolution in database systems. A new generation of database professionals need a new generation of database tools. Considering that I have a background in database and software development, I think I should try to start a company to launch the next generation of database tools.

Why does InfoQ:dbKoda choose MongoDB as its first choice?

Harrison: there are many outstanding people in the "NoSQL" ecosystem, and the first thing I can think of are Cassandra, Couchbase, Hadoop, park and Neo4J. But in terms of the fact that MongoDB currently has 30 million downloads, it is far ahead.

InfoQ: will dbKoda provide support for other databases in the future? If so, which databases will it support? What about the time node?

Harrison: we do plan to provide support for more databases in the coming year, including some relational databases and some non-relational databases.

How will InfoQ:dbKoda develop in the future? Can you give us a detailed introduction to the plan for version 1.0?

Harrison: we are currently working to provide deeper support for developers using MongoDB in frameworks such as NodeJS, including providing SQL query capabilities (through Apache Drill) and improving query construction and output processing.

We expect that version 1.0 will have order-based hosting capabilities and will be a server-oriented product version that includes more in-depth performance analysis, collaboration features, and ongoing support for programmers to support the framework for MongoDB programming.

InfoQ: how long have you been with Southbank Software? Could you tell us something about your current duties?

Harrison: I am CTO and founder of Southbank Software and partner of Toba Capital. Toba Capital is one of the venture capitalists who invest in dbKoda. I have multiple responsibilities, including enterprise management, product feature design, writing automated tests, and coding some features. Our team has six full-time dbKoda developers.

Harrison gives a five-minute YouTube video that shows how to get started with dbKoda.

Check the original English text: Southbank Software Introduces dbKoda, an Open Source Database Development Tool for MongoDB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.