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 …
Category: Coding
Using a window function in SQL to find the shortest viable data period for multiple items
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
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 …