Custom adapter or modification to sqlite adapter?

[bbarker]

Hi,

I've been a user of ripgrep for a while but just discovered ripgrep-all while looking for the solution to a specific issue, but it's great to have such a general tool.

The problem is to search through an entire Unison codebase, which are stored in sqlite files. A quick test with rga indicates I can find stuff I'm looking for, but not much helpful context (e.g. the namespace that the code is coming from):

$ rga "Page"
unison.sqlite3
text: id=20236, text='PageDown'
text: id=20237, text='PageUp'
flipToPage: Nat -> Book -> Optional Text
flipToPage desiredPage book =
    Book pages -> List.at desiredPage
text: id=23501, text='desiredPage'
text: id=28259, text='Page not found'
text: id=28680, text='Page'
text: id=28682, text='allPostsPage'
text: id=28683, text='atomFeedPage'
text: id=28685, text='badrequestPage'
text: id=28688, text='notFoundPage'
text: id=28690, text='postPage'
text: id=28691, text='postPage_'
text: id=28692, text='rssFeedPage'
text: id=28776, text='renderFrontPage'

$ rga "Error in cloud computation"
unison.sqlite3
text: id=22116, text='Error in cloud computation: '

As a Unison user, ideally I'd be able to just use the existing functionality to search through a unison sqlite file or any other sqlite file, and allow the existing adapter to recognize if a sqlite file is unison by inspecting database metadata. That said, it is hard to imagine a time at which a significant portion of ripgrep-all users are also Unison users (fwiw, I love Rust and Unison!). So maybe having a config option to disable the Unison check by default would be an option, though checking metadata should be relatively quick I imagine.

The other option is to just have a separate adapter, which is certainly ok in principle, I think, but I wonder if it might conflict with the existing adapter when looking at file extensions and creating metadata; since there is overlap, it seems like we may need the same metadata generation code to determine which adapter to use: sqlite or unison-specific sqlite.