Webmasters Stack Exchange is a question and answer site for pro webmasters. It only takes a minute to sign up.
Sign up to join this community
I'm creating a wiki (using MediaWiki) which pulls data from a mySQL instance, and uses this alongside a template to generate the page dynamically.
My mySQL instance contains images, stored in a field of type BLOB.
Is it possible for MediaWiki to interpret this BLOB data into the actual image desired to be shown on the page?
One way to do it is to write a FileBackend subclass for using the DB as a backend. There is not much documentation on how to do it, though. (This would assume that you still store the names of files in the wiki DB, and only use your custom DB to store file contents. If you want to delegate all file handling responsibility to the custom DB, you'll also need your own file repo class as well. Also not well documented; see $wgForeignFileRepos as a starting point.)
A less elegant but easier approach is to write a tag extension which takes an image name/id and outputs the HTML for the image, maybe as a data: URI (or using a special page as the src and doing the DB lookup there). You'll have to reimplement all the image handling (HTTP headers, HTML formatting etc) that MediaWiki would otherwise do for you, though.
Content-Typeheaders. I doubt that MediaWiki has this type of functionality built in, however. The documentation I've looked at indicates MediaWiki usually keeps images in the file system. – Stephen Ostermiller♦ Jun 20 '17 at 13:11