> On Jul 22, 2022, at 3:56 PM, Ali Baharev <[email protected]> wrote: > > FKs have been supported since at least 2009. It does have a well > documented quirk though: You must enable foreign key support > explicitly. > > 2. Enabling Foreign Key Support > https://www.sqlite.org/foreignkeys.html#fk_enable > <https://www.sqlite.org/foreignkeys.html#fk_enable> > > But apart from that, it works like a charm.
IIRC the issue on Cayenne side was with SQLite JDBC driver not bringing over the FK metadata during DB import. Again, this was years ago. A.
