. I get sidetracked pretty easy. Found another couple of useful tricks in the Chapter 1 sample file. Some cool stuff with using buttons to pass script parameters and some cool formatting tricks using the auto resize.I was researching an idea I had about storing graphics outside of the database and then using FileMaker to point to a reference of the image. This is pretty straight forward but what happens if the folder the images in is moved or renamed? Short answer is that the links all break. This is not good. There are some interesting workarounds but it's really overkill for what I am doing.
Just curious, are you wanting to store the images on the file system instead of as blobs in the db itself to save time/space with db backups? Why not build an XML schema to control storage and retrieval of images? This way at least the filesystem follows a rigid structure but, unlike db records, each image can be backed up independently and only when necessary.
ReplyDeleteI guess if i was storing large images it would be an issue. These databases should only be storing 500 pixel max pngs or jpgs.
ReplyDeleteWhen you link to a reference you only get a file icon so i would still have to paste in a thumbnail and by that time it's to much work for little pay off.
If I was using this as a DAM it might be worth it.
Any Thoughts?