I have an sqlite database representing a collection of Foo which is immutable. I would like to be able to take this collection of Foo in the GUI of Drupal, and append a few fields onto each Foo instance, these new fields are to be editable.
I see no point to inserting the data as nodes / entities directly as the data is only going to reflect what's already in the database and inserting data using node_save is incredibly slow for duplicating the data.
How would I accomplish this so that a content-type / entity type uses data from another database, but manages a few additional editable fields?
Would it be a custom content type with a module to manage the pulling of the data from another database, or would it be a custom entity?