Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ADR: expose indexing options to users #616

Open
jisantuc opened this issue Mar 8, 2021 · 0 comments
Open

ADR: expose indexing options to users #616

jisantuc opened this issue Mar 8, 2021 · 0 comments

Comments

@jisantuc
Copy link
Contributor

jisantuc commented Mar 8, 2021

Franklin's database is currently organized around items as a single jsonb field with a special breakout of the collection for faster queries. This makes sense for users who only ever want to look things up by collection id, but for any kind of search, it's insufficient, or at least, the jsonb index has not behaved exactly as we expected in every circumstance (e.g. it wasn't used for collection lookups for a while). At the same time, there's a cost to indexing additional fields. It's impossible to know every use of Franklin up front, but there are two extremes we can think about:

  • users whose needs are 90+% met by fast spatial and time queries using only non-extension fields
  • users who want to search using fields from an extension with nested JSON, e.g., a user who wants fast searches over all the EO fields

Since the number of extensions is asymptotically ~infinity and we don't want to blow up the database with ~infinity indices, we should think about a way to expose configuration here to users who are deploying a Franklin service.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant