3 ms·
I wonder what was the intended way of interacting with the database for technical users?
by jgilias 4y ago
I wonder what was the intended way of interacting with the database for technical users?
- benbjohnson 4y agoI don't have any evidence to back this up but my guess is that the underlying key/value store & cursor APIs were probably the intended way for programmers to interact with the database. SQL came out in the 1970s so every ounce of performance was important.
- ok_dad 4y agoThe VM described in this post? I would imagine other databases have a similar VM?
- tyingq 4y agoThere's a pretty in-depth overview of that here: https://people.eecs.berkeley.edu/~brewer/cs262/SystemR.pdf https://people.eecs.berkeley.edu/~brewer/cs262/SystemR.pdf Where the original Sequel authors took their Sequel spec and implemented it on real hardware + software, with interfaces for both "non-technical" ad-hoc queries as well as integration with PL/1 and COBOL for more technical users. I have "non-technical" in quotes since in that 1970/80's timeframe, you had to be pretty technical to even have that label.
- jgilias 4y agoPerfect, thanks! Exactly what I was hoping for someone would provide!