Hi!
I wonder if anyone can help me decide how to implement a filter function. What I want to do is present a TableView, which is populated from an SQLite database (using the DBUtils module) and let the user apply filters on this TableView. My idea is to have a filter field for every column, where the user can input desired filters. I also want the filter to be applied everytime a filter field is modified.
The alternatives I see are:
1: Reload the TableView from the database with the filter applied in SQL.
2: Apply the filter on the data set in the TableView without involving the database.
I suppose both alternatives are doable, but what would you suggest? Is there a best practice here or does it depend on requirements on speed, amount of data or other factors? My goal is only to learn - I don't have any specific application in mind
I wonder if anyone can help me decide how to implement a filter function. What I want to do is present a TableView, which is populated from an SQLite database (using the DBUtils module) and let the user apply filters on this TableView. My idea is to have a filter field for every column, where the user can input desired filters. I also want the filter to be applied everytime a filter field is modified.
The alternatives I see are:
1: Reload the TableView from the database with the filter applied in SQL.
2: Apply the filter on the data set in the TableView without involving the database.
I suppose both alternatives are doable, but what would you suggest? Is there a best practice here or does it depend on requirements on speed, amount of data or other factors? My goal is only to learn - I don't have any specific application in mind