-4

I want to monitor a " .db " continuously to see if it has been updated using python. And when the database is updated, I want to perform a certain task wrt what is updated. Any ideas?

This is the file I want to monitor. I specifically want to monitor the value column for change of bit from 1 to bit 0.

Improve this question
1
  • The question is too broad for monitoring by saying you want to monitor the db. With any client tool you may first want to define what you want to monitor. Another approach is to have triggers on every table, which i dont recommend. Commented Dec 21, 2015 at 15:13

1 Answer 1

Reset to default
3

It sounds like you want something like a trigger.

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

5 Comments

Could be the right answer. Pls provide more details why you suggest this approach and its limitations and I will upvote the answer. In this format, however, it feels more like a comment, than an answer.
i can only use the python prompt and cannot use sql language to control my hardware appliances. Please suggest a way to monitor database using python.
@ArohiGupta I would take a closer look at this answer which sounds similar to your situation: stackoverflow.com/questions/5771925/…
@Batman i want to run it on rpi. And i'm not running it on cmd.
Ya, this question seems to be out of the scope for this site without further research into this topic.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.