Hello Canela team,

I would like to know which of the columns in the user table are immutable and will never ever change under any circumstance.

Thanks,

Tom

Canela wishes all of you a very restful and enjoyable holiday. We will be off from December 24th through January 7th. 

I'll be around in the forums should anyone have an emergency. Otherwise, we look forward to a very exciting 2022 with all of you. Thanks for all of your support this year. 

- Canela Team

Hi all,
not sure if this is something to do with internal housekeeping with LiveCloud...

I've added a small custom library to the /CanelaDB/libraries/ folder to manage the initialising code no matter the location of this directory, which works well for my purposes. 

Only, on occasion the stack file simply disappears!? (ie the above directory will suddenly only contain the 2 canelaDB libraries). 
Not offloaded to cloud - just gone.
There is absolutely nothing in my stack that would delete any file and I've not encountered this behaviour on Mac at any point in the last 30+ years...
In fact i now keep a copy of this little lib in the parent directory (all of these are in a writeable location) to keep copying it back to /CanelaDB/libraries/. This extra file never disappears, so it's unlikely to be a Mac thing.

So i have to ask - is this some internal housekeeping thing by liveCloud? Should i not be keeping other files in this directory?

Many thanks
Stam

-- edit: i should note this happens in the IDE only, i've not tested with standalones; IDE is 9.6.5 (stable) and OS is MacOS Monterey 12.0.1. LiveCloud libraries are the most up-to-date at this point in time.

On occasion, my stack will be unable to locate the libraries after a save and/or test on an android device. When I close the stack and reopen it, I will receive "Error, CDB_Header checksum did not match" from the "csi_verifyLibraries" command.  It doesn't happen very often. Maybe once a month.

I am quite certain I have resolved this issue before either by (1) exporting the toolkit and moving the existing stack into that new folder, or (2) creating a new project and replacing the existing stack over the new "login" stack. However, either I am forgetting something or something may have changed. So I thought I would ask a couple of questions for myself and anyone else geting this error because this often turns into a rather large time eating problem.

1) How can I fix this? Neither of the usual methods worked (i.e., export toolkit and/or create project). 

2) What causes this and how can I avoid this from happening in the future?    

Thanks so much in advance!

Hi All,

since upgrading to MacOS 12.0.1 Monterey, i've been unable to run LiveCloudManager - it hangs on every single startup.
I've already reached out to Mark and the Canela team, but apparently no one has reported issues.

Is anyone running LCM on Monterey? (i.e. is it just me!?)

Many thanks
Stam

Hi, I have an error when I try to save a standalone.

"We encountered an error while initializing CanelaDB:

91,44,1
568,44,1


I have included what I think is needed for the build...
Did I miss something?

Can you help with this?

I thank you already,

Phil

Once in a while, we will provide support via email. I want to share that experience with everyone with the hope that others will benefit. When this happens, We'll leave out the person's name.

On to the question:
I've never really done nosql, was always able to query specific records against a user_id.
I want a quick way to save and query all of a user's records in this nosql way.

Do you see any limits or problems with creating a table for each user? and place all their data there?

I know for low numbers of user's thats not a big deal.
How about 10,000 tables?


The response:
There is always more than one way to model your data.

Method 1
You could use your cdbRecordID (primary key) for each user in the cdbUsers table as a linking key (foreign key) to records in another table.

cdbUsers table
Record 1: [a2ad3bc9-8ef8-4c36-9c4d-00d109600cd9] [Marco] [Polo]


someDataTable that contains data for all of your users
Record 34545 [0a43839f-ad5c-4089-a864-c6bfa10942be] [a2ad3bc9-8ef8-4c36-9c4d-00d109600cd9] [import] [data] [in] [these] [columns]


TableID:fbb12a0d-8189-4fb4-a906-12166445f54b
0a43839f-ad5c-4089-a864-c6bfa10942be


//Untested come code that should work:
//GET THE RECORD ID OF A PARTICULAR USER
local tOutputA, tRecordID
put cdb_query("email","=","marco@polo.com","cdbUsers","cloud","recordData") into tOutputA
put tOutputA["cdb"]["cdbRecordID"] into tRecordID


//USE THE cdbRecordID FROM THE FIRST QUERY TO FIND ALL RELATED DATA TO THIS USER
local tOutputA
put cdb_query("userForeignKey","=",tRecordID,"someDataTable","cloud","recordData") into tOutputA

//tOutputA will contain an array that for every record in the 'someDataTable' table that is related to your user. 
//For this to work, every commit to this table needs you to include the foreign key value in each record for every user.
//Since the user is probably authenticated, you can get this value one time during their session and use it everywhere you need.


Method 2
You can store the tableID in the cdbUsers table as a foreign key.
The optimization is that you can read on a single table and know that all the data is related to that particular user. You will not need to query a table to find related data. 

I am in favor of this model. The only negative is that a user can not create a table programmatically. It is something we intend to resolve. You could pre-create tables with a developer-signed app programmatically. If you get serious with this method, we can look at a longer-term solution to make this happen. 

You can connect as many tables as you like to a particular user. Just create the foreign key columns in the cdbUsers table to track the tableIDs.


Limitations
The free account “Mist” and entry level account “Rain" are running on a shared cloud cluster. They are great for developing concepts and low-data consumption apps. They will not work out for you if you plan to have 10k or more users. 

You will want to build a “Storm” account to customize the cluster just for your app. If you have 10k paying customers, our Storm plans are cheap. 

hello I'm Samuele, i tried to use livecloud but it doesn't work i have put the created folder (by livcloud, with in it database...) in the same folder as the livecode stack file and run livecode but the stacks that are supposed to be there (the libraries ecc.) are not thereany help would be great. thanks!

Hi,

In my use-case I may need to let people register from a website.
Is there any API I can use for that?

Hey everyone! LiveCode is holding another in-person conference early next year. Canela will be there to demonstrate Appli.

Appli is a new front-end IDE to LiveCloud that aids you in making desktop and mobile apps. You can ship your apps without a developer kit from Apple or Google. We provide a player that your clients can download from both app stores. Of course, if you need a standalone, you will be able to do that too.

Appli provides a modern IDE for making apps. You do not have to worry about the complexity typically found in mobile app design. Appli solves the various screen sizes and dpi differences for you. Appli ties in with LiveCloud providing a native database. This design allows you to bind your data to your app elements with ease.

Appli will come with a no-code, low-code, and high-code feature set. These features will allow you to build projects faster than ever. Should you need more power, you can use the powerful LiveCode language to fill in the gaps as needed.

Appli is still under development. We have a single-page site to get you thinking about the great things that are coming. Check it out at: appli.io. We expect to have an open beta in November.

The goal is to provide a session and a workshop at the LiveCode conference in April. We hope to see all of you there!