[CONNECTORS-824] For files,support file path index

• Type: Wish
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: ManifoldCF 1.4.1
• Component/s: JDBC connector
• Labels: CLOB

Environment

When connect database tables, fetch the binary files from the table.

• Assignee: Unassigned
• Reporter: summersmile
• Created: 02/Dec/13 02:11
• Updated: 15/May/14 11:43
• Resolved: 15/May/14 11:43

Description

For most Content Management System, binary files such as office format attachment, zip files are not stored as CLOB or BLOB in DB. They usually stored as a binary file in the filesystem or a NAS system, even urls for cloud file system, And stored the path in the

{file_path}

column on db's table. So if manifold could support a general api to get different store implementation would better.The only cms I knew stores file as CLOB is SharePoint. Most popular cms such as Wordpress doesn't use that solution.