4 ms·
>> They call the DB "relational" but I can't seem to find anything in the docs about relations, joins, cascade delete, etc. Looks like they support table relat
by nreece 5y ago
>> They call the DB "relational" but I can't seem to find anything in the docs about relations, joins, cascade delete, etc.
Looks like they support table relationships via PK-FK (mentioned under Data Type section: https://catalyst.zoho.com/help/data-store.html#Column_Characteristics https://catalyst.zoho.com/help/data-store.html#Column_Charac...), but there's no mention of querying or inserting relational data.
- aravinddbz11 5y agoThe details reg querying can be found here. https://www.zoho.com/catalyst/help/zcql.html#Join https://www.zoho.com/catalyst/help/zcql.html#Join Joins based on relationships are supported. And also this tutorial is helpful to get things started https://www.zoho.com/catalyst/help/tutorials/alcity/introduction.html https://www.zoho.com/catalyst/help/tutorials/alcity/introduc...
- pier25 5y agoIt seems queries are constructed from strings? https://www.zoho.com/catalyst/sdk/nodeJS-sdk/zcql_execute.html https://www.zoho.com/catalyst/sdk/nodeJS-sdk/zcql_execute.ht... What about injections, escaping queries, etc?