Your media content storage would be of type BLOB(binary large objects) if
saved in DB.
You can definitely store your images on local file system and have a table
with the reference to the media file on your file system.
--Deepak
···
On Wed, Jan 30, 2013 at 4:02 PM, avadhani ramakrishna < avadhanirk.507@gmail.com> wrote:
Hai Everyone.
I have implemented ODK server in my machine using both MySQL as well as
PostgreSQL databases and ODKAggregate 1.0.2 installer file. The data is
perfectly storing in both the databases. While checking the tables having
image/video data, it is storing in a binary format. Obviously that's fine.
But, My Superior came up with a thought saying that "Find the process in
such a way that the images/video data tables must contain the data like
image_name, image_path_in_server and the media content should be saved in
original format in file system(currently in my machine)". Can i achieve
that? Please provide your thoughts for implementing this.
If you need the images as files on a server, consider running ODK Briefcase
nightly to download the files to your system. The briefcase storage
location will contain directories for each data instance, and within those,
it will contain the associated audio/video/image files. You could then
archive the entire ODK Briefcase directory as a separate form of data
backup from the database backups you should already be performing.
···
------------
Note also, that on MySQL, BLOB data is always stored as separate files
already. So this is already being done by MySQL under the covers. Making
this explicit in the application layer doesn't make a whole lot of sense.
It also is impossible to do on Google AppEngine, and will complicate the
scaling of the system if you need to run multiple webservers accessing a
common database. Scaling would require adding network storage,
administering access to that, and handling failures when NFS or Samba
mounts fail (and they do fail). Restoring mounts is not always 100%
automatic.
Doing anything like this is truly not worth the added trouble.
Your media content storage would be of type BLOB(binary large objects) if
saved in DB.
You can definitely store your images on local file system and have a
table with the reference to the media file on your file system.
I have implemented ODK server in my machine using both MySQL as well as
PostgreSQL databases and ODKAggregate 1.0.2 installer file. The data is
perfectly storing in both the databases. While checking the tables having
image/video data, it is storing in a binary format. Obviously that's fine.
But, My Superior came up with a thought saying that "Find the process in
such a way that the images/video data tables must contain the data like
image_name, image_path_in_server and the media content should be saved in
original format in file system(currently in my machine)". Can i achieve
that? Please provide your thoughts for implementing this.