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.
Galaxy S II X-ray
A new Orthoscan mini C-arm arrived at the hospital last week, so while I was doing the acceptance testing on it today I used it to get a shot of my Galaxy S II.
The big grey blob in the middle is the battery and the vertical stripe in the battery I’m guessing is the NFC antenna. The square just below the top would be the camera. The square to the left of that just below the top is the front facing camera. On the right side is the headphone jack. The rectangular thing at the bottom to the right of the USB/HDMI connector is the speaker I think.
Need fatter intertubes
I’ve been thinking about getting more bandwidth lately. The 1.5 Mbps DSL from Earthlink has been ok so far. No complaints and I’ve only lost service once or twice since I’ve had it. With Netflix in the house now pushing the issue I decided to look into it.
Earthlink advertises up to 6 Mbps DSL service. In an initial online chat I was told that there were no faster speeds available in my area, which is unfortunate. I might actually have to call to confirm this.
AT&T’s DSL page tells me that DSL isn’t available for my location (WTF?) although I can get U-Verse apparently (maybe they want to phase out DSL?).
Cable internet through Comcast would be the other option.