Fetching and Displaying Timeline Data

Question

I need some advice here:

I am working on an application that is supposed to display data in a timeline view with Weekly, Monthly and Yearly options. I have two options that I'm torn between;

I could fetch all the data at once and let the user interface display it in the timeline properly
I could fetch data every time the user toggles into the next period e.g. when they change into the next month, fetch data for that time range

I need some counsel here on which is the best approach?

score 1 · Accepted Answer · answered Sep 30 '18 at 18:14

1

Do this whole thing in the back-end, and then take the processed data in the front-end. Make a database query with respect to the timestamp. Use offset concept if you doing pagination stuff. P.S - Please mention the database you are using.

answered Sep 30 '18 at 18:14

Souvik Brahma

71
5

Thanks @Souvik for the advice, I'm on a Postgres database. – John Mutuma Oct 01 '18 at 06:15
Use OFFSET while using SELECT, this will help during pagination – Souvik Brahma Oct 02 '18 at 07:12

Fetching and Displaying Timeline Data

1 Answers1