I’m currently updating an application which only supports MariaDB as a database in order to also support other database types, such as SQLite. This involves going through each MariaDB method and translating the queries to work with SQLite. I’m not really able to change the structure of the tables within the database too much, since the rest of the code-base is already largely dependent on the specific layout in place.