We have done the preliminary research in ticket
DM-9888 on the options for embedded database in Firefly table data support. This ticket is to implement the functions to replace the home-grown capabilities in table data operations. This will enable new functions:
- add calculated columns to the table
- allow more complicated filter on the table
- use the DB functions for sorting, filtering ...
- HyperSQL was selected for its performance, built-in functions, and ease of use.
- Caching is changed to last only the during of a session.
- Some SearchProcessors were converted to the new interface while the rest were adapted via a common wrapper.