|
|
|
|
|
|
by timeseries2018
2777 days ago
|
|
|
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. |
|
|