472,124 Members | 1,375 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,124 software developers and data experts.

graphics files, MySQL and Java

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.
Jan 17 '07 #1
1 2045
4,258 Expert 4TB
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:
Jan 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

21 posts views Thread by BlackHawke | last post: by
1 post views Thread by Tony Johansson | last post: by
4 posts views Thread by Martin | last post: by
6 posts views Thread by Jack Nielsen | last post: by
11 posts views Thread by achiever | last post: by
3 posts views Thread by tulika dutta | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.