Changes

Since {{Version|8.0}}, the The full distributions of BaseX are equipped with a simple browser-based database administration interface, the '''DBA'''. It allows you to create and administrate databases, evaluate queries in real time, view log files, monitor logged-in users, manage users, etc. The browser frontend was server-side code is completely written in [[XQuery]] and [[RESTXQ]]. It allows you to create and administer database instances, evaluate queries, view log files and manage users.

If you put DBA online along with your web page, please ensure at the very least…* that you have chosen a strong password for your {{Code|admin}} user, and* that the BaseX process has not been started with admin privileges. =Startup= * Download the '''ZIP Archive''' or the '''Windows Installer''' from the [httphttps://basex.org/download download page]

* Open a browser and visit the URL {{Code|http://localhost:89848080/dba}} On the welcome page, you need to authenticate yourself by entering the name and password of a user with [[User Management|admin permissions]].

==Start Page=Logs=

On the welcome pageAll [[Logging|database logs]] are listed, ordered by creation time in descending order. The interactive filter allows you will need to authenticate yourself by entering a username search in the users and passwordtext columns via regular expressions. The default user is {{Code|admin}}/{{Code|admin}}. By specifying a host and port, you can communicate with a remote BaseX server instance. If you keep the field empty, you will be connected to found substrings are highlighted in the local BaseX instanceoutput.

<table cellpadding="0" cellspacingDatabases="0"><tr><td valign="top">The main page of the DBA interface contains a list of all databases on the left.On the right, the global and local options are listed, along with some systeminformation.

With The database panel contains a list of all databases. Databases can be created, optimized and dropped. If a database is selected, the "Create…" buttondatabase resources, a new backups and properties are listed. Queries can be run on single database resources. [[Image:DBA-Databases.png|778px|DBA Databases Panel]] =Queries= XQuery expressions can be createdrun in the Queries panel. If evaluation takes too long, or if it consumes too much memory, the execution will be interrupted. You can choose if your query is updating or not. Inside the editor area, you can press Ctrl-Enter to execute the query. You can press Shift-Ctrl-Enter to run your XQuery expression as updating query (or non-updating, if "Updating" is chosen in the dropdown menu). Existing database queries can be opened, and saved for future operations. All files will be stored in the current DBA working directory. =Files= Remote files can be vieweddownloaded, optimizedopened in the query editor or run as BaseX jobs, and droppednew files can be uploaded. The chosen directory affects the Queries panel. You can edit your RESTXQ code in real time by switching to the RESTXQ or repository directory and opening the corresponding modules.</td><td valign="top">[[Image:blaDBA-Files.png|thumb775px|DBA Main PageFile Panel]]<=Jobs= In the Jobs panel, all queries are listed that are currently being run or queued. You can view details on particular jobs, spot potential bottlenecks, or spot and terminate malicious requests. The panel will always list at least one job, which is the one that is currently preparing your HTTP response. =Users= Existing users can be updated and new users can be created. Extra information can be viewed and modified both globally and locally (see [[User Management]] for more information). =Sessions= The Web Sessions table lists all users that are currently registered in an application or the DBA. See the DBA RESTXQ code for information on how clients can be registered and logged out. The Database Sessions table shows clients that are connected via the client/td>server architecture. =Settings= </table>In the settings, you can tweak some DBA options, enforce a garbage collection and view all current global and local databases options.