LiveCode Forums.

It’s nothing special - I just declare fields as primary and foreign key fields and build a relational table in unrelated software for very complex tables for my own reference.

The actual “joins” are now at array level for me.
If adding new, updating, or deleting a record in the array I add a key called “todo” with values “new”, “update” or “delete”. When wanting to push data to the cloud I just filter the relevant array with each [“todo”]=“update” for example. Obviously the array will contain the cdbRecordID key to update the correct record etc. much quicker than syncing the entire table (at least in larger tables).

I don’t think LiveCloud intends to be a relational database in the sql sense and is best viewed as a noSQL database. That means you have much more freedom to do stuff but you have to do more work to implement the normal sql type commands.

I have t really abstracted my methods to a generalisable interface as I’ve only done this in two larger projects I’ve been working on but may well be with doing at some point, once I’ve settled on a method that completely satisfies me…

Thanks so much for elaborating Stam! Highly appreciated!

Do you mind if I ask you an irrelevant, personal question? Stam is from "Stamatis"? Are you of greek origin or even greek? Curiously asking as I am in Athens...

Αυτό ακριβώς

Χαχαχαααααχχχχ! Μεγάλε, μας έφτιαξες τώρα! But you ain't living in Greece, right?

Tonaras wrote: Sat Oct 08, 2022 5:23 pm Χαχαχαααααχχχχ! Μεγάλε, μας έφτιαξες τώρα! But you ain't living in Greece, right?

Nah, not for a loooong time - Lived/worked in Sweden for 8 years and then the UK since, erm, well, more than a couple of decades...