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.

Project Activity

See All Activity >

Categories

File Systems

License

GNU General Public License version 3.0 (GPLv3)

Follow sql2textfs

sql2textfs Web Site

Other Useful Business Software
AI-generated apps that pass security review Icon
AI-generated apps that pass security review

Stop waiting on engineering. Build production-ready internal tools with AI—on your company data, in your cloud.

Retool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
Try Retool free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of sql2textfs!

Additional Project Details

Operating Systems

BSD, Linux

Languages

English

Intended Audience

Advanced End Users, Developers, Science/Research, System Administrators

User Interface

Console/Terminal

Programming Language

C++

Database Environment

ODBC

Related Categories

C++ File Systems

Registered

2013-02-11