You'll need each sqlite db to be relatively small for this approach to work well. Probably well under 1gb. If you construct a clever way for many small sqlites to form a bigger whole, that could work really well! Is that along the lines of what you are thinking?

As an example, you could imagine each Notion document being a separate sqlite...