This solution will probably do the trick, but it’s clunky and limiting. The other available option is to show exactly five columns, and choose which field each column displays. Frustratingly, there’s no scrolling left and right, so the columns just get squished together:

Sometimes your documents all have the same structure, but if there’s even a little variety this gets impractical fast. In the table view, you can ‘show all columns’, meaning one column for every field found in any of the documents. For each database, Fauxton lets you view documents in their native JSON, or as a table. In all the databases we’re looking at, documents are written and stored as JSON. It runs as part of the server itself and is accessible by browser at /_utils. Fauxton is built on top of this API with each page representing an equivalent endpoint – but only some of the endpoints. Couch’s primary interface is an HTTP API, typically used through cURL. Let’s get started, going from most basic to most advanced.ĬouchDB is a mature database with plenty of features, but its GUI Fauxton (formerly named Futon) is pretty minimal. High availability through clustering is important when you have many concurrent users solving bottlenecks is important if you need to improve the speed of heavy queries, and so on. Obviously this all depends on your specific needs. Clustering – tne rationale for the creation of the first “NoSQL” databases was the need for horizontal scalability – so we might expect the GUI to help visualize and manage a distributed database.It’s especially important that the GUI provide event logs and performance stats for debugging and identifying bottlenecks. But the cost of freedom is that you’re more likely to run into gotchas. Stats & metrics – to oversimplify, document dbs give you more freedom than relational dbs.Here too, each database has a different approach that needs to be learned. Visualizing how data is processed – indexes, projections, queries, and especially aggregations like mapreduce are easier to analyze and keep track of with flow charts and other aids.This can be a hassle, but good GUIs can help you write queries and indexes well before you’re fluent. Learning to query – each database we’ll look at has its own query syntax in lieu of SQL.So how can groups of documents with different structures be displayed and compared in a compact way? Comparing lots of data – unlike the rows in a relational table, documents don’t have to obey a schema.and finally RavenDB’s Studio, which I’d argue is the best management GUI in the field.īesides the usual features a database management system should have, I want to see how each GUI handles the demands specific to document stores.The popular third-party MongoDB tool Studio 3T.In this article I want to compare the different ways GUIs have been implemented for three document databases: There’s a lot to learn and keep up with, and a much higher proportion of developers that are new to the field. Document databases are a diverse group of technologies, relatively young, and rapidly evolving in different directions. This is even more important outside the familiar world of relational databases, where people generally know the score. When a system breaks in production, a good GUI shows you what’s going on under the hood, while a bad GUI leaves you guessing. One diagram is worth a thousand stack overflow threads, as they say.įor veterans, a GUI should not just expose all the functionality of the database, but simplify or automate routine tasks. When you’re looking for the right database, it’s easy to forget the part of the database that’ll most affect your experience in practice: the user interface.įor new developers, an intuitive and ‘discoverable’ GUI can be just as important as documentation. You trip over shell commands, squint at piles of vague error messages, and wish you had an interface that would let you just… see. Is the network down? Is a server on fire? Is it caused by faulty business logic, or maybe a rare race condition? During development, it took hours to diagnose a problem. It’s the busiest night of the year, and your whole website just crashed.

Mongodb compass vs studio 3t