Yes I agree with you. If databases exposed their change-logs and audit-logs as queriable schemas then a lot of the application-level event-queues-in-the-database would not be necessary, or greatly simplified.
I have lots of wishes in that direction. For example, I wish that my programs could ask 'has this table been written to since I last checked' instead of having to read all the price lists into the application cache every n minutes whether there have been any changes or not etc.
Comments
Yes I agree with you. If databases exposed their change-logs and audit-logs as queriable schemas then a lot of the application-level event-queues-in-the-database would not be necessary, or greatly simplified.
I have lots of wishes in that direction. For example, I wish that my programs could ask 'has this table been written to since I last checked' instead of having to read all the price lists into the application cache every n minutes whether there have been any changes or not etc.
+1
I only want READ access to the change logs and audit logs...if databases only did this, it would be so much better.