News for hackers. Stuff that matters.

timeseries2018

Re:The making of an opioid epidemic on Thursday November 08, 2018 @04:46PM (#18410347)
Eventually, the economy will crash, or at least the cheap energy will run out, and then people will be forced to get tough again.
Re:How Dad's Stresses Get Passed Along to Offspring on Thursday November 08, 2018 @04:43PM (#18410316)
God, no. How do you decide what stack to work on? Should I use Python 2 for maximum compatibility, or Python 3 since it's the future? Should I spend my time on KDE or Gnome. Do I use Angular 2 or Angular 3? TypeScript or JavaScript? vi or emacs? Which flavor of Linux should I learn? Oh no, I chose wrong, everyone is getting $500k at a FAANG! I picked the wrong stack! I chose wrong! I lost years! I'm not getting any younger! I missed the opportunity!

Yeah, no.

Re:How Dad's Stresses Get Passed Along to Offspring on Thursday November 08, 2018 @04:40PM (#18410297)
You might have 99 problems, but writing an interesting and insightful Hacker News comment ain't one.
Re:Google Plans Large New York City Expansion on Wednesday November 07, 2018 @08:12PM (#18403677)
Doesn't a fintech programmer already make ~$450k (all in)
Re:Google Plans Large New York City Expansion on Wednesday November 07, 2018 @07:57PM (#18403600)
If there are good, seasoned engineers in Silicon Valley that can't pass the Google interview, they sure as hell can't find very many in Orlando or Des Moines.
Re:Why Not to Build a Time-Series Database on Wednesday November 07, 2018 @07:53PM (#18403577)
I've had great success using event timestamp ( milliseconds since 1970 ) as a column, with an index on it. And then when you query you can use BETWEEN. If you write your own ORM you can make it automatically calculate the time range according to some defaults - minute, second, etc. Works great.

If you are using spatial data, You can also use two columns like this for longitude and latitude.