Amazon Video on Demand Review

I recently purchased a Roku box and noticed that one of the apps it came with is “Amazon Video on Demand.” Since our internet speed is not that great, I didn’t think that would work very well, so I made no plans to “rent” a video from Amazon.

Recently, I wanted to watch “Guardians of Ga’Hoole,” and since RedBox didn’t have it, I had to buy it. Target listed it for $30, but Amazon had it for $10 less, but I would have to wait with Amazon.

Hmmm….. Is $10 worth having it right now?

Then I noticed Amazon offered a free video on demand viewing with purchase. Ah, the pieces are starting to fit. I see how Amazon intends to compete now. Makes sense.

But, it won’t be blu ray quality. Will it be worth the $10 savings to watch it in lower quality? Will that be enjoyable, or will I feel like I settled for less?

I decided to give it a try. Trying it is really the only way to see if I’ll like it. And, I’ve noticed that the paid services on the Roku are superior to the free ones. Over my 1.5 Meg DSL connection, which runs from 0.9 to 1.2 Meg, HuluPlus looks really good on the Roku. Hulu still halts several times during a video.

Well, the results were surprising. The video quality, while not full HD, of course, was very good. Much more detail than I expected. More than enough to enjoy an animation like Guardians. And the video never paused. Not once.

So, would I rent a movie from Amazon? Maybe. But I’ll certainly buy a movie I want to see right now for a lower price and watch the video on demand copy they provide.

Published in: on December 28, 2010 at 8:30 am  Comments (3)  
Tags: , ,

Grab Tablename From Stored SELECT Statement Using Oracle’s REGEXP Functions

I have an sqltext column in my database that contains select statements like

  • select firstname, lastname from employees

  • select firstname, lastname from managers
    where empid = 21

I need to extract the tablenames from these statements. Here is my cheeseball solution:

trim(REGEXP_REPLACE(replace(sqltext,chr(10),' '),
'(.*)( from )(.*)( where .*)' ||case when instr(replace(sqltext,chr(10), ' '), ' where ') = 0 then '?' end,
from someTableThatContainsSqlText

Published in: on December 9, 2010 at 1:18 pm  Leave a Comment  
Tags: , ,