Database query: Notification about change?
От | Erik Sigra |
---|---|
Тема | Database query: Notification about change? |
Дата | |
Msg-id | 4394855E.6060201@kth.se обсуждение исходный текст |
Ответы |
Re: Database query: Notification about change?
|
Список | pgsql-sql |
Hi, I plan to develop an application that is somewhat like a spreadsheet with cells containing formulas. When a cell value is changed, things must be updated. But the formulas can contain database queries, which means that the cell has to be notified when the database changes in such a way that the result of the query changes. How is this done? I would really like to avoid recalculating the whole thing for each change to the database. I looked in my database book and read about materialized views and triggers. It seems like I should do the following: 1. Make a materialized view from the query. 2. Add a trigger for changes to this view. 3. Make the trigger notify the application program when it is trigged. Would this be possible? (I was planning to use Qt for application programming and database access.) Thanks, Erik
В списке pgsql-sql по дате отправления: