469,326 Members | 1,621 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

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.
Jan 17 '07 #1
1 2010
ronverdonk
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
1 post views Thread by CARIGAR | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.