Re: Implementing SQL on files

[mru@kth.se (Måns Rullgård)]

Anuradha Ratnaweera <anuradha@linux.lk> writes:

> Hi all,
>
> I am starting to write some code to add a feature which I think would be
> very useful, and like to get comments and suggessions from LKML.  Please
> ignore this mail if it sounds like nonsense ;-)
>
> Also, if this is already happenning somewhere, please enlighten me.
>
> Short version: This feature will add a "table" file type and SQL
> executioin premitives to the kernel, and also relevent userspace
> programs.

Things like SQL belong in user space.


[...]

> Using the userspace tools, one can create a "table" file (say
> maintainers), and insert the data to that file.  Each file (or may be
> filesystem) has two characters (or strings) associated with them: field
> seperator and record seperator.  Say, colon and newline.  If I cat the
> file:
>
> % cat maintainers
> David Weinehall:2.0
> Alan Cox:2.2
> Marcelo Tosatti:2.4
> %
>
> Now, if I want to add something to the table, either I can use the
> relevenet userspace tools, but the following also will work.
>
> % echo 'Linus Torvalds:2.6' > maintainers

/etc/passwd

-- 
Måns Rullgård
mru@kth.se