nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Ambiguity related to alfresco database.

amit_wmw

Hello

Have a very basic question..When we upload a file(as a content) in repository, where does it actually gets saved? In DB or in alf_data directory? Or a part of content gets saved in alf_data and rest in DB? If that is the case which part is saved in DB and which in alf_data folder of alfresco server?

Can we able to the physically see files or at least metadata of files in either alf_data or DB? So that I can delete file (content) without using of Alfresco WCM GUI.

Thanks
Amit.

Find more posts tagged with

Comments

t_broyer

Have a very basic question..When we upload a file(as a content) in repository, where does it actually gets saved? In DB or in alf_data directory? Or a part of content gets saved in alf_data and rest in DB? If that is the case which part is saved in DB and which in alf_data folder of alfresco server?

The metadata live in the DB while the bytes are stored in "alf_data". The name of the file in alf_data is stored in the DB as the "cm:content" property.

Can we able to the physically see files or at least metadata of files in either alf_data or DB? So that I can delete file (content) without using of Alfresco WCM GUI.

Do not try to do this: the content is also indexed for searches, so deleting bits in the DB and bits in the filesystem is not enough to get rid of a document.

amit_wmw

Thanks Bro!

Any idea if we can save everything in DB without using file system? If so, what all and where all we need to do modification/s?

regards
Amit.

mrogers

Storing the content in a BLOB is a topic that has already been discussed in these forums.

There are performance concerns with the approach but nevertheless the following thread implies that some people have working implementations.
e.g. http://forums.alfresco.com/en/viewtopic.php?f=4&t=6603&p=40480

amit_wmw

Great! Thanks Rogers for your help!

Amit

amit_wmw

I have some questions on above said quote:

The metadata live in the DB while the bytes are stored in "alf_data". The name of the file in alf_data is stored in the DB as the "cm:content" property.

1) Can anyone also please clarify that when I save a file as a content in which table of database the metadata gets saved?

                                                                       OR

   In how a many parts a content (uploaded file by user) is broken into and in which all folders of alf_data does it gets scatters, then how these broken peices are linked to DB (in which all table)? In brief I mean relationship between alf_data and alfresco DB?

2) Is it possible to create my own table in alfresco DB and save my content in that table?

Thanks
Amit.