How to query the filesystem (NTFS) with SQLite?

Question

Hi everybody. How can I query the filesystem (NTFS) with SQLite?

Answer 1

You can't.

WinFS seems to be a solution based on Microsoft SQL Server that runs on top of NTFS. But WinFS is still in development.

Answer 2

Maybe you'll find interesting this article: Query Anything with SQLite

[...] SQLite has a number of unique features, one of the most interesting of which is virtual tables. With virtual tables, you query not only what is in a database, but what is outside of it as well. For instance, with a little coding, you could use SQLite to search through your filesystem and issue queries such as [...]