Taking photos and compressing them before send to a server

[Kleyber_Derick]

@TIMAI2

hmm, just been testing, extension does not appear to be working in companion for some reason!

Yeah, that's what I'm looking here too... companion stops working. Maybe I have to test with APK.

[TIMAI2]

Give me a little while....

[Kleyber_Derick]

Ok, thanks for your time!!!

[TIMAI2]

Nope, working OK, just having a senior moment!

Blocks like this:

Don't try to load base64string to a Label, this may be causing the companion to stop.

[Kleyber_Derick]

Great!!! All working ok here. This is my result:

Now my problem is another one. But I will open another post.

Thank you!!!

[Kleyber_Derick]

Just complementing my results... the Base64 string generated was saved, but it is too big. When I try to access the field (TEXT type) the app has to wait almost 30 seconds to react... That's why companion is stopping (I've tested with APK). I think I need to compress (or reduce) the image before converting to Base64...

[TIMAI2]

OK, seems we are not getting the expected outcome....

Try this way.

You will need my Image Convertor extension and @Juan_Antonio 's KIO4_Base64 extension (so we can use the FileToStringDirect block).

This will resize the file 400 longest side, generally taking a 3mb original camera image down to @ 100kb, which should be much more manageable.

Blocks like this:

note: this overwrites the original image, so use a different output path if you want to retain the original.

[Kleyber_Derick]

Ok, I'll try again and tell you my results.

Thank you!

[Kleyber_Derick]

Ok, now the app is not slow and not stopping, at least in APK. I'm going to test using companion and see..

[TIMAI2]

There is another way, using the procambase64 extension

theprocamwayto64.aia (34.3 KB)

This takes a preview (thumbnail) picture instead of the full camera image. Is going to depend on your needs and final image quality. if only viewing on phones, and you do not need fine detail, this might be all you need in terms of size/resolution.

[Kleyber_Derick]

Great, my friend. Thank you again!! I'll try this way and see which result is better.

Regards,

[Kleyber_Derick]

Well, this is my results: Everything works as expected. About resizing the image, etc. Now I am saving the base64 string into a sqlite field (TEXT type) and the app does not stop, even in companion:

Now my problem is when I send the image to a MySQL remote server. But this is another subject.

Thank you @TIMAI2 for your guidance and help.

[TIMAI2]

@Kleyber_Derick

Now my problem is when I send the image to a MySQL remote server

Read this topic:

MySQLi. Upload and save image file as BLOB. PostFile. PostText

Hello friends, In this tutorial we saw how we can save text in a MySQL database: MySQLi. PHP. GET. POST. Insert. Update. Delete. Show. 000webhost 0.- Now we are going to upload an image file and save it as a BLOB in MySQL. BLOB: Binary Large Object, it can store image, sound, video, pdf, video files… There are several types: TINYBLOB: Stores up to 255 bytes. BLOB: Stores up to 65,535 bytes. MEDIUMBLOB: Stores up to 16,777,215 bytes. LONGBLOB: Stores up to 4,294,967,295 bytes. We will use…

[Kleyber_Derick]

Thank you again @TIMAI2 Yes, I’ve read this. The doubt is when the source is from a SQLite text type field.

[TIMAI2]

You will need to get the base64String from sqlite, then upload this to your mysql server

or

send it to your mysql server more or less at the same time you store to your local sqlite server, along with any associated data (e.g. filename / extension...)

[Kleyber_Derick]

@TIMAI2

You will need to get the base64String from sqlite, then upload this to your mysql server

That’s what I am doing. In my PHP script, I am receiving the data and using base64_decode to store in a blob field. It stores but the image in mysql is just a black image