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!
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.
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.
the ISP gets paid for