We just released an update to LCM (version 2.5.3) that contains a new API called: cdb_importCSV()
Enjoy!

Hi guys

I have been puzzling over an issue. Currently normal users authenticated trough the app you create cannot 'create' tables or keys programatically from within the app. unless you hardwire your developer credentials.

so what happens in this case is that you end up with one table that contains all the users data and you create queries based on the user as one of the rules. user = sid@acczap.com  etc

It would be great to be able to clone a table , for example , let say you have a table called 'contacts' and within this table you have a key called 'common' which is a boolean key (true/false). this is your main table. 

So sid@acczap.com signs up and then the system automatically creates a table called sid@acczap.com[contacts] and also duplicates the common records with a 'true' value in the key {common}

this will be awesome, as you can program the thing to put the user in a variable && "[contacts]" and use that as the table name to tell livecloud which table to use.

this feature will be even better if you could do this on a PROJECT basis, that means the system will clone a project (on signup) where the main one is acczap.com ( with tables and fields in them- some common records you want to clone will also be marked true in the common key. In this case , you will have to add a unique field to the login screen , such as telephone number which will be the identifier on a cloned project , example: acczap.com[27343124003] ..this is because the 'cloned' project will have its own bunch of users..the main user can create a form to add users to the cloned project.

This way you can bill clients based on their own 'project' based on the metrics within livecloud manager.

and more importantly, you do not mix up your clients data in one gargantuan table ...

and even more importantly, you don't hardwire livecloud developer credentials into your app ...

Can this be done?

Sid

Hi Everyone:

First of all

the CSV import in livecloud is an awesome feature. , Can you show us if its accessible via command or code to do from the client side app? For instance , take the contacts app example.. A client would want to import his own data into his clients app.

It would also be cool to show how it can be done from a datagrid.

A note for people using MSExcel 2010 to generate .csv files : It errors  , but if you upload the file to google sheets and then download it as a csv..it works wonderfully.

I'm not sure if its a purely 2010 excel version issue. Maybe later editions work. 

Sid

Hi everyone,

We've received a few questions regarding query. This video shows how you can use the query builder and code snippet to build a query and generate the code needed to perform the query: https://youtu.be/6g2pFEvdLcc

You can then take the code from the code snippet and use the output of the query to generate a list of names as follows:

Hi Guys

I have a question regarding cloud updates to records with NUMBERS  or Currency figures (well-all are numbers)in them:

for example , l'm doing stock control and I need to update 2 records , onHand and grossProfit (these are keys on the cloud database

so , as I understand it, you have to get the original key value for the above and store them into local variables and then do the calculation, for example, initially theres a 100 in onHand and $1000 in Gross profit. You sold 10 and made a buck on each thingummy you sold. so the calc is simple  and your updated values are 90 in onHand and $1010 in grossProfit.

Imagine that there are 2 users hitting the same record in the scenario, one of them is offline ..What happens then?
one guys sells the 10 , but the offline guy sells 50, so the correct values when the offline guy comes online and the cloud databases sync should be 40 in onHand and $1060 in grossProfit. It becomes more syncfusing if there are more people hitting that calculated key and a few of them are offline.

will it sync correctly, ie parse and do the calculations correctly ? (remember there are local variables involved) 


Correct me if this already exists , but ideally this should be a query operator update , meaning you minus 10 from the existing cloud value rather than overwriting the value .

cdb_updateValue(tTable,tRecordID,tKey,tOperator,tValue,tTarget) into tCalcEffect

cdb_updateValue("transactions",tRecordID,"onHand","-","10","cloud") into tCalcEffect

this be a very important feature. Does it exist? Or do you have to handle calculated syncs by writing code?

Hi John,

CanelaDB stores data locally in a single array. This array encapsulates the entire project for a single region. The data is stored to disk in clusters. Clusters are a collection of records that have a defined number chars of their recordIDs in common.

-LiveCloud structure as seen in LCM
An account contains the following:
 Projects
  Tables
   Keys (columns)
    Data

-LiveCloud structure in terms of VMs
Each region consists of many VMs that hold our data. The following core sections are in walled-off VMs: Developer account management, Metric & Billing data, Users (cdbUsers), App Data, BLOBs. The region can scale both vertically and horizontally.
 Vertical: VMs can always get improved resources (RAM, CPUs, Disk) as needed.
 Horizontal: More VMs can be added to a region as needed.

-Some useful facts
 -No region is aware of the other regions.
 -We have developed software that analyzes the regions in near real-time to determine the general health of all the VMs. This software is responsible for building new VMs, moving data from one instance to another.
 

When the toolkit is exported, LCM builds the following structure for your project.
CanelaDB folder

• Config folder with config file
  
• Database folder with database data stored locally
  
• Libraries folder with CanelaDB libraries
  

Hi,

Ok, so I have a general but important question regarding scalability and how, let's call it LiveCloud's Array architecture is built and how we should design our apps and software with that in mind.

So first question (A) is: Is each account one very big array? Or is each project one array? Or is each table a separate array?

Let's say I'm building mobile apps that will eventually reach a worldwide audience with potentially millions of users in different countries. We have tables with login info (cdbUsers), others with profile information etc. If we have one million users then they would have 1 million rows. Then let's say that each user has it's own table with contacts, and the number of contacts could be in average 100 contacts for each user. 

What would be the best approach designing tables in this case. 

1. All contacts (100) for every user (1.000.000) is saved in the same table with some 100.000.000 rows

2. For every user a new table is created and thus these tables will only hold 100 contacts / rows in average.

But if everything is one super Big Array anyway, is there any difference between 1 and 2 above? Nr 2 is what I have in mind designing this, but on the other hand that will create potentially 1 million tables, and perhaps that will cause problems? On the other hand we can fetch the tables directly with the help of tableID so that should be faster right?

If there are limitations it would be good to know if we should, for example, have different projects for each country/state, or even different accounts. And of course we would use different Regional LiveCloud Servers for different parts of the world, and that would mean different accounts as it is now, right?

So in any case, some design guidelines would be helpful, and also if you made some really large tests yourselves with a ridiculous amount of data

Kindly
John

Hi,

Trying to add credit card info in Billing section under Account in LC Manager causes the application to crash...

Br /John

Hi,

Using UK server.

cdbUsers table in all projects has some problems now. The table is non-responsive. All other tables can be read in LiveCloud Manager, but not cdbUsers.

In apps this is the response given:

(2020-02-16 12:44:43.151): Local authentication unsure: no local data to verify
(2020-02-16 12:44:43.519): Cloud authentication - received nonse value
(2020-02-16 12:44:43.802): Cloud authentication - received apiKey
(2020-02-16 12:44:43.802): Cloud authentication passed
(2020-02-16 12:45:14.149): Error: The server response could not be downloaded at this time.
(2020-02-16 12:45:14.149): Error: There was a problem getting a response from the server for cdb_batchQueryCloud request.

It's been like this a couple of hours now.

What's happening? Updates? 

Br /John

After creating (either create or batch create) a record for two tables, and then immediately: (1) querying those tables; (2) reading those records; (3) and deleting those records ---

I get these three errors in combination: 

1) "The server response could not be downloaded at this time"
2) "Error: There was a problem getting a response from the server for cdb_batchCreateCloud request"
3) "Could not create record in cloud"

Any suggestion on how to avoid these errors?