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
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?

Posted 2 months ago
Votes Newest

Answers 2

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.

Posted 2 months ago

Gotcha! Thanks for the reply!

Posted 2 months ago
2 Answers
2 months ago
2 months ago