3 ms·

You Can Now Code Websites with SQL

27 points by EntICOnc 3y ago

mdaniel 3y ago
pfft, welcome to the 90s :-D https://docs.oracle.com/cd/A97630_01/appdev.920/a96590/adgweb.htm#1003882 https://docs.oracle.com/cd/A97630_01/appdev.920/a96590/adgwe... with an especial nod to > This kind of dynamic content is different from dynamic HTML (DHTML) I only know about this nonsense by evaluating it as an alternative to .idc/.htx files https://learn.microsoft.com/en-us/previous-versions/iis/6.0-sdk/ms525756(v=vs.90) https://learn.microsoft.com/en-us/previous-versions/iis/6.0-... waay back when
- bashmelek 3y ago
  I also remember Internet Explorer allowed for web pages to talk directly to sql server via an ActiveX control. Tried it out once locally. Was both interesting and terrifying.
  - mdaniel 3y ago
    Well, yeah, I'm sure one can talk directly to Oracle with an <object> tag, too (probably painlessly from wasm in modern browsers) since running random code is random
- zamalek 3y ago
  You could also expose MSSQL from IIS (what a great idea! /s). In one edition of MSDN Magazine an author combined this with XSLT to make a website.
- znpy 3y ago
  everything old is new again.
blarnopre 3y ago
If you turn your head sideways and squint a little it looks a little like functional react using SQL syntax to replace JSX
llimos 3y ago
Reminds me of this classic April Fool: https://www.youtube.com/watch?v=0_PK1eDQyVg https://www.youtube.com/watch?v=0_PK1eDQyVg
bdavbdav 3y ago
Erm: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_web.htm#ADFNS1102 https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns...
- mdaniel 3y ago
  I only knew about the HTP stored-proc package but your link introduced me to a new horror: PL/SQL Server Pages (PSP) <https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_psp.htm#ADFNS016 https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns...> but I wasn't able to readily spot when they were introduced (that link is for 11gR2) ... mildly off topic, but I also had flashbacks reading your link due to the seeing that XDB HTTP port output, as I had a file stashed away in Dropbox for disabling the XDB HTTP listener due to it eating :8080 on my machine during reinstalls. Good times that I hope to never, ever revisit :-/
Nextgrid 3y ago
Related: "Web development platform built entirely in PostgreSQL" - https://github.com/aquametalabs/aquameta https://github.com/aquametalabs/aquameta

27 points by EntICOnc 3y ago

pfft, welcome to the 90s :-D https://docs.oracle.com/cd/A97630_01/appdev.920/a96590/adgweb.htm#1003882 https://docs.oracle.com/cd/A97630_01/appdev.920/a96590/adgwe... with an especial nod to > This kind of dynamic content is different from dynamic HTML (DHTML) I only know about this nonsense by evaluating it as an alternative to .idc/.htx files https://learn.microsoft.com/en-us/previous-versions/iis/6.0-sdk/ms525756(v=vs.90) https://learn.microsoft.com/en-us/previous-versions/iis/6.0-... waay back when

bashmelek 3y ago
I also remember Internet Explorer allowed for web pages to talk directly to sql server via an ActiveX control. Tried it out once locally. Was both interesting and terrifying.
- mdaniel 3y ago
  Well, yeah, I'm sure one can talk directly to Oracle with an <object> tag, too (probably painlessly from wasm in modern browsers) since running random code is random
zamalek 3y ago
You could also expose MSSQL from IIS (what a great idea! /s). In one edition of MSDN Magazine an author combined this with XSLT to make a website.
znpy 3y ago
everything old is new again.

blarnopre 3y ago

If you turn your head sideways and squint a little it looks a little like functional react using SQL syntax to replace JSX

llimos 3y ago

Reminds me of this classic April Fool: https://www.youtube.com/watch?v=0_PK1eDQyVg https://www.youtube.com/watch?v=0_PK1eDQyVg

bdavbdav 3y ago

Erm: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_web.htm#ADFNS1102 https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns...

mdaniel 3y ago
I only knew about the HTP stored-proc package but your link introduced me to a new horror: PL/SQL Server Pages (PSP) <https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_psp.htm#ADFNS016 https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns...> but I wasn't able to readily spot when they were introduced (that link is for 11gR2) ... mildly off topic, but I also had flashbacks reading your link due to the seeing that XDB HTTP port output, as I had a file stashed away in Dropbox for disabling the XDB HTTP listener due to it eating :8080 on my machine during reinstalls. Good times that I hope to never, ever revisit :-/

Nextgrid 3y ago

Related: "Web development platform built entirely in PostgreSQL" - https://github.com/aquametalabs/aquameta https://github.com/aquametalabs/aquameta