I am having trouble using the cdb_list with the target "local"
The target "Cloud" works perfectly.

Hi LiveCloud users, I'm asking this question because I'm in the process of migrating my App from using Dropbox as the data server to LiveCloud (with all its expected benefits) but considering all the (in my view) "critical issues" (*) I've seen since the product was introduced I'm wondering if this would be a wise decision.

If you have a (LiveCloud based) reliable & performing application that has been in production for a while (CanelaDB apps doesn't count) would you be willing to share details? How many Tables / Records? where are most of your users and which LCM location are you using? how you deal with the above mentioned "critical issues"? etc, etc

LiveCloud has a fantastic value proposition for Livecode programmers but it seems is not yet delivering to promise. May be I should wait a while before going into production with LiveCloud

Hope I'm wrong (and Mark is listening...)


(*) Slow response, not able to authenticate, broken access after a CanelaDB update, long time to get answers for posts on the forum, etc.

Hi team, after:

•   upgrading to V2.3.4
  
•   exporting the Toolkit 
  
•   copying the initialization snippet to my stack
  
•   closing LC
  

Hi LCM team, I'm not clear as what happens when you release a new "Verson" (shouldn't be "Version" the title of the release notes?) of the CanelaDB libraries. 

It appears to me the APPs already published, accessing the "Previous Verson", stop working and  have to be regenerated to start working again with the new libraries. 

Please prove me wrong.

Thanks

Hi. I'm full of questions and have appreciated several helpful answers so far.

To speed processing I'm trying to reduce the number of queries to the cloud my app needs to make. So I'd like to query, retain the data locally temporarily and make further queries to local. Then at end of session update any records that have changed to the cloud. I've wondered about three approaches I hope could work.

1) I make this query.

cdb_batchQuery(tInputA,"cloud","logicalAND","recordData") into tOutputA

Can tOutputA be queried and updated as if it were a table? If so, what's the syntax?

2) If what I've suggested above isn't possible, what is the syntax to populate the data in tOutputA to a local table?

Is put cdb_batchCreate(tInputA, "local") into tOutputB sufficient or are steps required before that command to create a new table?

3) I am aware of the cdb_loadTable command, but I would greatly prefer not to load the entire table, but instead a subset of the table's contents defined by a query. Is that doable?

I imagine there are good solutions available. What are they? Thanks in advance!

I think I have a problem I'll need to code around. I am porting an app that formerly worked with MySQL tables to LiveCloud.

This means dates are stored in the MySQL format YYYY-MM-DD: e.g., 2019-08-23.

Unless I'm mistaken, LiveCode's date format options don't include this format. So, I'm guessing (will test soon), none of the available CDB query operators will allow me, for example, to select for a date less than or equal to 2019-08-23.

I assume, per the documentation, that "<=" won't work because the data is non-numeric and that "date<=" won't work because the data will be seen as a non-dateitem.

True? Any workaround suggestions? I'd definitely prefer not to have to reformat hundreds of thousands of records that include dates and rewrite dozens of lines of code that assume the MySQL date format as their basis.

Thanks in advance.

Hi team, two questions about cdbBlobs:

1 - I have some "corrupted" records (my fault when uploading) that I would like to delete but when I try to do so by right clicking on the record I get "Couldn't find Blob Table Info" and it isn't deleted. Any workaround?

2 - How can I download all the records of the cdbBlobs table at once? I've tried selecting all the records and then right clicking + Blobs + Download but just one record was downloaded (BTW neither the first nor the last one, just one somewhere in between...) 

Thanks

LiveCloud seems to be down. When will this be fixed?

(2019-08-20 10:49:15.192): The server response could not be downloaded at this time.
(2019-08-20 10:49:45.201): The server response could not be downloaded at this time.
(2019-08-20 10:50:15.205): The server response could not be downloaded at this time.
(2019-08-20 10:50:15.205): Error: There was a problem getting a response from the server for cdb_batchQueryCloud request.

(2019-08-20 10:54:36.952): The server response could not be downloaded at this time.
(2019-08-20 10:55:06.958): The server response could not be downloaded at this time.
(2019-08-20 10:55:36.967): The server response could not be downloaded at this time.
(2019-08-20 10:55:36.967): Error: There was a problem getting a response from the server for cdb_countCloud request.

Is the LCM Broken?
I having problems with my LCM.

I am getting a problem when I get data from LCM.
I keep getting an error and the editor is opening in debug mode with the Stack "CDB_Starter.lib" I was randomly having this happen for the past week and just closing the editor fixed things, but not anymore. It is constantly opening the editor debug mode.
The message box is not showing any errors!
I'll be examining my scripts but I really don't know what to look for.

I will need some help to find what I messed up!

addendum:
I just got a belated message box error list:
(2019-08-20 06:10:20.896): The server response could not be downloaded at this time.
(2019-08-20 06:10:50.946): The server response could not be downloaded at this time.
(2019-08-20 06:11:21.010): The server response could not be downloaded at this time.
(2019-08-20 06:11:21.010): Error: There was a problem getting a response from the server for cdb_listCloud request.

this was after trying to examine my script in the stack.