Skip to Main Content

APEX

Announcement

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!

Determining an Apex User's Platform

ApexPhilFeb 15 2014 — edited Feb 20 2014

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?

This post has been answered by vincent_deelen on Feb 15 2014
Jump to Answer

Comments

Billy Verreynne

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

kazyskiyn0w

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.

kazyskiyn0w

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.

Billy Verreynne

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.

kazyskiyn0w

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.

Tim Blackman-Oracle
Answer

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

Marked as Answer by kazyskiyn0w · Jul 16 2021
kazyskiyn0w

Thanks Tim, that's exactly what I was looking for.

Cheers.

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2014
Added on Feb 15 2014
5 comments
572 views