MySQL Filesystem Engine 0.1.1

MySQL Filesystem Engine is a database storage engine for arbitrary filesystem files.
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.

last updated on:
June 5th, 2008, 10:30 GMT
price:
FREE!
developed by:
Chip Turner
homepage:
code.google.com
license type:
GPL (GNU General Public License) 
category:
ROOT \ Database \ Database Engines

FREE!

In a hurry? Add it to your Download Basket!

user rating 13

2.2/5
 

0/5

Add your review!

SUBMIT