| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There is currently 1 user online
» 0 Member(s) | 1 Guest(s)
|
| Latest Threads |
User authentication: lost...
Forum: Getting Started
Last Post: stamatis
04-22-2025, 07:03 PM
» Replies: 18
» Views: 39,267
|
"Manage Emails" - changin...
Forum: Bug Reports
Last Post: stamatis
04-22-2025, 03:56 PM
» Replies: 1
» Views: 493
|
CDB will not load in Live...
Forum: General
Last Post: stamatis
04-16-2025, 03:11 PM
» Replies: 0
» Views: 259
|
using cdb_auth with Live...
Forum: General
Last Post: JereMiami
12-19-2024, 01:58 AM
» Replies: 0
» Views: 716
|
BLOBs - not possible to a...
Forum: General
Last Post: stamatis
10-06-2024, 06:28 PM
» Replies: 0
» Views: 687
|
Allow users to change the...
Forum: General
Last Post: mark_talluto
01-18-2024, 01:09 AM
» Replies: 8
» Views: 14,150
|
cdb_sendEmail
Forum: General
Last Post: mark_talluto
11-07-2023, 09:57 PM
» Replies: 0
» Views: 1,039
|
cdb_sync & cdb_lookupvalu...
Forum: General
Last Post: mark_talluto
11-07-2023, 09:45 PM
» Replies: 1
» Views: 1,871
|
cdb cdb_sendEmail
Forum: Bug Reports
Last Post: JereMiami
10-05-2023, 01:57 PM
» Replies: 0
» Views: 2,191
|
LCM: "Please inform Canel...
Forum: General
Last Post: mark_talluto
07-12-2023, 07:58 PM
» Replies: 24
» Views: 31,422
|
|
|
| Blobs and Datagrids |
|
Posted by: sid - 04-12-2020, 12:52 PM - Forum: Code Samples
- Replies (2)
|
 |
Hi Guys
I have a few questions on BLOBS and datagrids and will appreciate some sample code here.
I have managed to create a form with a datagrid on it , and a image object that retrieves the images from the cloud when a user hilites a line on the grid. This is designed as a cloudcall and not a local call , so its a tad slow.
here is a vid on how this works : https://www.loom.com/share/d609c74551df48309f51723192353039
here is the code:
Code: local tBlobGridRef, tPathToBlob, theLine, theSelectedID, tPHtender
getProp uSelectedPicID
put the dgHilitedLines of me into theLine
return GetDataOfLine(theLine,"blobReference")
end uSelectedPicID
on selectionChanged pHilitedIndex, pPrevHilitedIndex
show widget "PHSpinner"
put empty into tBlobGridRef
put empty into tPathToBlob
put the uSelectedPicID of group "Tenders" into theSelectedID
put cdb_readBlob(theSelectedID,"cloud") into tPathToBlob
set the filename of image "tenderPicViewer" to tPathToBlob
//set the text of image "tenderPicViewer" to tPathToBlob
put the text of image "PHTender" into tPHtender
if tPathToBlob is empty then set the text of image "tenderPicViewer" to tPHtender
hide widget "PHSpinner"
end selectionChanged
Here is question 1. Its a cloud call but the path to the image ends up being a local path? Its pretty slow ,( perhaps because I'm living in a rural farm town) Does the system download the image if its a cloud based call or just look in the local Blobs table if it exists?
so I tried to resize all images to under 10kb and that helped a lot. Much faster, so I tried to put the text of the image into a table key, (not a BLOB table) figuring I can just store the text into the key and then that should speed it up more if its just a 100x80 pixel .png thumbnail. LCM did not seem to allow this? can we actually do that? Or will it totally mess up the performance?
Question 3 , Is it possible to put a thumbnail of a BLOB into a DataGrid? and if so, is it possible to only load the images that will be visible to the user (IE. only when the lines are visible on his screen. Will appreciate some help with this.
I am designing a system with at least 70000 product items and God help a tablet trying to load ...lets say 30000 thumbnails if a query is run. It will probably die...although it will be interesting to test. So the idea is run a LCM Query and put the results into a DataGrid table with a BLOB in one of the columns.
Question 4. Is it possible to have more than 1 Blobs table? because I feel that it important could separate things like documents and High Res images from thumbnails, because you do not want to sync the High Res Blob table with a thing like a POS system or a tablet.
Would really appreciate some sample code for question 3
I have to say that this is the easiest , most productive database design I have ever seen. I'm a total beginner and did not have to learn a single sql query with the code snippet feature . Thanks Livecloud !!!
Keep safe everyone!
Sid
|
|
|
|
| Post in Announcements fixed! |
|
Posted by: mark_talluto - 04-10-2020, 06:46 PM - Forum: Announcements
- Replies (3)
|
 |
Hi Everyone. A big shout out to Clarence for pointing out that our Announcement forums were locked and would not all posting replies. This has been fixed. Please feel free to reply to any announcement you like. WhenInSpace has already tested it out with his post this morning.
We are looking forward to hearing your thoughts.
|
|
|
|
| Version 2.6.0 released |
|
Posted by: mark_talluto - 04-10-2020, 01:12 AM - Forum: Announcements
- No Replies
|
|
Hi Everyone. We have released version 2.6.0 of LCM. Included you will find the new cdb_calcUpdate() API.
If you want to use the new API in your apps, you will need to export the updated ToolKit and apply it to your apps.
If you have any thoughts on this API, the sooner you report them to us the better.
If we need to make any changes, it is best to make them before the API starts to get used in apps.
|
|
|
|
| cdb_sendEmail in the future |
|
Posted by: mark_talluto - 04-10-2020, 12:12 AM - Forum: General
- Replies (3)
|
|
I received the following question via email. I am bringing it to the forums because we would like to hear your thoughts.
Quote:https://docs.livecloud.io/SendEmail/
Hello when I sent the mail it appeared in the spam folder and gmail told me that the email sent might be malicious. Is there a way to prevent this or that is what will happen.
We are using a 3rd party provider for the email feature. This is a problem for us as well. We have been working on our email reputation, but it is not perfect. We probably have to pay more money to get a dedicated IP for just our use. But, having everyone use this API will only put it at risk. It may be an API that we eventually have to remove from CanelaDB. It will not serve anyone for serious work.
But, we still have some potential value for everyone. We worked to wrap the SendGrid API for our email feature. We could have anyone that wants to get their own account and feed cdb_sendMail with your own SendGrid Authentication API key. Then, we could send the emails through your account and protect you from other users. That would be a better solution than what we have now.
This is not something we are going to work on just now. We thought it would be good to get people thinking about the direction options we can take on this API.
|
|
|
|
| What is Appli? |
|
Posted by: mark_talluto - 04-08-2020, 10:50 PM - Forum: Announcements
- Replies (2)
|
|
We released LiveCloud officially at the last LiveCode conference. We also demoed an early version of Appli during our session. The attendees showed great interest in our work on Appli and even pulled me aside to tell me how they would use this technology.
We are creating Appli to complement LiveCode and LiveCloud. I view it as the missing story in the trilogy.
You can think of Appli as a focused IDE for business apps. Appli will connect your data to UI and the other way around.
If you have enjoyed using tools with modern layout elements like Keynote and Adobe XD, you will be happy to hear that Appli is bringing that to LiveCode developers. Appli will enable developers to bring their business apps to life faster than ever before. We know that newcomers to LiveCode that come from low-code environments find UI integration with data in LiveCode to be a hard transition.
I am not going to get into all the features of Appli right now. This announcement is more akin to the smell of cookies when you visit grandma's house. You can't eat the cookies just yet. Sit back and enjoy the aromas as they waft about the forum.
We think this news is very relevant to LiveCloud users because we keep getting requests for examples of how to connect your UI to your data. For the time being, we will make announcements on our progress with Appli here. We are looking for a soft launch by the end of the summer of 2020.
A video showing aspects of Appli will be released shortly.
|
|
|
|
| Version 2.5.8 released |
|
Posted by: mark_talluto - 04-08-2020, 10:06 PM - Forum: Announcements
- No Replies
|
|
I am sorry about skipping this release. 2.5.8 comes with some more improvements to the experience of importing data.
This update is a solid bug fix update.
Bugfix: After importing new data with new keys, the LCM UI would not update to reflect the new data and keys.
Bugfix: After removing keys using the full key list display, importing data, and viewing the full key list display, there would be a blank row in the keys list.
Bugfix: If an import failed, the import routines would continue to run.
Bugfix: When switching tables within the code builder, your code will no longer be replaced with default code.
Improved: Window drawing is now smoother.
|
|
|
|
| Blob Viewer Stack to incorporate into projects |
|
Posted by: sid - 04-08-2020, 04:19 PM - Forum: Code Samples
- Replies (3)
|
|
Hi Guys
I was wondering if its possible to release a BLOB viewer stack that people can use to incorporate into their projects?
Very similar to the login stack that you guys provide-, which makes it easy to get the basis of a projects started.
then all devs have to do is pass a BLOB id in the stack to and you have a Built in BLOB viewer from your own livecloud application.
you could also put it into the samples stack or the page that you use to export your toolkit. You can also add a button to replace the BLOB
that would be a great feature
Sid
|
|
|
|
| Version 2.5.9 Released |
|
Posted by: mark_talluto - 04-06-2020, 05:07 PM - Forum: Announcements
- No Replies
|
|
This update is not huge, but it does have a pet peeve of mine resolved. You can now make new projects and tables by clicking on the 'plus' sign and then entering the name of the object in a dialog. I find this to be more intuitive. For those that liked the previous method, it is still available.
|
|
|
|
| Windows OS problems |
|
Posted by: Bizbuzz - 04-06-2020, 01:55 PM - Forum: Bug Reports
- Replies (3)
|
 |
Hi,
So we're developing mobile apps for both IOS and Android, they are working well, and an application that should run on both Mac and Windows.
On Mac it works well both in development and compiled.
On Windows it gives "The Canela SDK missing. Please export your CandelaDB again" if stack opened in Livecode Business 5.1.
If compiled to a Windows version from Mac, it doesn't work / download data, so no luck there. *CORRECTED: It does work But i tried to log in with a user created in Mac, and I don't think password hash matched. I will try to create new user from the Windows application instead.
I've tried several things. Among them to export the toolkit from a LiveCloud Manager that runs on Windows, in case of encryption being different or something.
As your stacks are encrypted, and encryption results can be different between platforms, could that be the issue here?
Something is wrong in any case ....
Br /John
|
|
|
|
|
