|
|
|
|
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Jim Charter wrote:
> Darren New wrote:
>> Nicolas Alvarez wrote:
>>
>>> I'm about to write a database-based application for the family
>>> holiday pics. Maybe even something web-based on the LAN so that my
>>> sister can add the tags when she's bored.
>>
>>
>> I did one (a while ago) that stored the information in parallel
>> ".info" files, and from which you could generate a whole web site to
>> put on a CD. You're welcome to it, if you want. :-)
>
> Not sure what you are saying but it sounds closer to my purpose.
> Parallel .info files?
vacation/mexico/MomAndDad.jpg will have it's tagging information stored
in vacation/mexico/MomAndData.info
It's a bit clunky, but not too bad, and has the advantage that you can
go and reuse the information elsewhere, since it's a trivial format.
Plus, it has features like "keep this image, but don't include it in the
index pages" and so on. Sorts by date and by name (IIRC), and things
like that.
Also used by a server I built that basically did what Flickr does, only
on a small scale. Lets you upload images, comment on them, etc.
--
Darren New / San Diego, CA, USA (PST)
It's not feature creep if you put it
at the end and adjust the release date.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Jim Charter wrote:
> In a Windows environment,
>
> say I have a bunch of photographs stored on directories...
>
> suppose I want to store the photos and give them attributes such that
>
> I could retreive subsets of them using different filters on those
>
> attributes in a flexible, 'relational' way...
>
> is there currently any solution | method | common practice for doing
>
> this?
>
> assume I know nothing
>
> -Jim
google picasa is what I use to keep my photos... but I don't know if it
is what youa re after.
Tom
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Invisible wrote:
> On a slightly *less* insane note, you could probably build some kind of
> PHP thing where you submit photos, it gives each one a unique name, puts
> it in a folder somewhere, and stores some metadata about it in a MySQL
> database and gives you a web interface to query it.
Suppose I don't mind populating the MySQL database with the metadata
independent of the 'importing' or 'submitting' or 'photo acquiring'
process whatever it might be. What pieces would be needed to query the
database and return path names as hyperlinks. This would require PHP?
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Darren New wrote:
> Jim Charter wrote:
>
>> Darren New wrote:
>>
>>> Nicolas Alvarez wrote:
>>>
>>>> I'm about to write a database-based application for the family
>>>> holiday pics. Maybe even something web-based on the LAN so that my
>>>> sister can add the tags when she's bored.
>>>
>>>
>>>
>>> I did one (a while ago) that stored the information in parallel
>>> ".info" files, and from which you could generate a whole web site to
>>> put on a CD. You're welcome to it, if you want. :-)
>>
>>
>> Not sure what you are saying but it sounds closer to my purpose.
>> Parallel .info files?
>
>
> vacation/mexico/MomAndDad.jpg will have it's tagging information stored
> in vacation/mexico/MomAndData.info
>
> It's a bit clunky, but not too bad, and has the advantage that you can
> go and reuse the information elsewhere, since it's a trivial format.
>
> Plus, it has features like "keep this image, but don't include it in the
> index pages" and so on. Sorts by date and by name (IIRC), and things
> like that.
>
> Also used by a server I built that basically did what Flickr does, only
> on a small scale. Lets you upload images, comment on them, etc.
>
Sounds interesting. I have been playing with Picasa and I think I will
use it for some things I want to do. But I have other situations I am
not sure yet it could handle. Like zipping and unzipping folders. It
seems like once the folder goes away, so does the metadata. I am
thinking there are was in which 'clunky' is better.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Jim Charter wrote:
> Sounds interesting.
http://s3.amazonaws.com/darren/PicEdit.zip
It's a 32K chunk of Tcl and a 700K chunk of jpeg handling binary
executable for Windows. If you have Tcl and TclLib installed, it should
just do its thing if you install the image extension.
I'm pretty sure it should work under Linux too.
You might have to futz with the source to configure some of the stuff.
Run the program without any arguments for help.
--
Darren New / San Diego, CA, USA (PST)
It's not feature creep if you put it
at the end and adjust the release date.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Jim Charter wrote:
> Invisible wrote:
>
>> On a slightly *less* insane note, you could probably build some kind
>> of PHP thing where you submit photos, it gives each one a unique name,
>> puts it in a folder somewhere, and stores some metadata about it in a
>> MySQL database and gives you a web interface to query it.
>
> Suppose I don't mind populating the MySQL database with the metadata
> independent of the 'importing' or 'submitting' or 'photo acquiring'
> process whatever it might be. What pieces would be needed to query the
> database and return path names as hyperlinks. This would require PHP?
You could do that in a web-based way using essentially any server-side
scripting technique you like (PHP, ASP, Perl, Haskell CGI...)
Alternatively, MySQL might have tools that allow you to do this more
easily; I'm not aware of any, but I haven't looked for one either.
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Jim Charter wrote:
> Invisible wrote:
>
>> On a slightly *less* insane note, you could probably build some kind
>> of PHP thing where you submit photos, it gives each one a unique name,
>> puts it in a folder somewhere, and stores some metadata about it in a
>> MySQL database and gives you a web interface to query it.
Yes. You also could push the images to the MySQL db, but is there any point?
> Suppose I don't mind populating the MySQL database with the metadata
> independent of the 'importing' or 'submitting' or 'photo acquiring'
> process whatever it might be. What pieces would be needed to query the
> database and return path names as hyperlinks. This would require PHP?
Or, like Andrew said, any other server-side scripting language. Plus's
for PHP are that it's easy and that it has native support for talking
with MySQL. Minus for PHP is that it's also easy to create serious,
potential security holes.
--
Eero "Aero" Ahonen
http://www.zbxt.net
aer### [at] removethiszbxtnetinvalid
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Darren New wrote:
> Jim Charter wrote:
>
>> Sounds interesting.
>
>
> http://s3.amazonaws.com/darren/PicEdit.zip
>
> It's a 32K chunk of Tcl and a 700K chunk of jpeg handling binary
> executable for Windows. If you have Tcl and TclLib installed, it should
> just do its thing if you install the image extension.
>
> I'm pretty sure it should work under Linux too.
>
> You might have to futz with the source to configure some of the stuff.
> Run the program without any arguments for help.
>
Thanks! Off to install Tcl
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Jim Charter wrote:
> Thanks! Off to install Tcl
BTW, apparently Tcl 8.5.0.0 was *just* released by ActiveState. In
contrast to all earlier versions, this comes as a minimal install along
with an automated mechanism for accessing the Teapot (the Tcl equivalent
of CPAN).
You might want to start with 8.4.mumble from ActiveState, which includes
pretty much everything except the image extension.
--
Darren New / San Diego, CA, USA (PST)
It's not feature creep if you put it
at the end and adjust the release date.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Darren New wrote:
> Jim Charter wrote:
>
>> Thanks! Off to install Tcl
>
>
> BTW, apparently Tcl 8.5.0.0 was *just* released by ActiveState. In
> contrast to all earlier versions, this comes as a minimal install along
> with an automated mechanism for accessing the Teapot (the Tcl equivalent
> of CPAN).
>
> You might want to start with 8.4.mumble from ActiveState, which includes
> pretty much everything except the image extension.
>
thanks for the heads-up, that's in fact what I did, some of the old
instincts still intact. ;)
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |