The program `sql2textfs` is a custom file system based on FUSE that lets the user mount a database and view all its tables as files of a directory of the filesystem in a POSIX system. The databased tables are viewed as files but in a specific format: All table entries are converted into lines in a file of text. Columns are separated by tab, so all the data of the table is in a tab-delimited text file. The file format is a form of CSV format. The table header is in the first line of the file. It is a tab-delimited line containing the name and some type-properties of each column. The file system sql2textfs relies on the `retranse` - a language based on regular expressions - project which was developed at the same time. The configuration file of sql2textfs, which is written in retranse, is essential since much of the convertion functionality lies there and each database type requires a special configuration file.
Be the first to post a review of sql2textfs!