Using awe S3 or DynamoDB as a data source

Richb201 commented on Feb 9, 2020

I am looking into using koolreport to generate reports from my php application. My app stores data in a few places; AWS S3, dynamoDB, and in mariadb tables running on my aws server. Can I access s3 buckets from koolreport? How about dynamodb?

Also is there any type of template functionality in koolreport?

Thanks,

Rich

KoolReport commented on Feb 10, 2020

Currently we have not had the data source class to work with S3 and DynamoDB yet. However, I have recorded your topics as suggestion so that dev.team will work on that. I will keep you update.

Could you please explain further on the template inquiry.

Richb201 commented on Mar 2, 2021

ok. It has been awhile since I posted this. I am back down to needing this. Previously I solved this by just keeping a copy of the image locally and had one of the mysql fields point at it. But I now need to store them centrally rather than on a specific server.

So I am uploading the image to s3. The path to the image is, for example: s3://substantiator-images/Screenshot from 2021-02-24 06-31-17.png I will keep this path in a mysql column. Right now I keep the path to the image in the mysql column, for example: assets/uploads/thumbnails/a34c0-screenshot-from-2019-04-21-15-46-17.png and koolreport handles it perfectly. Will I need to modify the path so koolreport can handle it? Or worst case, I can bring down the image and place it temporarily on the hard drive so koolreport can use it, but it it ugly, from a speed POV.

KoolReport commented on Mar 3, 2021

I think it is called Base64 image, you view more here. So your image can store in databases regardless whether SQL or NoSQL. You can query the image like you query string and put that string inside the src of img tag. It should be something like:

<img src="data:image/png;base64, <?php echo $image_content_from_database; ?>" />

Richb201 commented on Mar 3, 2021

thanks. I will work on figuring out how to access the imge that I uploaded to s3, today.

KoolReport's Forum

Using awe S3 or DynamoDB as a data source #1293

Build Your Excellent Data Report