BaseX 8.0: DBA
Friday, 12 December 2014 · 13 messages · last reply 15 Dec 2014
CG
Christian Grün12 Dec 2014 00:30 #
Hi all,
This is yet another update on the next, upcoming version of BaseX:
We have added a new database administration (DBA) web frontend to our ZIP and EXE distributions. It allows you to create and administrate databases, evaluate queries in realtime, view log files, manage users, and more. It was completely written with XQuery and RESTXQ, apart from a few lines of Javascript code.
The new frontend was added due to the known shortcomings of the Java GUI, which cannot be used to run queries on other servers. As a consequence, we have removed the server dialog from the desktop application. We hope that DBA will help you to write your own web applications based on RESTXQ!
Some more infos and design goals can be found in our Wiki [1].
Have fun, we are looking forward to your feedback,
Christian
PS: NO, the web frontend does not provide all the cute features of the desktop gui, like the treemap, scatterplot, syntax highlighting, etc… But it may provide some of them in future. Your contributions are welcome!
[1] http://docs.basex.org/wiki/DBA
FE
Fabrice Etanchaud12 Dec 2014 09:18 #
Dear Christian,
Do I have to download a module ?
I have the following error :
HTTP ERROR 400
Problem accessing /dba. Reason:
Stopped at C:/Program Files (x86)/BaseX/webapp/dba/modules/html.xqm, 8/66: [XQST0059] Module 'http://exquery.org/ns/request' not found.
Best regards,
Fabrice
-----Message d'origine-----
Quoted text · Christian Grün · 12 lines
De : basex-talk-bounces at mailman.uni-konstanz.de [mailto:basex-talk-bounces at mailman.uni-konstanz.de] De la part de Christian Grün Envoyé : vendredi 12 décembre 2014 00:30 À : BaseX; BaseX Objet : [basex-talk] BaseX 8.0: DBA Hi all, This is yet another update on the next, upcoming version of BaseX: We have added a new database administration (DBA) web frontend to our ZIP and EXE distributions. It allows you to create and administrate databases, evaluate queries in realtime, view log files, manage users, and more. It was completely written with XQuery and RESTXQ, apart from a few lines of Javascript code. The new frontend was added due to the known shortcomings of the Java GUI, which cannot be used to run queries on other servers. As a consequence, we have removed the server dialog from the desktop application. We hope that DBA will help you to write your own web applications based on RESTXQ! Some more infos and design goals can be found in our Wiki [1]. Have fun, we are looking forward to your feedback, Christian PS: NO, the web frontend does not provide all the cute features of the desktop gui, like the treemap, scatterplot, syntax highlighting, etc… But it may provide some of them in future. Your contributions are welcome! [1] http://docs.basex.org/wiki/DBA
FE
Sorry,
The upgrade was not consistent.
Everything is ok now.
Thank you for the web administration console !
Best regards,
-----Message d'origine-----
Quoted text · Fabrice Etanchaud · 23 lines
De : Fabrice Etanchaud Envoyé : vendredi 12 décembre 2014 09:18 À : BaseX Objet : RE: [basex-talk] BaseX 8.0: DBA Dear Christian, Do I have to download a module ? I have the following error : HTTP ERROR 400 Problem accessing /dba. Reason: Stopped at C:/Program Files (x86)/BaseX/webapp/dba/modules/html.xqm, 8/66: [XQST0059] Module 'http://exquery.org/ns/request' not found. Best regards, Fabrice -----Message d'origine----- De : basex-talk-bounces at mailman.uni-konstanz.de [mailto:basex-talk-bounces at mailman.uni-konstanz.de] De la part de Christian Grün Envoyé : vendredi 12 décembre 2014 00:30 À : BaseX; BaseX Objet : [basex-talk] BaseX 8.0: DBA Hi all, This is yet another update on the next, upcoming version of BaseX: We have added a new database administration (DBA) web frontend to our ZIP and EXE distributions. It allows you to create and administrate databases, evaluate queries in realtime, view log files, manage users, and more. It was completely written with XQuery and RESTXQ, apart from a few lines of Javascript code. The new frontend was added due to the known shortcomings of the Java GUI, which cannot be used to run queries on other servers. As a consequence, we have removed the server dialog from the desktop application. We hope that DBA will help you to write your own web applications based on RESTXQ! Some more infos and design goals can be found in our Wiki [1]. Have fun, we are looking forward to your feedback, Christian PS: NO, the web frontend does not provide all the cute features of the desktop gui, like the treemap, scatterplot, syntax highlighting, etc… But it may provide some of them in future. Your contributions are welcome! [1] http://docs.basex.org/wiki/DBA
AB
Hi Christian,
The DBA looks good.
One comment inspired by a quick play with it. It does not show the name of the logged in user. Indeed I have previously looked to get this information and it does not seem to be available via any BaseX function. Is this intentional?
/Andy
Quoted text · Christian Grün · 31 lines
On 11 December 2014 at 23:30, Christian Grün <christian.gruen at gmail.com> wrote: > > Hi all, > > This is yet another update on the next, upcoming version of BaseX: > > We have added a new database administration (DBA) web frontend to our > ZIP and EXE distributions. It allows you to create and administrate > databases, evaluate queries in realtime, view log files, manage users, > and more. It was completely written with XQuery and RESTXQ, apart from > a few lines of Javascript code. > > The new frontend was added due to the known shortcomings of the Java > GUI, which cannot be used to run queries on other servers. As a > consequence, we have removed the server dialog from the desktop > application. We hope that DBA will help you to write your own web > applications based on RESTXQ! > > Some more infos and design goals can be found in our Wiki [1]. > > Have fun, we are looking forward to your feedback, > Christian > > PS: NO, the web frontend does not provide all the cute features of the > desktop gui, like the treemap, scatterplot, syntax highlighting, etc… > But it may provide some of them in future. Your contributions are > welcome! > > [1] http://docs.basex.org/wiki/DBA >
FE
Fabrice Etanchaud12 Dec 2014 11:07 #
And maybe an indication of the current administrated instance ?
Best regards,
Fabrice
Quoted text · Andy Bunce · 30 lines
De : basex-talk-bounces at mailman.uni-konstanz.de [mailto:basex-talk-bounces at mailman.uni-konstanz.de] De la part de Andy Bunce Envoyé : vendredi 12 décembre 2014 11:01 À : Christian Grün Cc : BaseX; BaseX Objet : Re: [basex-talk] BaseX 8.0: DBA Hi Christian, The DBA looks good. One comment inspired by a quick play with it. It does not show the name of the logged in user. Indeed I have previously looked to get this information and it does not seem to be available via any BaseX function. Is this intentional? /Andy On 11 December 2014 at 23:30, Christian Grün <christian.gruen at gmail.com<mailto:christian.gruen at gmail.com>> wrote: Hi all, This is yet another update on the next, upcoming version of BaseX: We have added a new database administration (DBA) web frontend to our ZIP and EXE distributions. It allows you to create and administrate databases, evaluate queries in realtime, view log files, manage users, and more. It was completely written with XQuery and RESTXQ, apart from a few lines of Javascript code. The new frontend was added due to the known shortcomings of the Java GUI, which cannot be used to run queries on other servers. As a consequence, we have removed the server dialog from the desktop application. We hope that DBA will help you to write your own web applications based on RESTXQ! Some more infos and design goals can be found in our Wiki [1]. Have fun, we are looking forward to your feedback, Christian PS: NO, the web frontend does not provide all the cute features of the desktop gui, like the treemap, scatterplot, syntax highlighting, etc… But it may provide some of them in future. Your contributions are welcome! [1] http://docs.basex.org/wiki/DBA
ML
Hi Christian,
the feature is excellent. It definitely helps us in managing remote DBs that run on headless machines.
It happens, from time to time, that we need to modify one single attribute or text() in an XML resource. By now we access the resource via REST GET, copy and paste it into a tool like Postman change it there and then run the REST PUT on the URL.
Since the dba is doing already good part of the job it would be nice to be able to modify the XML inline (in the textarea) and re-save the resource. Maybe one could add a Modify button to the Rename, Download, Replace toolbox that appears on top of textarea displaying the resource.
Thanks for the useful addon.
M.
P.S. I completely overlooked that the
RESTXQPATH been reset to 'restxq'? It took me 10 minutes to understand why I wasn't able to run dba! ;-DQuoted text · Andy Bunce · 31 lines
> On 11 December 2014 at 23:30, Christian Grün > <christian.gruen at gmail.com <mailto:christian.gruen at gmail.com>> wrote: > > Hi all, > > This is yet another update on the next, upcoming version of BaseX: > > We have added a new database administration (DBA) web frontend to our > ZIP and EXE distributions. It allows you to create and administrate > databases, evaluate queries in realtime, view log files, manage users, > and more. It was completely written with XQuery and RESTXQ, apart from > a few lines of Javascript code. > > The new frontend was added due to the known shortcomings of the Java > GUI, which cannot be used to run queries on other servers. As a > consequence, we have removed the server dialog from the desktop > application. We hope that DBA will help you to write your own web > applications based on RESTXQ! > > Some more infos and design goals can be found in our Wiki [1]. > > Have fun, we are looking forward to your feedback, > Christian > > PS: NO, the web frontend does not provide all the cute features of the > desktop gui, like the treemap, scatterplot, syntax highlighting, etc… > But it may provide some of them in future. Your contributions are > welcome! > > [1] http://docs.basex.org/wiki/DBA >
CG
Thanks all for the first DBA feedback. Will be incorporated before the official release.
Quoted text · Andy Bunce · 41 lines
On Fri, Dec 12, 2014 at 11:01 AM, Andy Bunce <bunce.andy at gmail.com> wrote: > Hi Christian, > > The DBA looks good. > One comment inspired by a quick play with it. It does not show the name of > the logged in user. Indeed I have previously looked to get this information > and it does not seem to be available via any BaseX function. Is this > intentional? > > /Andy > > On 11 December 2014 at 23:30, Christian Grün <christian.gruen at gmail.com> > wrote: >> >> Hi all, >> >> This is yet another update on the next, upcoming version of BaseX: >> >> We have added a new database administration (DBA) web frontend to our >> ZIP and EXE distributions. It allows you to create and administrate >> databases, evaluate queries in realtime, view log files, manage users, >> and more. It was completely written with XQuery and RESTXQ, apart from >> a few lines of Javascript code. >> >> The new frontend was added due to the known shortcomings of the Java >> GUI, which cannot be used to run queries on other servers. As a >> consequence, we have removed the server dialog from the desktop >> application. We hope that DBA will help you to write your own web >> applications based on RESTXQ! >> >> Some more infos and design goals can be found in our Wiki [1]. >> >> Have fun, we are looking forward to your feedback, >> Christian >> >> PS: NO, the web frontend does not provide all the cute features of the >> desktop gui, like the treemap, scatterplot, syntax highlighting, etc… >> But it may provide some of them in future. Your contributions are >> welcome! >> >> [1] http://docs.basex.org/wiki/DBA
CG
Hi Andy,
Quoted text · Andy Bunce · 1 line
> It does not show the name of the logged in user.
True! It now does.
Quoted text · Andy Bunce · 3 lines
> Indeed I have previously looked to get this information > and it does not seem to be available via any BaseX function. Is this > intentional?
Information on the logged in user is stored in a session variable, which I am requesting via the Session Module (see global.xqm and users.xqm).
In the long term, I would like to bring database and RESTXQ users closer together, as they have many similar properties. Commands like SHOW USERS or KILL could then be extended to also work for users that are registered via HTTP sessions.
I have just uploaded a new snapshot. In the "Users" panel, under "Browser Sessions", all users are now listed who are currently logged in in the DBA.
Cheers,
Christian
JC
Hi,
is there a way to use the DBA frontend with a war BaseX version?
Thank you.
Jérôme.
Quoted text · Christian Grün · 28 lines
Le 12/12/2014 00:30, Christian Grün a écrit : > Hi all, > > This is yet another update on the next, upcoming version of BaseX: > > We have added a new database administration (DBA) web frontend to our > ZIP and EXE distributions. It allows you to create and administrate > databases, evaluate queries in realtime, view log files, manage users, > and more. It was completely written with XQuery and RESTXQ, apart from > a few lines of Javascript code. > > The new frontend was added due to the known shortcomings of the Java > GUI, which cannot be used to run queries on other servers. As a > consequence, we have removed the server dialog from the desktop > application. We hope that DBA will help you to write your own web > applications based on RESTXQ! > > Some more infos and design goals can be found in our Wiki [1]. > > Have fun, we are looking forward to your feedback, > Christian > > PS: NO, the web frontend does not provide all the cute features of the > desktop gui, like the treemap, scatterplot, syntax highlighting, etc… > But it may provide some of them in future. Your contributions are > welcome! > > [1] http://docs.basex.org/wiki/DBA
--
Jérôme Chauveau - SAIC-CERTIC - Campus 4
Université de Caen Basse-Normandie
CG
Christian Grün15 Dec 2014 12:59 #
Hi Jérôme,
Quoted text · Jérôme Chauveau · 1 line
> is there a way to use the DBA frontend with a war BaseX version?
I should be no problem I guess. What have you tried so far?
Christian
Quoted text · Jérôme Chauveau · 40 lines
> > Thank you. > > Jérôme. > Le 12/12/2014 00:30, Christian Grün a écrit : > >> Hi all, >> >> This is yet another update on the next, upcoming version of BaseX: >> >> We have added a new database administration (DBA) web frontend to our >> ZIP and EXE distributions. It allows you to create and administrate >> databases, evaluate queries in realtime, view log files, manage users, >> and more. It was completely written with XQuery and RESTXQ, apart from >> a few lines of Javascript code. >> >> The new frontend was added due to the known shortcomings of the Java >> GUI, which cannot be used to run queries on other servers. As a >> consequence, we have removed the server dialog from the desktop >> application. We hope that DBA will help you to write your own web >> applications based on RESTXQ! >> >> Some more infos and design goals can be found in our Wiki [1]. >> >> Have fun, we are looking forward to your feedback, >> Christian >> >> PS: NO, the web frontend does not provide all the cute features of the >> desktop gui, like the treemap, scatterplot, syntax highlighting, etc… >> But it may provide some of them in future. Your contributions are >> welcome! >> >> [1] http://docs.basex.org/wiki/DBA > > > > -- > Jérôme Chauveau - SAIC-CERTIC - Campus 4 > Université de Caen Basse-Normandie >
JC
Jérôme Chauveau15 Dec 2014 13:21 #
Hi Christian,
i tried to copy the dba directory into the basex webapp one:
.../tomcat7/webapps/basex8
+ data
+ *dba*
+ WEB-INF
[...]
But I get this error at http://localhost:8080/basex8/ :
message _Stopped at /var/lib/tomcat7/webapps/BaseX80/dba/login.xqm, 118/18: [XPST0081] No namespace declared for '
user:list-details'._
That's the wrong way I guess...
Jérôme.Quoted text · Christian Grün · 47 lines
Le 15/12/2014 12:59, Christian Grün a écrit : > Hi Jérôme, > >> is there a way to use the DBA frontend with a war BaseX version? > I should be no problem I guess. What have you tried so far? > > Christian > > >> Thank you. >> >> Jérôme. >> Le 12/12/2014 00:30, Christian Grün a écrit : >> >>> Hi all, >>> >>> This is yet another update on the next, upcoming version of BaseX: >>> >>> We have added a new database administration (DBA) web frontend to our >>> ZIP and EXE distributions. It allows you to create and administrate >>> databases, evaluate queries in realtime, view log files, manage users, >>> and more. It was completely written with XQuery and RESTXQ, apart from >>> a few lines of Javascript code. >>> >>> The new frontend was added due to the known shortcomings of the Java >>> GUI, which cannot be used to run queries on other servers. As a >>> consequence, we have removed the server dialog from the desktop >>> application. We hope that DBA will help you to write your own web >>> applications based on RESTXQ! >>> >>> Some more infos and design goals can be found in our Wiki [1]. >>> >>> Have fun, we are looking forward to your feedback, >>> Christian >>> >>> PS: NO, the web frontend does not provide all the cute features of the >>> desktop gui, like the treemap, scatterplot, syntax highlighting, etc… >>> But it may provide some of them in future. Your contributions are >>> welcome! >>> >>> [1] http://docs.basex.org/wiki/DBA >> >> >> -- >> Jérôme Chauveau - SAIC-CERTIC - Campus 4 >> Université de Caen Basse-Normandie >>
--
Jérôme Chauveau - SAIC-CERTIC - Campus 4
Université de Caen Basse-Normandie
CG
Christian Grün15 Dec 2014 13:23 #
Hi Jérôme,
Quoted text · Jérôme Chauveau · 2 lines
> message Stopped at /var/lib/tomcat7/webapps/BaseX80/dba/login.xqm, 118/18: > [XPST0081] No namespace declared for 'user:list-details'.
I got it… DBA only works with the latest snapshot of BaseX, as it uses requires some features like to the new User Module [1].
Hope this helps?
Christian
[1] http://docs.basex.org/wiki/User_Module
Quoted text · Jérôme Chauveau · 61 lines
> > That's the wrong way I guess... > > Jérôme. > > > > Le 15/12/2014 12:59, Christian Grün a écrit : > > Hi Jérôme, > > is there a way to use the DBA frontend with a war BaseX version? > > I should be no problem I guess. What have you tried so far? > > Christian > > > Thank you. > > Jérôme. > Le 12/12/2014 00:30, Christian Grün a écrit : > > Hi all, > > This is yet another update on the next, upcoming version of BaseX: > > We have added a new database administration (DBA) web frontend to our > ZIP and EXE distributions. It allows you to create and administrate > databases, evaluate queries in realtime, view log files, manage users, > and more. It was completely written with XQuery and RESTXQ, apart from > a few lines of Javascript code. > > The new frontend was added due to the known shortcomings of the Java > GUI, which cannot be used to run queries on other servers. As a > consequence, we have removed the server dialog from the desktop > application. We hope that DBA will help you to write your own web > applications based on RESTXQ! > > Some more infos and design goals can be found in our Wiki [1]. > > Have fun, we are looking forward to your feedback, > Christian > > PS: NO, the web frontend does not provide all the cute features of the > desktop gui, like the treemap, scatterplot, syntax highlighting, etc… > But it may provide some of them in future. Your contributions are > welcome! > > [1] http://docs.basex.org/wiki/DBA > > > -- > Jérôme Chauveau - SAIC-CERTIC - Campus 4 > Université de Caen Basse-Normandie > > > > -- > Jérôme Chauveau - SAIC-CERTIC - Campus 4 > Université de Caen Basse-Normandie
JC
Jérôme Chauveau15 Dec 2014 15:57 #
Sorry - I understood it was only available in .zip and .exe distributions. DBA frontend seems to be very nice - good job!
Thank you for your help!
Jérôme
Quoted text · Christian Grün · 74 lines
Le 15/12/2014 13:23, Christian Grün a écrit : > Hi Jérôme, > >> message Stopped at /var/lib/tomcat7/webapps/BaseX80/dba/login.xqm, 118/18: >> [XPST0081] No namespace declared for 'user:list-details'. > I got it… DBA only works with the latest snapshot of BaseX, as it uses > requires some features like to the new User Module [1]. > > Hope this helps? > Christian > > [1] http://docs.basex.org/wiki/User_Module > > >> That's the wrong way I guess... >> >> Jérôme. >> >> >> >> Le 15/12/2014 12:59, Christian Grün a écrit : >> >> Hi Jérôme, >> >> is there a way to use the DBA frontend with a war BaseX version? >> >> I should be no problem I guess. What have you tried so far? >> >> Christian >> >> >> Thank you. >> >> Jérôme. >> Le 12/12/2014 00:30, Christian Grün a écrit : >> >> Hi all, >> >> This is yet another update on the next, upcoming version of BaseX: >> >> We have added a new database administration (DBA) web frontend to our >> ZIP and EXE distributions. It allows you to create and administrate >> databases, evaluate queries in realtime, view log files, manage users, >> and more. It was completely written with XQuery and RESTXQ, apart from >> a few lines of Javascript code. >> >> The new frontend was added due to the known shortcomings of the Java >> GUI, which cannot be used to run queries on other servers. As a >> consequence, we have removed the server dialog from the desktop >> application. We hope that DBA will help you to write your own web >> applications based on RESTXQ! >> >> Some more infos and design goals can be found in our Wiki [1]. >> >> Have fun, we are looking forward to your feedback, >> Christian >> >> PS: NO, the web frontend does not provide all the cute features of the >> desktop gui, like the treemap, scatterplot, syntax highlighting, etc… >> But it may provide some of them in future. Your contributions are >> welcome! >> >> [1] http://docs.basex.org/wiki/DBA >> >> >> -- >> Jérôme Chauveau - SAIC-CERTIC - Campus 4 >> Université de Caen Basse-Normandie >> >> >> >> -- >> Jérôme Chauveau - SAIC-CERTIC - Campus 4 >> Université de Caen Basse-Normandie
--
Jérôme Chauveau - SAIC-CERTIC - Campus 4
Université de Caen Basse-Normandie
Written for BaseX 7.9. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery