FILES/ PDF in database

Rhythmyx Technical Discussion
1

Does Percussion stores the files/pdfs in the Database schema? If so, are they also versioned? Which table does it stores the CLOB for the pdf files?

thanks
Manvinder

2

Hi,

They are in db table rxs_ct_sharedbinary …with their respective revision.

3

Thanks very much for your response. Another question in continuation of this discussion is:

Does that means whenever we create a content item of type rffImage or rffFile, then the actual image/ pdf file is always stored as a BLOB in the table rxs_ct_sharedbinary?

Does a copy of the jpg/ pdf file also gets stored on the filesystem of the Rhythmyx server?

thanks
Manvinder

4

Hi,

We don’t use fast forward images and file content types. We have custom files and images which do get stored in the same rxs_ct_sharebinary table as the out of the box ones…whenever a content item of those types are created.

In our implementation the binaries are stored in the db…we wouldn’t want them on the file system as well. I cannot think of any reason why you would want to duplicate them on the file system.

J

5

[QUOTE=manvinder12;16889]
Does that means whenever we create a content item of type rffImage or rffFile, then the actual image/ pdf file is always stored as a BLOB in the table rxs_ct_sharedbinary?

Does a copy of the jpg/ pdf file also gets stored on the filesystem of the Rhythmyx server?[/QUOTE]

The file is always stored as a BLOB in the rxs_ct_shared, or whatever shared or local table the field is associated with. No copy is stored on the file system for management.

When you publish, a copy will be output to the target publish location, as defined by the Location Scheme.

RLJII