Support browsing the content of a database

[rhdunn]

Support the following actions on a database:

• [ ] View the tree of folders/directories and files in the database.
• [ ] View the properties on a file (MarkLogic document properties).
• [ ] View the contents of a file.
• [ ] Save/edit the contents of a file (UI -- prompt to prevent accidental writing to the database).
• [ ] Delete a file/directory (UI -- prompt to prevent accidental writing to the database).

Databases:

• [ ] BaseX
• [ ] eXist-db
• [ ] MarkLogic

One possibility is to implement these using the IntelliJ virtual file system API.

[lguariento]

Hello, I'm interested in this feature. Is there any plan to implement it, or a workaround for that for eXist-db / Elemental users?

[rhdunn]

I would like to implement this but don't have the time. If you implement this I'm happy to merge the code.

My general ideas for this is/was to create a processing model interface (e.g. XpmDatabase) with implementations in the plugins that support it. These would make use of XQuery scripts to implement the various features (list files, read file content, etc.). -- See e.g. the implementation of the debugger support (esp. MarkLogic), log viewer, and test runner for how this would work.

I've not looked at the database APIs for IntelliJ so don't know what is needed to support it. However as it is an Ultimate-only feature it would need a compatibility shim in intellij-compat similar to how the microservices (REST API viewer) is implemented.