3 ms·
Aha! I worked with Notes a few decades ago, interfacing it into PeopleSoft. I got it to work but I never really got a grip on the slippery concept of what exact
by codeulike 10y ago
Aha! I worked with Notes a few decades ago, interfacing it into PeopleSoft. I got it to work but I never really got a grip on the slippery concept of what exactly Lotus Notes was, and why it was so terrible at one-to-many data structures. But thanks to your comment I now get it! It was a document oriented nosql db, years before we had a name for that.
- slantyyz 10y agoIf I'm not mistaken, I believe IBM at some point ended up moving the Domino back end to something relational like DB2 long after I stopped using Notes. I was a MacOS (8 or 9) user when I got that job working with Notes. The thing that I found that helped me learn Notes very quickly was my background using Filemaker Pro. This was before Filemaker Pro had "gone relational".
- sk5t 10y agoYes, a DB2 storage option for Notes existed, but it didn't do anything to solve the basic mismatch between Notes and a) performance of Notes views in databases with hundreds of thousands or more documents, b) one to many relationships / transactions / RI, or c) support SQL or other non-script approach for query or update.