I was thinking to utilize URL segments for pages via external API, however I don't know how those would be indexed by search engines reliably/conveniently? I'm guessing a script could be written to ask for them to be crawled? but I'm not sure whether that's worth it.
Does anyone here do this? for fairly complex articles of data? I think I've seen on here before people mentioning synchronizing real estate databases, for example, to native PW and/or vice-versa... That would be the way to go, then? to enable PW-independence?
Otherwise maybe have a module for managing the external database (like crud) within the PW admin and integrating the API, where for each external record, a page exists (is created/deleted/unpublished accordingly) with its name = id in db. With just the corresponding ID to the record, probably views and SEO at least could be dynamically generated...
Any drawbacks or concerns that come to mind