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 ...

Summary:

• 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.