Hello, I have more than two years developed desktop applications with xojo and MySQL server databases and now with PostgreSQL.
My application saves medical images and PDF documents inside the MySSQL database as blob type, but after a while the database grows and is damaged, I need to know what is the best practice to save images in the database and pdf documents
What is the best option and how would an example
1 Save the image or pdf as text type or blob?
2 Compress the image or the text with some method?
3 Save the information in XMlL, JSON?
I need to know how I can save the images and PDF documents in the database of the server and ensure that the database is optimal.
I have used MAMP Pro and sometimes I did not start the server and it came into conflict with the connection of the program, now I will use PostgreSQL.app I see that it is more stable and always starts correctly.
What is the best way to store enough images in a database with xojo and guarantee the stability of the PostgreSQL database.
Is a plugin necessary to compress and optimize the data?
[quote=411997:@Dave S]How can you see the database from another computer?
Yes, not making.
If you are in the team 1 insert an image and save the route only and the image is stored in a directory of team 1, as I can see from another computer the image that is inside the team 1 by means of its route.
You wouldn’t leave the image on Team 1’s computer. The database server needs to be set up in such a way to serve files as well, and you would need to copy the image from Team 1’s computer to the server for storage. Then, you’d save the path to the file on the server in the database. When someone requests the data, they would need to fetch the image from the server as well.
Another option you might consider is cloud storage. Your database server continues to serve the data, and a cloud provider like S3 or Wasabi serves the images. Then you don’t need to worry about piping the images over the database connection. The HTTP requests to get/put files are pretty simple and can be done in Xojo without any plugins. Plus, you get pretty much unlimited storage. Seriously, take a look at Wasabi. It’s only $5 per TB per month, no bandwidth charges.