Has anybody used a SQL database to store static pages without using PHP?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

I had a conversation with a friend last week where I was asked:

Can you store an entire static page in an SQL database such as MariaDB
or MySQL and have httpd initiate the database query by parsing the
search parameter from the URL?  i.e.
https://www.example.org/benny/index.html would search a table for
"/benny/index.html" and return back a corresponding VARCHAR, or maybe
BLOB, that contains the entire HTML document.

My initial answer was, "Of course!  You're not the first person to
have this idea.  It seems like a project that somebody would have done
and is out there somewhere.  Could be interesting if you're hosting a
massive amount of tiny files where you might run out of inodes.  I had
years earlier read an article about somebody using SQL databases as a
filesystem, so that could be an approach.  After an evening of
searching, I had to backstep and admit to my friend that without the
use of PHP as an interface, it really could be that nobody has done
this before.

Searching for this idea on a modern search engine was maddening.  My
results were polluted by every LAMP, Apache, MySQL/MariaDB server
howto, blog, forum and tutorial ever written in the past decade.  But
as a last step before I shut this thought down, has anybody
(particularly the developers) seen an interface between httpd and SQL
server without using PHP as a glue between the tools?  Has anything
like this ever existed?

Hope I didn't distract anybody too much with this craziness.

Thanks

Timothy D Legg

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx




[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux