Skip to content

Urgent - move away from SQLite, and do not store edited forms in the DB #450

@davetcc

Description

@davetcc

Describe the bug
We need to move away from SQLite as the current java implementation is 1. highly inefficient and requires a 10mb import, 2. does not work out of the box for notarization or App Store deployment either. The plan is to move to HQLDB, a very lightweight Java implementation that is a 2mb import, and has no native components.

Further, to this, the plan is to clean up the form creation so that forms are stored within the project, in the forms/ directory (created only when first form is added). These forms are then managed with the project, and can still be used within Java Embed Control easily enough.

To Reproduce
Notarize the app on macOS. It fails with signing issues.

Expected behavior
The app should notarize.

Desktop UI issue (please complete the following information):
macOS only.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions