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")
Escape special characters +-&|!(){}[]^"~*?:\ - 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
Unanswered
Any database preference for Scoold?


You are right - the schema for SQL databases is pretty simple. I wouldn't say document DBs are preferred over RDMBSs, it's just that Para is a schemaless backend server so the data fits better inside a document DB. In other words Para expects data in any kind of structure.

4
4
Posted 3 years ago
Alex Bogdanovski
1K × 9 Administrator
  
  

One potentially important consideration is that with MySQL, there is a limit of 64k for any given column. This in turn limits the total size of the post and associated metadata. We're moving to Mongo (AWS DocDB, actually) to address this, as Mongo supports document size up to 16MB.

Chris Chandler   2 years ago Report
646 Views
0 Answers
3 years ago
3 years ago