Android Question MySql Immage

[roberto64]

Hi, I'm trying to insert a Mysql database of images in the db I have 4 fields with photos, to insert them I'm first compressing the image, thus reducing the image kb, and then I display them in an "ImgCa1 As B4XView, 2 ,3,4 ", then when I store it in the MySql db I encode it" Base64EncodeDecodeImage.Base64ImageToString2 (bitmap1) ", in the mysql db with the Photo table and use" Type LongText ", but when I send the data in the db and slow to archive the 4 photos , and then in the db I see how much space is occupied in the table about 3.24Mb is occupied, instead when I compress the four photos saved in the compression directory of the mobile phone they are just 200Kb. greetings and thanks for your help

 

[roberto64]

The question is: do I have to save an image, in the mysql database as little as possible to ensure that the DB does not grow too large over time

 

[aeric]

I don't recommend to store image files inside a database. Just store the file names or path is adequate.

 

[roberto64]

Hi aeric, can you recommend some examples, or where to see to understand how to store the images inside a folder on the server? Thanks

 

[aeric]

Hi aeric, can you recommend some examples, or where to see to understand how to store the images inside a folder on the server? Thanks

You mean example of uploading file to a B4J server?

 

[roberto64]

No from a B4A application to a server with a mysql db

 

[aeric]

No from a B4A application to a server with a mysql db

Is your server running PHP, ASP.NET or built with B4J?

 

[roberto64]

il server e linux, ed all'applicazione b4a sto usando jdbcSQL.

 

[aeric]

[Server] Upload files from your B4A app to your B4J server over the internet

This example shows how to make your B4J server application accessible over the internet. The implemented server is a simple file server that allows you to upload files from your B4A application to the server over the internet. The following steps are required in order to make your server...

www.b4x.com

 

[roberto64]

Thanks, now I'll give it a look