Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, e.g. \+
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Scoold database - are you recommending H2 database in production

Which database are you recommending in production ? Is it OK do use H2 ?

We are using the default configuration for database - nothing is specified in para/ application.conf file and using local instance. And we get to the point where we have to think for backup solution. So based on the para documentation if you set para.env = "production" and does not configure anything about database , the default it will be H2 and all will goes in ./data folder. So Im trying to access the data in the H2 database , but without much success. Does anyone can help ?

Posted one year ago
Votes Newest


Sure, it's a simple, stable and performant database and it's ideal for small-to-medium Scoold deployments. I can't recommend any particular DB because they all have their tradeoffs. Simply use the database engine you are most familiar with. It is also quite easy to implement a DAO plugin for any database you choose, unless it it's already implemented.

For details on how to access the H2 DB in ./data and how to back up/restore it, read the Para H2 documentation.

Posted one year ago