The diary entries of a little girl in her 30s! ~ Part 2
Feb 22, 2013 at 4:54 PM Post #6,676 of 21,761
Quote:
Quote:
Wait, I'm still trying to wrap my head around why someone would even want to do the above?  Things don't code themselves right?  So at some point in time, some bloke was attempting to accomplish something, and I can't figure out what that might be given the method used.

I may have been a bit too fast with my text. The context is respondents: they have personal information, such as addresses, phone numbers, and so on. These respondents can either respond "yes" or "no" to be in a certain study. There is a certain point in keeping them in a register no matter whether they wish to participate or not, for instance for the sake of not having to ask them twice, or more. Now, these respondents, that will participate, can:

A) have said yes, but have yet to actually sign papers on participation and have yet to answer the survey

B) have said yes and signed the papers, but have yet to actually answer the survey

C) have said yes, signed the papers but have an incomplete survey, as in having only partially participated

D) signed, participated, answered everything

Those who haven't done it all, will need reminders and the system creates reports each week for who remind and so on. This bloke created a myriad of different tables to keep these respondents in and moves them around from table to table depending on a, b, c or d.

I hope I made it easier to visualize lol.

 
Haha, okay.  And forgive me if I'm not taking something vital into account, but wouldn't it have been like way easier to just throw all of these states into a separate table?  I'm being a little frivolous with storage space here, but the separate table could just track ID (a meaningful one of course), the current state, and maybe a timestamp?  That way it could also account for a person's change in state over time.  Oh, and while we're at it, maybe introduce a few new columns to account for the multiple variables involved?  Then we don't have to do something stupid like set up enum fields for every possible permutation.
 
Then the bloke could just run a query for all people whose last known state is whatever state they want to isolate?
 
It can't be this simple, I've gotta be missing something here.
 
Feb 22, 2013 at 4:57 PM Post #6,677 of 21,761
Have to admit I haven't paid a lot of attention to mobile devices, but the impressions I've seen of the Meridian DAC were that it was overly smooth, not very detailed and altogether not so great.
 
Feb 22, 2013 at 5:25 PM Post #6,678 of 21,761
Quote:
 
Sounds like a predecessor had to build a relational database out of somebody else's over-leveraged Excel macros. It's never fun cleaning up other people's work, is it? 

1. Correct, a predecessor
2. Incorrect, this was created in Access at around year 2008 when the study started (he had moved to Access long before that, but he has at least ten spreadsheets linked as well as ten different Access backends)
3. Correct, it is not fun.
(4. Yeah, I know, I still have yet to PM you a clarification of my last question about trends in web developing)
Quote:
 
Haha, okay.  And forgive me if I'm not taking something vital into account, but wouldn't it have been like way easier to just throw all of these states into a separate table?  I'm being a little frivolous with storage space here, but the separate table could just track ID (a meaningful one of course), the current state, and maybe a timestamp?  That way it could also account for a person's change in state over time.  Oh, and while we're at it, maybe introduce a few new columns to account for the multiple variables involved?  Then we don't have to do something stupid like set up enum fields for every possible permutation.
 
Then the bloke could just run a query for all people whose last known state is whatever state they want to isolate?
 
It can't be this simple, I've gotta be missing something here.

Actually, you're pretty darned close, but it is a little simpler than that.
 
The "predecessor" created different tables for a, b, c, d and non-participants. He also created tables for those need to be reminded in 1, 2, 3 or 4 weeks. He then let's his software move the respondents from table to table depending on at which stage they are in: have they said yes, have they signed, have they completely answered a survey or just partially, and so on. "Somehow", last week, 10 respondents went missing (LOL, what a shocker, right?) and are probably somewhere to be found - it's just I don't know where and no, there is no documentation available at all, and no, he didn't name the tables logically like "Respondent" or something along those lines. For example, he has saved close to 100 different SQL queries, all named Query1, Query2, Query3, Query4 etc.
 
He was hi-tech enough to name a column to iStatus though! I have no idea what that status is, only that it can be a number from 1 to 6. At least he knew about camelcasing, although, he could've just gotten inspired by an iPod.
 
I'm not entirely sure that he knows what WHERE is used for in SQL.
 
 
Oh well, I'm at home now. That database can wait to monday. The error wasn't vital.
 
Feb 22, 2013 at 5:44 PM Post #6,679 of 21,761
Quote:
Have to admit I haven't paid a lot of attention to mobile devices, but the impressions I've seen of the Meridian DAC were that it was overly smooth, not very detailed and altogether not so great.

 
Really?  I'd have to say that I found the opposite to be true. 
 
I believe I was listening to 24/96 rips in Apple lossless at the time.  But for me, it had offered quite a bit of detail without being grating or overly harsh.  I'd agree with the assessment of smoothness in so far as it had no hint of graininess, but I wouldn't classify it as lacking in detail in any way (at least not in this class or price range).  It is definitely a step up from the HeadStreamer I'm using now, that is for sure.
 
EDIT:  I was particularly impressed with the low noise floor (as discerned by my ears) and its dynamic range.  All in all, it was a very enjoyable listen for me.
 
BTW, I especially like the pairing of the Explorer with Mad Dogs.  That was quite a treat for me. 
smile.gif

 
Quote:
Quote:
 
Haha, okay.  And forgive me if I'm not taking something vital into account, but wouldn't it have been like way easier to just throw all of these states into a separate table?  I'm being a little frivolous with storage space here, but the separate table could just track ID (a meaningful one of course), the current state, and maybe a timestamp?  That way it could also account for a person's change in state over time.  Oh, and while we're at it, maybe introduce a few new columns to account for the multiple variables involved?  Then we don't have to do something stupid like set up enum fields for every possible permutation.
 
Then the bloke could just run a query for all people whose last known state is whatever state they want to isolate?
 
It can't be this simple, I've gotta be missing something here.

 
Actually, you're pretty darned close, but it is a little simpler than that.
 
The "predecessor" created different tables for a, b, c, d and non-participants. He also created tables for those need to be reminded in 1, 2, 3 or 4 weeks. He then let's his software move the respondents from table to table depending on at which stage they are in: have they said yes, have they signed, have they completely answered a survey or just partially, and so on. "Somehow", last week, 10 respondents went missing (LOL, what a shocker, right?) and are probably somewhere to be found - it's just I don't know where and no, there is no documentation available at all, and no, he didn't name the tables logically like "Respondent" or something along those lines. For example, he has saved close to 100 different SQL queries, all named Query1, Query2, Query3, Query4 etc.
 
He was hi-tech enough to name a column to iStatus though! I have no idea what that status is, only that it can be a number from 1 to 6. At least he knew about camelcasing, although, he could've just gotten inspired by an iPod.
 
I'm not entirely sure that he knows what WHERE is used for in SQL.
 
Oh well, I'm at home now. That database can wait to monday. The error wasn't vital.

 
Well, look on the bright side, at least he didn't nest all those queries (Query1, Query2, Query3, Query4 etc.).  God, please tell me he didn't nest queries.  On the surface I'd think he probably doesn't know how to do that, given that WHERE is lost on him, but assumptions regarding the limits of foolishness are usually wrong.
 
LOL @ the "iStatus"
 
Was actually talking to a buddy of mine in Sweden last night.  I think he's very happy about the weekend as well.  Happy weekend!
 
Feb 22, 2013 at 6:00 PM Post #6,681 of 21,761
Like I said I don't really read portable reviews so maybe I only saw one of the bad ones.
 
Feb 22, 2013 at 6:13 PM Post #6,682 of 21,761
Quote:
Okay, obviously it would still work some added logic with having three different tables and so on. I mean, all roads lead to Rome, and this is mostly true in computer science as well. But it certainly isn't a secure way of doing things, to have a person duplicated and then the first copy of it deleted. I just wish that in 10 years, someone isn't going to have these kinds of rants about software and systems that I develop. 
size]

 
I'm only an amateur coder and even I can tell that is a horribly stupid way of doing things. The only reason I could think to do something like that in separate tables is if I didn't know how to do do a SELECT WHERE query and thus I wanted to keep the tables separate and readable.
 
And @Muppetface, why is it that whenever you get new hardware it's likely borked in some way? You've been cursed! :p
 
Feb 22, 2013 at 6:19 PM Post #6,686 of 21,761
Quote:
Have to admit I haven't paid a lot of attention to mobile devices, but the impressions I've seen of the Meridian DAC were that it was overly smooth, not very detailed and altogether not so great.


I once did a portable DAC comparison at a meet with many options, and I chose (and bought) an iBasso D10.  The D12 is very similar to a D10, except it uses dual DAC chips for more dynamic range.
 
I also compared desktop DACs and my favorite was the Lavry DA11.  Jude owns two of those (one for the office and one for home).  I'm really curious about the Lynx Hilo though, because Lynx claims it's their best performing DAC/ADC, and it has lots of cool routing options.
 
Best bang for the buck in desktop DACs might be Ross Martin Audio.  He uses state of the art DAC chips with direct coupled balanced analog designs, and his stuff is under $400.  (It's a tiny company and hand built products though, which may be a pro or a con.)
 
Feb 22, 2013 at 6:29 PM Post #6,687 of 21,761
By the way diary threaders, I suppose I should come out of the closet Jodie Foster style. (That is to say, awkwardly and in a roundabout way.)
 
I've been making headphone review youtube videos lately (I fell in with a bad crowd and felt pressured to do it). It's a way I can hopefully get some people interested in some of the more fun aspects of the hobby as well as get information out there about some flaws of some of these products that never really seem to get mentioned.
 
The youtube channel is here but I only really like the most recent videos when I've a) figured out how to get consistently decent lighting b) learnt to stop trying to do the entire review in one take c) learnt to stop scratching my nose or something in the middle of takes d) relaxed a little more
 
Eventually I want to go through all the stuff I have and like. It would be nice to see the SA5000 get a little more love and the T50RP get a little more recognition...
 
http://www.youtube.com/user/lachlanlikesathing/videos
 
Feb 22, 2013 at 6:48 PM Post #6,690 of 21,761
Quote:
A_rec's hair is just tops.

 
I've actually been getting comments in some of the videos about it.
 
Actually, the other day I went to get a bit of a hair cut. I finally went to a place in Newtown (kind of a more punk / alternative / bohemian area of Sydney) and where all the scene kids got their hair cut and coloured into all kinds of crazy shades. I had the strange role reversal of feeling out of place at the salon because I wasn't asking for a haircut that was out there enough (as opposed to the opposite situation) but they were real nice and didn't really skip a beat when I told them my long term goal was to essentially have a girls haircut and length of hair lol.
 

Users who are viewing this thread

Back
Top