Eg kjøpte meg gønnar i går, og fekk med dette flotte tilbodet:
Archive for the 'The adult' Category
Arrived in Longyearbyen. Apparently I’ve taken my diurnal rhythm out behind the barn and shot it, which partially explains why I showed up at the office at 4 AM today. Booze cheap, but I haven’t got my rationing card yet. Everything else expensive. Not eaten by bear yet. No reindeer, either. Odd. No northern lights yet.
I’ve quit my old job (spending my last vacation days now) and gone home to mom and dad. My teensy apartment in Oslo is searching for a new tenant, and in a week I’ll go north, north, north, a bit west to start my Ph.D.
Did I mention it’s good to have friends? It’s good to have friends. I wouldn’t have made it out of that apartment in time without a little help from my friends. A lot of help.
Since I’ve announced it everywhere else, I might as well say it here, too: I’ve got a new job. At New Year’s, I’ll be moving to Longyearbyen to study polar cap patches, an obscure phenomenon in dayside northern lights. If all goes well, I’ll have a Ph.D. to my name in three years.
Oh, one more thing:
Wheeeee!
Or “new apartment”, as some would call it. This one has a number of advantages over and disadvantages under the old one: It’s significantly smaller, it doesn’t have a dishwashing machine, the floor is new, there’s no freezer, it’s still piled full of things I haven’t managed to unpack and stow, the bathroom is tiny, it’s in a much nicer neighborhood, it’s closer to work, the bathroom is nice and shiny, it’s mine, all mine.
I’m back. It was a hectic week. But fun. Seems I know what BLAST does now. Nice to have my ideas adjusted by the experts.
So, I’ve been in Cold Spring Harbor Laboratory (NY) since Tuesday, learning about computational and comparative genomics. It`s been very interesting. Lots of information-dense lectures and workshops about things I need or will need to work with when I return to Oslo. And the culture shock hasn’t been too bad. Food as expected: Sweet and greasy. But frequently good. Lecturers very good. And the other participants are an interesting bunch, plus the lab itself is a nice place. I have some pictures in my camera, that magical place they seem to never leave.
Three squared years since I was born. Doubleprime! Whee!
You gotta keep on movin’!
Well, not really, but anyway I did. New apartment and suchlike. The old one is very nearly empty, but needs washing. The new one is piled up with disassembled bookshelves and bed. One of these days I’ll find time to unpack and assemble. For now I’ve just got the bare essentials up and running.
Having made the necessary agreements to move base, will now erect a secret secondary base downtown. Immediate plans for the future include redesignating said new urban base as primary base within two months, and then officially terminate operations at current forest base. More to come.
I need to use MySQL in one of the projects at work. Fair enough, databases are useful little thingies. Big thingies. Frustrations mount quickly, though.
Example.
- Dataset in text file contains N unique rows which I may want to update now and then.
- N is large.
- No column value is unique to each row, so there is no natural primary key.
- Every row is guaranteed to be unique.
- Does MySQL have some operator, procedure, function or command I can use to avoid duplicate rows when updating database from new text source? Can’t find any.
