reading data only once in SQLite3 with Python

Question

I've a sqlite3 database in python which increments every second as new data arrives from sensors. I need to read the latest value only

However if there's 50 entries which I've already read once, with a new entry, I have to read all 50 items again before the 51st item

I want to avoid reading through the same data over and over so I've added a "ReadStatusFlag" column which will be 1 if unread and flagged to 0 once read to avoid. Primary key is TimeStamp.

Is there any better way? just want to explore various approaches.

If you are fetching the rows by SQL, articulating a query which fetches only the newest timestamp should be trivial. Are you having trouble phrasing this in SQL or did this obvious solution not occur to you? — tripleee
– tripleee, Commented Dec 22, 2017 at 7:13

MultiSkill · Accepted Answer · 2017-12-22 07:09:57Z

4

Select * from DataLog ORDER BY TimeStamp DESC LIMIT 1;

Adjust for your framework.

answered Dec 22, 2017 at 7:09

MultiSkill

4164 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

reading data only once in SQLite3 with Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related