Re: [sqlite] Question about the update of tuples in sqlite-views

Views don't have any particular materialization or storage, it's just a select statement that is merged into your query every time you select something from the view. So to answer your question only changed tuple in the table is updated physically, views don't need to be updated. But in practical

Re: [sqlite] Question about the update of tuples in sqlite-views

Hi, a view does not need to be updated. Think of a view as a stored select statement. Martin Koston, Thorsten (ICT) wrote: > Hello, > > i have a question about the update machanism for tuples in different > views: > > For example from a table we have three different views. > How will be the

[sqlite] Question about the update of tuples in sqlite-views

Hello, i have a question about the update machanism for tuples in different views: For example from a table we have three different views. How will be the view updated if one Tuple updated or changed from the DB? (a) only the particular Tuple updated in the different view? (b) or updated the