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
Answered
Any database preference for Scoold?

I've taken a look at the Scoold schema in MariaDB and it's pretty flat. Really just a single table with text fields for storing the content as JSON.

Given this, are document DBs (e.g.: Mongo) preferred over relational DBs for Scoold?

1
1
Posted 3 years ago
Votes Newest

Answers 2


Gotcha! Thanks for the reply!

1
1
Posted 3 years ago

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
5K Views
2 Answers
3 years ago
3 years ago
Tags