MySQL / MariaDB SQL
A SQL snippet for MySQL / MariaDB that answers requests for /pixel.gif with the empty GIF, decoded once at startup.
MySQL / MariaDB SQL
CREATE TABLE IF NOT EXISTS assets (
name VARCHAR(255) PRIMARY KEY,
content_type VARCHAR(100) NOT NULL,
body BLOB NOT NULL
);
REPLACE INTO assets (name, content_type, body)
VALUES ('pixel.gif', 'image/gif', FROM_BASE64('R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw=='));
Checked against the framework's current documentation.
Official site: MySQL / MariaDB