DBToy 0.8.1

DBToy is a fuse-based filesystem for linux. DBToy that lets you browse the contents of a relational database through a set of directories and xml files.

You will see a directory for every schema in your db, each containing a directory for every table. In the "table" dirs there are a couple of files with the tables definition and data.

You will find instruction on how to compile and use the module and the daemon in the readme file contained in the source distribution.

Playing with dbtoyfs

1) Make sure your rdbms server is running and reachable from your linux box, modprobe fuse kernel module.

2) run "dbtoy -u username -p password mountpoint" (dbtoy with no args shows help)

3) walk through you filesystem.

Each schema has its directory, containing one subdirectory for each table. Inside the dirs there is one file with the description of the datatypes and another with the data.

Ex.:

mountpoint
|
+------schema1
| ....
+------schemaN
|
+-----table1
| .....
+-----tableM
|
+-----data
+-----types

You can "cat mountpoint/schemaN/tableM/types" to see a description of the table, or look at the data. At the moment XML is the only output format.

If you feel lucky can play with the EXPERIMENTAL query file feature: "cat data?col=val" where col is a valid column name and val is a feasible value for col (and string must be quoted!)