The HD video (superfine 1920×1080) from my Galaxy S II gobbles up storage at a rate of about 2 MB per second of video.
I haven’t checked how fast the other resolutions use up space, but it will be less than this.
I’m going to need a bigger SD card to put into this thing.
SQL subqueries and joins
A while back, a script I had written to dig stats out of our PACS database stopped working for some reason. Since I was mostly done with that project, I didn’t mess around with it too much.
Now I’ve been asked to resurrect it to gather more usage data in advance of a planned migration.
The PACS database uses Oracle, but all my DB experience is with MySQL. This is the main query I’m dealing with (it runs from a shell script, which is why the variables are there)
select
count(study_uid),
avg(num_images),
sum(num_images),
max(num_images),
min(num_images)
from dosr_study
where study_ref in (
select
study_ref
from dosr_series
where modality='${modality}'
)
and study_date between
'${c_year}${c_month}01' and '${c_year}${c_month}31'
For some reason this query stopped running. Well, it runs, but it just doesn’t spit out any numbers like it used to.
If I reformulate the query into what I think is the equivalent query without the subquery,
select distinct
count(study_uid),
avg(num_images),
sum(num_images),
max(num_images),
min(num_images)
from dosr_study, dosr_series
where dosr_study.study_ref = dosr_series.study_ref
and dosr_series.modality='${modality}'
and study_date between
'${c_year}${c_month}01' and '${c_year}${c_month}31'
the query works, but returns different results from what I got before when the original query worked.
I suppose I’ll need to find out more about Oracle SQL so I can figure out why the original query stopped working in the first place.
Update: One of my friends thinks I probably haven’t rewritten the query correctly (what I was thinking as well) and suggested changing
from dosr_study, dosr_series where dosr_study.study_ref = dosr_series.study_ref
to
from dosr_study join dosr_series on dosr_study.study_ref=dosr_series.study_ref
Galaxy S II X-ray Take 2
I was doing some testing on a radiographic room today and took the opportunity to get a better x-ray image of my Galaxy S II. This was acquired using 80 kV, 5 mAs with a little bit of magnification.
Compared to the previous x-ray I took, the NFC antenna integrated into the battery looks like it’s probably the series of concentric traces, like those RFID security tags you find in books and stuff. The components on the circuit boards are also much more visible in this one.
Golden Ticket camera
Anybody who follows me on Twitter or Facebook or the blog knows I like to take pictures of my food and post them.
Andra introduced me to the Foodspotting app early last year and since then most of my food photos have been going there and cross-posting to Twitter and Facebook.
In December, Foodspotting ran a Golden Ticket promo contest where they hid Golden Tickets (think Charlie and the Chocolate Factory) within the app. You ‘found’ them by browsing through food pictures that other people posted.
Just after I saw the email about the Golden Ticket promotion, I found one, much to my surprise. That it was a Golden Ticket for a wee little Sony WX9 camera was an even bigger surprise.
Haven’t tried it out yet. It’s still charging up. Fortunately Sony saw fit to design the camera so that it uses SD cards (which I already have) as well as their own Memory Sticks (which I don’t have). Unfortunately they decided to use a micro-USB like connector, so that means another USB cable dangling off my computer.
Looking forward to playing with this new little camera. Thanks Foodspotting!
An afternoon at Lighthouse Inlet
An overcast day spoiled my plans to do some star trail photography at Lighthouse Inlet, at the north end of Folly Beach. I did get some nice beach photos though, before the cold wind made my hands too stiff to handle the camera. I did end up losing a lens cap to the surf though. At least it wasn’t a camera.
There is of course the view of the Morris Island lighthouse. See what I did with the lighthouse on Sullivan’s Island in the background?
and plenty of old tree skeletons buried in the sand
This might be one of my favourites from the day. The bright green provides some great contrast against the tangled gray/brown of the branches.
Check out the rest of the images over in the gallery.