MySQL Filesystem Engine 0.1.1

MySQL Filesystem Engine is a database storage engine for arbitrary filesystem files.

It translates normal files on your server into relational tables inside of MySQL. It is a very alpha project at the moment, but works for basic usage.

Example

mysql> CREATE TABLE LoadAverage (
load1 DECIMAL(3, 2),
load5 DECIMAL(3, 2),
load15 DECIMAL(3, 2),
active_processes VARCHAR(12),
lastpid INTEGER) ENGINE=FILESYSTEM connection='file:///proc/loadavg';
Query OK, 0 rows affected (0.00 sec)

mysql> select * from LoadAverage;
+-------+-------+--------+------------------+---------+
| load1 | load5 | load15 | active_processes | lastpid |
+-------+-------+--------+------------------+---------+
| 0.00 | 0.00 | 0.00 | 1/97 | 6061 |
+-------+-------+--------+------------------+---------+
1 row in set (0.00 sec)

Security

Anyone who can create tables on your MySQL server will be able to read any file that mysqld can read! Hopefully this will be fixed in the future, but remember, even temporary tables could be used, so proceed with caution.

Product's homepage