Overview

This is a project for the MySQL Filesystem storage engine. 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. You can see details of installing it and using it here:

http://mysql-filesystem-engine.googlecode.com/svn/trunk/README

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.

Downloading

Click the 'Downloads' tab at the top for the latest alpha release.

Questions, Problems

Feel free to email me (cturner@pattern.net) if you have any questions or problems. Or, better yet, if you have ideas for improvements or even patches!