Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
How much additional work will be required to get this generated code to populate a table?? (An example video would be great.) This 1.2 minute promo video is just too short.Point and click to create your database and to automatically generate the LiveCode scripts you need.
Our code generator will do full CRUD operations. You could use it to get you started with a simple array to create records and thus populate your table.1- How much additional work will be required to get this generated code to populate a table?? (An example video would be great.) This 1.2 minute promo video is just too short.
If I understand correctly, you are asking how to work with a data-model where you have a one to many relationships. You could denormalize your data and consider each record to be a document. All data related to the header would then be found in the single record. Or, you could build two tables and have a foreign key to connect the two tables together. This is managed manually on your code side. We currently do this in NurseNotes (one of the apps we make). If I totally missed your question, please let me know.3- Since CanelaDB is a NoSQL DB (as opposed to traditional relational database), generally speaking, what would be the difference when accessing records with a typical Header/Detail relationship?
Yes on date ranges. More query range support could be added. We are interested in feedback that will help developers get their work done faster.4- I see there is extensive support for defining keys. When doing a Query (read) from the online CanelaDB, is it possible to request a range of records? Ie: between this-date and that-date?
Yes. LiveCode's filter is used internally.Is there any capability to make queries based on wildcards?
Please elaborate on this.Full text indexing?
One of the most important is that your code-base works in either local or cloud with a single argument change. Another is that it fully utilizes arrays. You can even store arrays in keys. The library is very light in terms of memory. We update it often. So, you always have access to the latest version. CanelaDB deals well when the internet goes offline. Key outgoing traffic is automatically cached for you and sent when the internet returns. Encryption and authentication are built-in. So, you can subtract those from your workload. We also have built-in user support. This is automatically tied to the authentication features. We are working on adding roles and privileges. More details can be found here: https://livecloud.io/features/Aside from increased speed, what other special features does the CanelaDB offer?
The in-memory allocation is 500 MB. This is the amount of space allotted to the 'Rain' account for queryable data. This space may be spread out over different instances on different servers in a given region. The 20 GB of blob space is stored differently. We use the Digital Ocean Spaces object storage for this feature. This data is not queriable. It is useful for large chunks of data like pictures, video, PDF, etc.5- I see "Rain" hosting plan supports a 500 MB cloud database and 20 GB blob storage. Does that 500 MB in-memory area just act as a cache for the 20 GB? Or does each table inherently live in one or the other?
The 'Rain' tier is a shared environment in terms of resources. The more developers that use the service the more resources we will have to share within a given region. The service automatically monitors the health of each region. When resource usage increases, droplets are spun up and added to the region. As we add droplets to support a region, your data will be partitioned across the instances available. This will allow for a certain amount of disproportionate spiking by a range of accounts.6- What about data throughput? Is there a limit on traffic?
Yes, the pricing is linear. Double the memory used should generate a bill very close to 2 x $15.And if by chance someone needed twice as much storage as the current "Rain" plan offers, would the price be approximately twice as much?
A region is defined by the geographic locations where Digital Ocean has placed their datacenters. Their regions are located near the bottom of their homepage https://www.digitalocean.com. This will allow a developer to pick the best geographic region to support its customers.7- I see the "Rain" plan includes 1 Data Region. What exactly is a Data Region?
Yes and yes.Also, I see there is a CreateProject command. Does this mean data can be segregated between different apps, by defining them each as separate projects?
8- Exactly what field types are supported? I read somewhere that NoSQL databases allow the user to define field types. Is this required? How does that work? I see you use the CouchDB logo on your site. Is CanelaDB a subset of CouchDB?More query range support could be added.
9- Interesting. Would the address of the blob object, then be stored in memory, as a field in a table? Would this be an internal address or a public URL? Does this mean that all the contents of all tables that have keys, must be stored in the 500 MB area?The in-memory allocation is 500 MB. This is the amount of space allotted to the 'Rain' account for queryable data. This space may be spread out over different instances on different servers in a given region. The 20 GB of blob space is stored differently. We use the Digital Ocean Spaces object storage for this feature. This data is not queryable. It is useful for large chunks of data like pictures, video, PDF, etc.
More videos are being created this week. They will cover a number of topics.This 1.2 minute promo video is just too short.
The fields in CanelaDB are not typed. They are strings. Thus, you can store strings and binary data as values in any key. CanelaDB is 100% built in LiveCode. It is basically a monster array machine. It is a testament to what can be built with LiveCode.8- Exactly what field types are supported? I read somewhere that NoSQL databases allow the user to define field types. Is this required? How does that work? I see you use the CouchDB logo on your site. Is CanelaDB a subset of CouchDB?
I recently wrote how this works on our forums. You can view this here: https://forums.livecloud.io/showthread.php?tid=79- Interesting. Would the address of the blob object, then be stored in memory, as a field in a table? Would this be an internal address or a public URL? Does this mean that all the contents of all tables that have keys, must be stored in the 500 MB area?
gagsoft wrote: ↑Sun May 19, 2019 12:59 pmI am highly exited plus bit concerned at the same time.
After purchasing the LiveCloud 9 and LiveCloud 1 yr subscription from the latest promo,
I only received a confirmation email from PayPal.
Would really appreciate it if anybody could shed some light on this as I do not know what my next step should be.
best
Peter
