search

sirixdb / sirix-web-frontend

A web front-end for SirixDB based on Nuxt.js/Vue.js, D3.js and Typescript
https://sirix.io
17 stars 20 forks source link

TreeView to display databases and resources #30

Open JohannesLichtenberger opened 5 years ago

JohannesLichtenberger commented 5 years ago

Displaying databases and resources in a TreeView similarly to other database system front-end as for instance pgadmin. We can use the password credentials flow in the first place with an admin/admin username/pass posted to the login endpoint. We need to change this obviously in the next step.

  1. Setup Keycloak and the SirixDB HTTP-server
  2. Get a token by POST https://localhost:9433/login with JSON data: 
    {
"username": "admin",
"password": "admin"
}
  3. GET https://localhost:9443: provide HTTP authorization bearer token, which you got in step 2.

To get a simple list of databases {"databases": [{"db1": "xml", "db2": "json"]}

  1. If a user expands and logs in to a database (tree-view is clicked): provide HTTP authorization bearer token, which you got in step 2.

  2. Then we can link the JSON or XML tree-view... and the other views in the future.

tashachin commented 4 years ago

Can you explain to me the purpose of this issue like I'm five years old? I want to understand the scope of this problem.

JohannesLichtenberger commented 4 years ago

It's as simple as having a tree view of databases on the root level and as children of each database the stored resources. Then, when clicking on a resource the first 1000 lines or something like that should be displayed (serialized back to XML or JSON). Even better for an overview are space filling approaches for the hierarchical structures as for instance a Sunburst-View and a Treemap.

You should be able to view whats stored in SirixDB and to some extend manipulate and store new revisions.