Thank you for your great product.
So here i’m creating something like Zoho Creator.
It’s a SaaS Multi-Tenant service which every tenant has their own modules and each module has it’s custom fields. Users are completely Isolated.
I decided to use a structure like this in Database :
|r02||10200, 10201, 10203|
which fields begins with
<s> is string,
<n>s are numbers and
<r> are relations.
So i have 2 questions.
As you can see in my example, users can create a Module which can have has its own relations to another Module. Like “News Module” and “News Category Module”.
So we will have
newsbelonging to a
- There will be a relational filter and sorting. like: “Find me all news records posted from yesterday until now which have ( ( star_rating > 2 AND star_rating < 5 ) OR advertising_news = 1 ) AND category.parent_id IN 20 ORDER BY category.id”
- Is this a correct way to do this or should i change something?
- I’d Prefer not to save all relation data as a sub-document in
newsrow, because every relation could have change very fast and i think it could be so hard to update all
newsrecords because of changing in title of a
Is Sphinx/Manticore a good choice for this kind of project?
There will be lots of users and lots of rows in the future. does performance decrease overtime?
Thank you for your time.