Re:How many of you know that the team is working on somethin...
by ptx on Tuesday June 16, 2020 @06:33AM
(#23537566)
Without any server-side logic, I suppose user permissions must have been handled entirely by the database, with clients connecting as different database users?
Did row-level security already exist in some databases at that time? Otherwise this must have been quite limiting.
Re:How many of you know that the team is working on somethin...
by ako on Tuesday June 16, 2020 @11:13AM
(#23540092)
Row level security was usually handled through database views.
Not a stupid question at all, since terminology has been shifting over the decades.
Back in the early 1990s, the original client/server generally meant all application code (logic and UI) on the client computer, and all the data on the server. So a very fat client.
Database stored procedures (i.e. some logic on the server) only arrived on the scene later during that time, because the original architecture of all code on the client caused performance nightmares. But don’t get me started on the trials and tribulations of early stored procedures. They often caused more project turmoil rather than smoothen things out. — Partly because they weren’t good languages yet, partly because of amplifying developer vs. dba conflicts.