Save and retrieve Picture from camara (sQlite)

[grant1842]

Hello all. I am trying to save and retrieve a picture taken with the phones camara .
I am using an sqlite(Taifun) database.

I am not getting any Errors. But there does not seem to be an image in the database.
I have done a search on the forum. There is some information about mySql and a few other things.
I ask here because that is what Taifin recommends on this site.( App Inventor Extensions: SQlite | Pura Vida Apps

Here is my code blocks.

Thanks for any help with getting this working.

[gordonlu310]

Hello user,

You are not using App Inventor, but another distribution. Please ask on their forum, and the extension developer can help you there.

Also, where did you get the extension "SQLite Addons"? It does not seems to follow the naming conventions. Do you have a link to the topic where you got it?

[TIMAI2]

It is an Andres Cotes extension (can be found in Taifun's list). Naming conventions ignored to match SQL query syntax.

[Taifun]

@grant1842

I am trying to save and retrieve a picture taken with the phones camara .
I am using an sqlite(Taifun) database.

What you are doing currently is to store the path to the image, but not the image itself... to store only the path to the image is sufficient and you can display the image later again as long as you do not delete it from the device

However later you send a query to the database to get all images back, which have been stored and try to display all these images at the same time in an image component This obviously will not work. You only can display 1 image.

use Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools
Taifun

---

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

[grant1842]

Thanks for your comments. I do not understand how this block code is just storeing the path.

I thought when you insert a picture in a blob field of a sqlite database it stored the image .

Is there some tutorial i can read to help me understand how this blck code works.

I use pascal to retrieve the image from the blob field like this.

procedure TAccessCameraAppForm.SpeedButton2Click(Sender: TObject);
var
        BlobStream: TStream;
  begin
    AccessCameraAppForm.viewimgquery.ParamByName('_PicId').AsInteger :=
    AccessCameraAppForm.FDQuery1.FieldByName('ID').AsInteger;
    AccessCameraAppForm.viewimgquery.Open;
    AccessCameraAppForm.viewimgquery.First;
    while (not AccessCameraAppForm.viewimgquery.EOF) do
        begin
        // access a stream from a blob like this
          BlobStream := AccessCameraAppForm.viewimgquery.CreateBlobStream
          (AccessCameraAppForm.viewimgquery.FieldByName('pictures'),
          TBlobStreamMode.bmRead);
             try
           AccessCameraAppForm.imgCameraImage.Bitmap.LoadFromStream
              (BlobStream);
           // itm := Form4.ListView1.items.Add();
           finally
           BlobStream.Free;
           end;

                AccessCameraAppForm.viewimgquery.Next;
        end;
    end;

I need some information on how to store the image in the blobfield and retrieve it.
If this blck code doesn't store the image in the blobfield and just the path I need some tutorial or example to help me understand.
Thanks for the help.

[Taifun]

please explain why you think, you have to store the image as blob and why it is not sufficient to store only the path to the image...

as you are using a local database, usually the image still is available on the device under that path...
storing the image as blob needs a lot of memory... why storing the image again in the database when it already is there on the device?

Taifun

[grant1842]

Thanks for your response .
I was thinking i need to store it in the database so I can back up the database and all info and images will be backed up in the database.
I really appreciate your help.
I have used Turbo Pascal to program in the past and i allways stored all info and images in the database.

Is there a tutioral that shows the storing and retrieval of images and there paths here for ai2 ?

[Taifun]

Before storing the image as blob in the database, you have to convert it into a blob...

You can use one of the following methods
using the webviewer and some JavaScript

File to Base64 with JavaScript

To convert a String to/from Base64 in JavaScript, we use the btoa and atob commands. Here is another code to convert a file to Base64: ToBase64.htm <script> async function readTextFileAsBlob(file) { const response = await fetch(file); const blob = await response.blob(); return blob; } const blobToBase64DataURL = blob => new Promise( resolvePromise => { const reader = new FileReader(); reader.onload = () => resolvePromise(reader.result); reader.rea…

using an extension

Base64 Tools - four little ones ;)

These three simple individual extensions are already rolled into Juan's Base64 extension, but I believe it may be useful to some to have access to individual functions for specific needs.... There is now a fourth little one, not included in Juan's extension, for the Canvas ImageSprite. Image To/From Base64 This extension has two functions, the first will convert whatever image is in an image component to a base64 string, the second will load a base64 string to an image component. There is an …

There might also be other method, see also Search results for 'Blob' - MIT App Inventor Community

Taifun

[grant1842]

Thanks so much for the help Taifun . I really like this platform . I am trying to learn it.