For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Is it possible to determine whether an Apex application is being viewed in either Android, IOS or a non-mobile operating system?
The reason is I have an HTML feature I want to switch off on mobile browsers. Is there a way to do that?
Since Oracle database is not the best place to store video and image in BLOB datyatype Any evidence to substantiate this claim? Or is it a cyber ninja there must be bamboo in the paper thing?? Come on!! I'm waiting for some ignoramus to tell me that my APEX video training channel for our corporate customers that plays videos from database BLOBs is a figment of my imagination. And also justify your double posting https://community.oracle.com/tech/developers/discussion/4486743/java-app-and-video-files-persistent-layer
HI Billyt Thank you for your comment.
I just don't understand why you are so aggressive in your post.
My intention is just to do a brainstorm, where people can share their experience, detailing what technologies are the best practices for storing videos.
What I meant when I wrote "Oracle database is not the best technology to store videos" in BLOB format in a transactional database is because it will use a lot of space, and the response time for the query may not be good. But this is just my observation, don't be offended by it.
If you want to share your experience in storing videos in the Oracle database, it will be appreciated.
If anyone else had a positive experience in storing video on the Oracle database, and could detail how it was implemented and if you had a good response time to query the video in the App, it would be much appreciated.
Criticising the Oracle database as a matter of course without any justification rubs me the wrong way. Especially when this warrantless and evidence lacking statement is made as fact by Java and NoSQL developers that typically are extremely ignorant of the RDBMS technology in general, and of the Oracle database technology specifically. What I meant when I wrote "Oracle database is not the best technology to store videos" in BLOB format in a transactional database is because it will use a lot of space, and the response time for the query may not be good. Untrue. You do not understand "transactional". Overheads of a billion transactions on commit is the same as that of a single row. None. The same applies to a 1KB row or a 10GB row. A transaction is not needed for reading a BLOB in order to video play it. And the shared read lock on the row is no different than a shared file lock on a video file on a cooked file system in order to prevent the file from being deleted by one process while being played by another. BLOBs do not consume more space just because. Default block size is 8KB. Response time is as fast as accessing a video file by path and filename from a cooked file system - if not faster when using raw striped disks via Oracle ASM. It comes down to optimal and effective I/O. Which the mature Oracle database technology excels at. And that the typical Java developer know nothing of, based on my two decades of experience dealing with Java developers. The Oracle database has nothing to prove in that it is capable of storing and serving BLOBs effectively and efficiently. You however needs to proof that this is not the case if you want to dispute it.
Does anyone else have positive experience in storing videos without using a relational database that can share a real implementation, and not just a speech without having been implemented in a company? I would really appreciate it.
Thanks in advance.
Oracle NoSQL Database provides a Large Object interface that is intended to be used to read and write large objects such as audio or video data. See: https://docs.oracle.com/en/database/other-databases/nosql-database/21.1/java-api/oracle/kv/lob/package-summary.html
Thanks Tim, that's exactly what I was looking for.
Cheers.