T-SQL is turing complete. While the MS SQL server has limitations on OS level operations, if you allow yourself some leeway with CLR wrappers for the win32 API, there’s no reason I can think of you wouldn’t be able to get the database engine to be a webserver reacting to incoming requests on port 80, or drawing GUIs based off of table state.
At an old company I worked at they rendered HTML in plsql with iframes everywhere, it was a real throwback to how they used to build stuff. I feel bad for the guy who had to maintain that hot mess.
T-SQL is turing complete. While the MS SQL server has limitations on OS level operations, if you allow yourself some leeway with CLR wrappers for the win32 API, there’s no reason I can think of you wouldn’t be able to get the database engine to be a webserver reacting to incoming requests on port 80, or drawing GUIs based off of table state.
It’s be slow and terrible, but doable.
It’s doable. Personal experience
At an old company I worked at they rendered HTML in plsql with iframes everywhere, it was a real throwback to how they used to build stuff. I feel bad for the guy who had to maintain that hot mess.