Update DB schema and add support for overlapping #8
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
The new schema looks like:
Overlapping support:
Imagine a scenario where user makes query for 2nd line to 100th line - the server should process it and return the result. But next time, if the user queries for 3rd to 103rd line - the server ideally should just process for 101st, 102nd, and 103rd lines and everything else should be fetched from the DB for 2nd to 100th line. This PR addresses exactly that, and it's fixed now.
I'm hesitant to release this right now, as the code is not tested and this is a big change. But... still thinking :)