Uniface customer app grows to 95 SQLite tables without a migration framework
Over five development stages, a Uniface 10 customer app's SQLite database expanded from roughly 35 to 95 tables, with no migration tool used. Instead of adding Flyway or a similar framework, the developer relies on a simple manual procedure and two built-in checks in the app. Stages only added tables, indexes and settings, and new information about existing records goes into new one-to-one tables rather than altering existing ones. This approach keeps existing forms and services unchanged and makes each stage atomic, though it requires joins when reading full customer details. The new tables are accessed through services using SQL statements rather than being modeled as Uniface entities, and each migration is recorded with a schema version number in a settings table.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in