from Hacker News

Is "SQL from the front end" viable?

by davidgomes on 11/13/24, 4:36 PM with 1 comments

  • by PaulHoule on 11/13/24, 4:39 PM

    In the 1990s there was a fad to make multiple-access desktop apps where the desktop app would use ODBC or something like it to remotely access a SQL database.

    It went up in flames, the security issues talked about in this article explain why, and soon we had "three tier" applications where you have the client, an application server (could just be a web server although the term was reserved back then for something offering more amenity) and also a SQL database in the back end. Roughly this is the standard now.