The duckbase DuckDB, which specializes in data analysis and evaluation, provides a new local web user interface from version 1.2.1, which can be used alternatively to CLI. The new UI is part of the UI extension and the database -based server service provider DuckDB goes back to the combined development of labs and madrasak. According to the announcement, the UI should mainly work with long-term SQL Querry and data exploration and should be configured more easily than the UI available by third-party providers for DuckDB.
The UI is applied through the DuckDB extension that embedded a local HTTP server. It serves the browser application and also provides an API for communication with the database. Thanks to the local DuckDB for example direct connections, developers have complete access to computer resources including RAM and file system.
Local web user interface of DuckDB UI from 1.2.1 of the database.
(Image: duckdb)
In a window on the left edge of the web user interface, database, files and, if necessary, are listed, loaded URLs and the URLs loaded with the ideas available in it. With one click, detailed information such as the number of lines, name and type columns can also be seen a profile of data contained. UI interactive notebooks, which provide syntax highlighting and an automatic complete function when creating questions, to define the SQL script and display the results of the questions. The column on the right edge of the surface summarizes explorer results, but allows you to achieve even more deep insights in each column. If the developers want to share files and tables beyond the local environment, for example for joint processing in the team, the madrasak service can be directly reached through a button in UI navigation.
DuckDB UI and UI Extension Has been since publication Bugfix release 1.2.1 The database is officially available under co-licenses. In Blog post for announcement However, the DuckDB team suggests the local web user interface that there is no open source code of the front in the repository as it has not yet been released as an open source-but there are views.
(Map)
