Datomic Console

29 October 2013

[Update: Watch the intro video.]

The Datomic Console is a graphical UI for exploring Datomic databases.

The Datomic Console interface: a schema tree and data sources on the left; Query, Entities, Transactions, and Indexes tabs with a query builder and results pane on the right.

It supports exploring schema, building and executing queries, navigating entities, examining transaction history, and walking raw indexes. The Datomic Console is included in Datomic Pro, and is available as a separate download for Datomic Free users.

Exploring Schema

The upper left corner of the console displays a tree view of the attributes defined for the current database.

The Schema panel: a tree of artist attributes (country, gid, name, and so on), with the name attribute expanded to show its cardinality, value type, and other properties.

Query

The Query tab provides two synchronized views of queries: a graphical builder, and the equivalent textual representation.

The Query tab showing a graphical query builder (Find, In, and Where clauses) beside the equivalent textual Datalog query.

You can see the results of a query in the Dataset pane on the lower right.

The Data Set results pane listing query results in two columns — entity references paired with their documentation strings.

Entities

The Entities tab provides a tree view of an entity, plus the ability to drill in to related entities.

The Entities tab showing one artist entity (Foo Fighters) — its attributes such as country, name, and start year, plus expandable reverse references to related releases and tracks.

Transactions

The Transactions tab provides a graphical view of the history of your database at scales ranging from days down to seconds.

The Transactions tab: a bar chart of transaction counts per minute for one hour, with controls to zoom in and out over time.

When you zoom in, the specific datoms in a transaction are displayed in the dataset pane.

Indexes

The Indexes tab allows you to browse ranges within a Datomic index, displaying results in the dataset pane.

The Indexes tab: form fields for browsing the AVET index by attribute and value to retrieve matching datoms or an index range.

And More

This post only scratches the surface, see the full docs for more details. You can save arbitrary datasets, giving them a name for reuse in subsequent queries. And, of course, you can use Datomic’s time features to work with as-of, since, and historical views of your data.

← Previous post The Transaction Report Queue Next post → Datomic Pro Starter Edition