bon733
Posts: 25
|
| Posted: 07/12/2006, 2:44 PM |
|
I have a client that would like to upload his picutres from his digital camera into an application I wrote using CCS 3.0. I would like to have the photos stored in the database so they will be replicated to the home office. Has anyone done something with creating a popup window to select the file(s) and then saving them to a database?
|
 |
 |
DonB
|
| Posted: 07/12/2006, 6:35 PM |
|
Yes.
I would not recommend saving the actual images to the database. You will
probably find limits with the block size or buffer size trying to get the
images in and out. And it's not terribly speedy doing that, either.
Just use a simple Record form, put an Upload control in it. This will store
the filename in the database and the file in the file system. There's a
whole set of issues to think through as to how many images, how they are
stored, resized, whether you need thumbnails, and so on. Not hard, just
several things to plan out before you jump into it.
I happen to have a situation with several tens of thousands of images being
stored. They are all numbered. I 'hash' the numbering scheme to create 100
buckets (00 through 99) and store the images in the bucket that matches the
last 2 digits of the image number. This maintains fewer images per folder
so there's better directory-lookup performance.
You can easily replicate the files between offices with the ftp functions
built into PHP, if you are using that. I use a 'cron' job to do this
nightly.
--
DonB
http://www.gotodon.com/ccbth
"bon733" <bon733@forum.codecharge> wrote in message
news:244b56d4ad42d5@news.codecharge.com...
> I have a client that would like to upload his picutres from his digital
camera
> into an application I wrote using CCS 3.0. I would like to have the photos
> stored in the database so they will be replicated to the home office. Has
> anyone done something with creating a popup window to select the file(s)
and
> then saving them to a database?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
