SQLite Implementation

[michaelma7]

Problem

SQLite databases are officially supported but the way SQLite is different enough from other SQL databases that there needs to be a proper integration so that the application will be able to edit SQLite databases. For example Alter Table is not fully supported by SQLite only a subset of commands are allowed. SQLite is different in that it stores the schema in the sqlite_schema table as the original text of the CREATE statements that define the schema. Hence ALTER TABLE needs to revise the text of the CREATE statement. Doing so can be tricky for certain "creative" schema designs.

Solution

My recommendation is to read up on all the SQLite documentation in regards to alter table to then edit how the ERDiagram works specifically for SQLite.
https://sqlite.org/lang_altertable.html

Additional information

No response

👨‍👧‍👦 Contributing

• 🙋‍♂️ Yes, I'd love to make a PR to implement this feature!