Basic research is what I am doing when I don't know what I am doing.

Wernher von Braun

  • Meteor Classification

    I have been running some queries to classify the meteor types in the meteor visualisation data. I’m running the smallest groups first so that I can run one final ‘set empty classes to chondrite’ query at the end as they are by far the group with the biggest range of type codes in the table. The third of these queries felt distinctly middle-earthy, with all it ‘-ites’. I imagined this group of meteorite to be somewhat like the dwarves from ‘The Hobbit’. UPDATE `type_lookup` SET `Class` = ‘Iron (Chemical Classification)’ WHERE `Type` LIKE ‘Iron%’ UPDATE `type_lookup` SET `Class` = ‘Carbonaceous Chondrite’ WHERE `Type` LIKE ‘C%’ UPDATE `type_lookup` SET `Class` = ‘Achondrite’ WHERE `Type` LIKE ‘Eucrite%’ OR `Type` LIKE ‘Howardite%’ OR `Type` LIKE ‘Diogenite%’ OR `Type` LIKE ‘Shergottite%’ OR `Type` LIKE ‘Nakhilites%’ OR `Type` LIKE ‘Chassigniteite%’ OR `Type` LIKE ‘Lunar%’ OR [...]

    Categories:Web Design|MySQL

  • Tweet

    For once #Edinburgh is brightening for home time after having been #dreich all day rather than vice versa

    Categories:General

    Tags:

  • Tweet

    Found out how to make a ~/.bashrc for git bash on windows to alias commands with options, all my defaults are belong to me now

    Categories:General

    Tags: