Alfresco database

Question

How can we expand the Alfresco database? I need to add new tables to an existing database structure.

Does alfresco support this?

thanks in advance, shri ..

Answer 1

I think alfresco db model change will never be a good solution. Some open-air updates are made using Upgrade Upgrade Scripts, and this can become messy.

Have you tried to expand the model of content in the open air? Alfresco supports some types of data, which allows you to save data. The Web Script structure allows you to manage all of your data within your content model.

If your data is not suitable for the "content model", I think you need to create a new database to store your data.

Answer 2

Well, it's just a database. Thus, you can create as many new tables as you want, as in any other database. Obviously, Alfresco will not use them because he does not know them, but you can query tables as you wish.

Answer 3

The advice of amateur engineers does not concern the alfresco database. Please take a look at this page. http://forums.alfresco.com/forum/general/non-technical-alfresco-discussion/where-alfreso-user-details-are-stored-i-alfresco

Answer 4

Modifying the alfresco database is not recommended. A content model would be a good way. If this requirement is mandatory than

You can use spring with hibernate to connect to the database. The properties required to connect the database are all declared inside alfresco-global.properties , which is located inside " tomcat / shared / classes / ".

For spring bean injection, you can declare beans inside any file that ends with "-context", which is inside the tomcat / shared / classes / alfresco / extension folder .

I still recommend the developer to use the content model.

Answer 5

Depending on your use case, you may or may not need to play directly with the database [/ a]. I think your use case should fall in one of the following options:

Usage Example 1: You need to configure some metadata in folders and / or documents. You may need to nest several levels of nodes with different sets of custom metadata at each level.

• You probably need to extend the alfresco models to define custom document and folder models that best suit your business requirements. Please check jpotts tutorial to find out how to do this.

Usage example 2: You need to define several lists with different sets of properties, these lists may or may not be associated with any content in your alfresco registry.

• You probably need to know more about the alfresco datalists sites , once you do, you may be interested to know how to expand the contents of the OOTB alfresco model, the jpotts tutorial will be a good starting point, and then you should check this tutorial to find out how manage datalists in standalone aikau / share applications.

Use Case 3: You need to use a relational database to identify and use complex business logic that does not fit into any of the use cases described above.

• Are you sure you do not want to encode a new application using a technology that you are familiar with and that it communicates with alfresco using RESTfull api / cmis / ....?
• Are you sure Alfresco is the way to go? If so, and you still want to have your custom business model in a simple relational database:
  • Please consider using a separate instance of the database / database for your custom extension, so you are sure that any new patch / update for alfresco that can change the database structure will not affect your extension (or at least , will not give you a hard time updating it).
  • If you are really attached to only one database instance / 1 database database schema, you probably want to precede the table names with some prefix and hope that no future updates in alfresco will have new tables with the same prefix. You probably also need to make sure that you correctly manage your database configuration (connection pools ..), so neither your alfresco instance nor your user extension should starve. (make sure you close the connections you open)

Answer 6

Alfresco and Activiti come with a database. It is not good to access the database directly. This can lead to unexpected blocking or exhaust connection pools in the database. This leads to performance problems, and other problems are possible. If you want to upgrade Alfresco or Activiti, you can do this through the API. Ease of distribution, ease of setup, and simplification of integration options are some of the reasons http://loganwinson.doodlekit.com/blog/entry/4249216/top-things-to-know-about-alfresco-development> Web Alfresco development is popular among enterprises.