Timeline for What algo/design pattern do i need to keep limited time series data constantly updated?
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 30, 2017 at 23:08 | history | edited | LeeRoy | CC BY-SA 3.0 | added 1434 characters in body |
| Aug 30, 2017 at 22:01 | history | tweeted | twitter.com/StackSoftEng/status/903014752976240645 | ||
| Aug 30, 2017 at 14:38 | comment | added | Blrfl | The very short summary would be that you put your measurements into the database and write queries to ask it questions and do maintenance like pruning old data. You still have to specify what you want in the queries (e.g., SELECT AVG(pressure) WHERE <condition>), but the database organizes the data and you're not stuck having to write new code when your questions change. SQLite is more than capable enough for an application like yours and gives you the option of running in memory if you don't care about persistence or on disk if you do. | |
| Aug 30, 2017 at 0:58 | comment | added | LeeRoy | @Blrfl, could you give me some insight into how a DB could be used to run these arithmetic calcs because I believe I'd still have to write the arithmetic calculations "from scratch" even if using a DB...unless I'm missing something. My main concern is how to model the data in the application so as to most efficiently run the arithmetic calculations. Thanks for your help, too. | |
| Aug 30, 2017 at 0:54 | comment | added | LeeRoy | John Wu, you're right. I could update the user's view each second or every two seconds and be fine...and save resources Thank you for challenging what I was thinking. Like I said, I'm not a pro. | |
| Aug 29, 2017 at 8:57 | comment | added | gnat | please don't cross-post: stackoverflow.com/questions/45928084/… "Cross-posting is frowned upon as it leads to fragmented answers splattered all over the network..." | |
| Aug 29, 2017 at 2:40 | comment | added | John Wu | Who is reading the output-- a machine or a person? If a person, why would they need an update as many as 20 times per second? | |
| Aug 29, 2017 at 2:31 | answer | added | Steve Barnes | timeline score: 1 | |
| Aug 29, 2017 at 1:34 | comment | added | Blrfl | Is there some reason you're writing all of this from scratch when you could be dumping the data into a database and letting it do the heavy lifting? | |
| Aug 29, 2017 at 0:05 | answer | added | Erik Eidt | timeline score: 5 | |
| Aug 28, 2017 at 23:03 | review | First posts | |||
| Aug 29, 2017 at 8:35 | |||||
| Aug 28, 2017 at 22:59 | history | asked | LeeRoy | CC BY-SA 3.0 |