Not really a Xojo add-on, but I think some people here use it. I am making models in Navicat Data Modeler but have no idea how to turn the model into an SQLite database Xojo can simply read. I'm also using Navicat for SQLite but nothing seems available.
I exported the .sql file which contains table code like this:
CREATE TABLE "main"."testing_scale" ( "id_scale" Integer NOT NULL, "id_rank" Integer, "id_performance_testing_station" Integer NOT NULL, "scores" Text NOT NULL, "results" Text NOT NULL, PRIMARY KEY ("id_scale") , CONSTRAINT "lnk_scale_rank" FOREIGN KEY ("id_rank") REFERENCES "list_rank" ("id_rank"), CONSTRAINT "lnk_scale_station" FOREIGN KEY ("id_performance_testing_station") REFERENCES "performance_testing_station" ("id_performance_station") );
I mean, I could write a Xojo app with "createdatabase" method and copy this in, but there must be a better way. Does Navicat allow doing this? Perhaps Valentina Studio? I've so far only free versions of all these database apps.