What local databases does uxp support? Is it convenient to transplant SQLite and MySQL databases from CEP to uxp? Thanks.
UXP does not yet support any form of local database such as web SQL or IndexedDB. IndexedDB is used internally, but right now those APIs are not exposed to developers.
If you need to connect to a database, you’ll need to have a helper app that you can launch locally and communicate with via sockets, or connect to a REST endpoint externally.
1 Like
[ Since a few years have past, this may have change ]
[ In my case this is for Premiere, not Photoshop, but may be a common object if provided by UXP ]
To connect to a localDB (and potentially remote in the future) from the plugin (only using Javascript at this point, not a hybrid plugin), I suppose I could create a local proxy to interact with mySQL or, easier, use a DB that expose a REST endpoint ( so from JS using fetch + proper setting on manifest).
Oh, and apparently I also need to use a valid cert (self-sign do not seem to work).
Any other ways that are exposed ?
( BTW, if anyone tried something like “DB2Rest” with UXP, I would be interested in hearing your experience )
PS : BTW @kerrishotts, no socket access from UXP correct ? (furthermore may be limited on premiere). I assume the suggestion was for C++ plugin.