I think this is going to be one of those weekends where I’ve over-committed myself just a little bit. That’s what I get for doing things without consulting the all-mighty calendar first.
First there’s volunteering at the aquarium. The Camp Carolina exhibit has gone away to make room for a new Madagascar exhibit, so it will be interesting to see what kind of progress has been made in the last two weeks.
Then a quick run to pick up this week’s Ambrose Farm CSA and then off to the fairgrounds for the Charleston Kennel Club dog show. Always a fun time there.
From there it’s out to Folly Beach for a second attempt at doing some star trails. Hopefully I haven’t run into my second battery by then, otherwise I won’t be doing star trails for very long.
Then if I haven’t completely worn myself out, dig into the stack of papers I’m supposed to be reading to prepare for writing the proposal for my PhD qualifer.
Sunday is all dog show and more reading.
Whee.
Fat video
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!