the database https://github.com/miyako/4d-tips-sdi depends on a VBA/REST library https://github.com/VBA-tools/VBA-Web> which is a rest client. I have edited the library a little bit for better unicode support. https://github.com/miyako/4d-tips-vba-functions. incidentally, the sample data is derived from a classic microsoft demo https://github.com/miyako/4d-tips-northwind-traders.
at the time of the summit, the demo worked on mac with Excel 15.16 for Mac, but not the newer Excel 16.x.
maybe because 15 is 32-bit and 16 is 64-bit (by default).
since the demo was for windows, I didn’t invest into fixing the library for mac.
of course, VBA+REST may not be the best way to connect on the desktop.
add-on is more cross-platform,
SQL requires no server license for 4D Unlimited Desktop (the SQL server is enabled for local desktop connection) unlike REST.