Add additional table in nuxeo database

[gaosh]

In the custom addons ，  i want to record some info in the db and read them later。 i want to add new table (in vcs)  or new collection (in  dbs)。 How can i achieve this？

Are there any references or demos? Or a thought or a step?

[Josh-F-Hyland]

This isn't really how you're meant to use Nuxeo. VCS and DBS are abstraction layers. You shouldn't need to mess with them directly and, in this way, the backend database is fully pluggable. It's certainly *possible* for you to customize the platform and do whatever you want, but not recommended 🙂 I suppose you'd like to have some kind of simple key-value store? I would say there are a couple of options:

• Create a "settings" Document Type. You can simply store your "settings" using the data model. You can store each setting as a separate document or even using a single document (with a complex multi-valued field).
• Store "settings" in nuxeo.conf; you can retrieve them in Automation, for example, using the Env[] object, e.g. Env["my.cool.setting"]

[gaosh]

Much thanks  for your kindly reply ❤️. 

To be more specific, for example, I want to store a list of documents that one user has edited and a list of documents that one user has been opened and the  relative newest opened time and the newest  edited time for each document.   I need to retrieve these lists when needed. 

Where can I store this information and retrieve it later? My idea is to create a separate table to store this information asdescribed  in the previous question,  but I don’t know how to do it. 

Like you mentioned above, creating a new document type for this purpose?  Is any other method and how?  

[Josh-F-Hyland]

You can alternatively use local storage a la the "Recently Viewed" list that you see on the Web UI Dashboard (and to be clear I mean you'll need to investigate this widget using dev tools, there's no documentation that I'm aware of but it at least provides an example).

If the lists must be server side, it's a good use case for Collections IMO (https://doc.nuxeo.com/n/Rai).