I have a SQLite database with several tables. The tables have an ID as the PK (auto-increment) and these values are used as foreign keys in other tables.
How can I import the data into the SQLite database of the Grist Electron App whilst maintaining the FK relationships in the data?
Hi @Michael_Magan !
Ugh, I don’t think anyone has built this yet. It’d be pretty easy and elegant, but it isn’t there yet as far as I know. Sorry!
In grist-core there is a yarn run cli sqlite command that can take an SQLite database and overlay some metadata to let Grist (any version including Grist Electron) open it and partially work with it. But it doesn’t do anything special about foreign keys, and isn’t an import, just a kind of overlay.