Skip to content

cushtie.com

The best thing you haven't read yet

Category: Coding

Salad and SQL

19 March, 2014 James ForemanCoding

This afternoon, my manager asked me what I would do, if I had to make a choice between salad and SQL. This is obviously a difficult question to answer, given that one option is a[…]

Continue reading …

Using a window function in SQL to find the shortest viable data period for multiple items

16 January, 201416 January, 2014 James ForemanCoding

I have a large table of data, and the important columns for me are the clickdate, productid and clickcost columns. The cost represents how much I’ve spent on marketing the product. I want to look[…]

Continue reading …

A way to avoid some carelessness with postgres

14 November, 201314 November, 2013 James ForemanCoding

Part of my day job involves loading data from lots of different files into a database, and one way this can go horribly wrong is if I attempt to load the same file twice. Either[…]

Continue reading …
  • cushtie.com
  • Feeds
  • How
  • How to swear properly
  • Links
  • Setting Up Teams on Fumbbl
  • Sevens At The Seaside
  • Shuffling
  • Singapore Cyclocross
    • Singapore Cyclocross – Location
    • Singapore Cyclocross – Volunteering
    • Singapore Cyclocross – How to enter
    • Singapore Cyclocross – Rules
    • Singapore Cyclocross – Sponsors
  • What
  • When
  • Where
  • Who
  • Why
  • Winter Sunshine Bowl

Categories

  • Bicycles
  • Birthday
  • Blood Bowl
  • Books
  • Books For Baby
  • Climbing
  • Clothes
  • Coding
  • Comedy
  • Cooking
  • Cycling
  • Diet
  • Drinking
  • Eating
  • Etiquette
  • Existential Worry
  • Family
  • Film
  • Fitness
  • Food
  • Frustrations of the Modern Lifestyle
  • Gadgets
  • Grooming
  • History
  • Hong Kong
  • Housing
  • Illness
  • Injuries
  • Jokes
  • Language
  • Learning
  • Moving
  • Music
  • Nothing Much In Particular
  • Parenting
  • Pastimes
  • Photography
  • Programming
  • Reading
  • Resolutions
  • Restaurants
  • Reviews
  • Running
  • Seattle
  • Self Improvement
  • Shoes
  • Shopping
  • Singapore
  • Spanish
  • Swimming
  • Technology
  • Thinking
  • Travel
  • Uncategorized
  • Weddings
  • What Did I Learn
  • Work
  • Writing
  • Year Of Eating Differently

RSS Cushtie RSS

  • Late night climbing
  • Another rude awakening
  • The Haunting Of Drearcliff Grange School
  • Adventures in sleep deprivation
  • Three times more coffee than necessary

Subscribe via Email

Enter your email address to subscribe to cushtie.com.

Join 1,377 other subscribers

Proudly powered by WordPress | Theme: Oblique by Themeisle.