I have just been trying to work on a new sqlite database in DataGrip and have encountered several errors.
For tables with a foreign keys the foreign key appears in the database browser window with a name that begins with '#FAKE_...'.
Also the database browser and dialogs indicate an index is unique regardless of whether or not it is unique.
Finally modifying a table, index, or foreign key through the built-in dialog often results in SQL that does not maintain the original table structure exactly. Often it will not execute without errors.
I'm not entirely sure if I'm missing something somewhere or if these are bugs?
My sqlite version is 3.8.9