9 ms·

I mostly use database instead of DBMS because nobody calls it a DBMS, at best a database or SQL server. And I actually wondered for a short moment whether there

I mostly use database instead of DBMS because nobody calls it a DBMS, at best a database or SQL server. And I actually wondered for a short moment whether there is any DBMS with a web server. But I would probably still argue that you are connecting to a web server that just happens to be integrated into the DMBS. But admittedly at some point this turns into a matter of point of view and personal preference how to slice the system and label the components.

mindcrime 5y ago
And I actually wondered for a short moment whether there is any DBMS with a web server. I don't know if it's still the case or not, but Oracle had the option to run a web-server as part of the database at one time. Back in the Oracle 8 or Oracle 9 era, as best as I can remember. EDIT: OK, here we go. https://docs.oracle.com/en/database/oracle/oracle-database/18/adfns/web-applications.html#GUID-86F73FF3-70CC-4BB5-AA55-F69720149430 https://docs.oracle.com/en/database/oracle/oracle-database/1... You can use an embedded version of the PL/SQL gateway that runs in the XML DB HTTP Listener in the database. It provides the core features of mod_plsql in the database but does not require the Oracle HTTP Server. You configure the embedded PL/SQL gateway with the DBMS_EPG package in the PL/SQL Web Toolkit. Some advantages of using the embedded gateway instead of mod_plsql are: You can invoke PL/SQL web applications like Application Express without installing Oracle HTTP Server, thereby simplifying installation, configuration, and administration of PL/SQL based web applications.
sophacles 5y ago
You never connect to a DBMS. Everything you're doing to interact with it, or a web server is mediated by your OS. You just open sockets and the connection is handled by TCP or IPC or whatever.
- NavinF 5y ago
  (╯°□°)╯︵ ┻━┻
- danbruc 5y ago
  You never really open a socket, you really only push and pull some electrons around and then...
giraffe_lady 5y ago
Did you see that post from last week https://blog.polyglot.network/backend.sql-+-frontend.js-love https://blog.polyglot.network/backend.sql-+-frontend.js-love? You can set arbitrary headers with postgrest so you can use it to serve pages. I don't know if this is exactly what you mean but it's as close to "dbms with its own web server" as I've seen. It's also just cool lol. Though as much as I like plpgsql and it would be hilarious to use it as a templating engine I don't really have a use for this.
cdcarter 5y ago
CouchDB famously has an HTTP protocol.

mindcrime 5y ago

And I actually wondered for a short moment whether there is any DBMS with a web server. I don't know if it's still the case or not, but Oracle had the option to run a web-server as part of the database at one time. Back in the Oracle 8 or Oracle 9 era, as best as I can remember. EDIT: OK, here we go. https://docs.oracle.com/en/database/oracle/oracle-database/18/adfns/web-applications.html#GUID-86F73FF3-70CC-4BB5-AA55-F69720149430 https://docs.oracle.com/en/database/oracle/oracle-database/1... You can use an embedded version of the PL/SQL gateway that runs in the XML DB HTTP Listener in the database. It provides the core features of mod_plsql in the database but does not require the Oracle HTTP Server. You configure the embedded PL/SQL gateway with the DBMS_EPG package in the PL/SQL Web Toolkit. Some advantages of using the embedded gateway instead of mod_plsql are: You can invoke PL/SQL web applications like Application Express without installing Oracle HTTP Server, thereby simplifying installation, configuration, and administration of PL/SQL based web applications.

sophacles 5y ago

You never connect to a DBMS. Everything you're doing to interact with it, or a web server is mediated by your OS. You just open sockets and the connection is handled by TCP or IPC or whatever.

NavinF 5y ago
(╯°□°)╯︵ ┻━┻
danbruc 5y ago
You never really open a socket, you really only push and pull some electrons around and then...

giraffe_lady 5y ago

Did you see that post from last week https://blog.polyglot.network/backend.sql-+-frontend.js-love https://blog.polyglot.network/backend.sql-+-frontend.js-love? You can set arbitrary headers with postgrest so you can use it to serve pages. I don't know if this is exactly what you mean but it's as close to "dbms with its own web server" as I've seen. It's also just cool lol. Though as much as I like plpgsql and it would be hilarious to use it as a templating engine I don't really have a use for this.

cdcarter 5y ago

CouchDB famously has an HTTP protocol.