graphics files, MySQL and Java

[marcbachman]

Hello-
I hope to have a touchscreen Java application soon that will display images and text fetched from a MySQL database. ( terminal runs the application on a remote server on the LAN ) I have seen an earlier post that suggests simply storing the URL for the image file in the database, however, I was hoping to avoid that since I'm not using a browser ( I think) or HTML. The images will probably be in the < 99 KB range, but I don't have any experience at all with what kind of performance sacrifice that might cause. I'm only working with a few dozen images, but I might as well do it right from the start. Can I store a ~/path in MySQL or just put them in the same folder as the application and get the best results?
Also, I'm supposed to create an interface kind of like sqlplus where somebody who is not a programmer can Add/Edit/Delete from the database and I need to make it as easy to code and as easy for them as I can.

[ronverdonk]

You should not store a path name in the db, just the image file name. In your server handling code you can setup a path in a variable string and append the image name from the db to that to get the full name. This makes you more flexible because, in case you move your images to another directory you'd only have to change 1 variable, while, when it is stored in the db, you'd have to change all filenames.

As to your question about an interface: we are willing to help people who have problems or questions on scripts they are working on. We do not produce any ready-made code. You'll have to develop that yourself. And, of course, we will assist you, but the development work is yours.

Ronald :cool: