RE: pushnet thumbnails

From: Ivan Kwok <ivan_at_mediadefender.com>
Date: Thu, 29 Mar 2007 12:52:47 -0700

Dylan, can you populate the table with some entries? Thanks.

 

-Ivan

 

From: Dylan Douglas
Sent: Wednesday, March 28, 2007 12:10 PM
To: Ivan Kwok
Cc: Stefan Kaczmarek; Ty Heath; Ben Ebert; Jay Mairs
Subject: RE: pushnet thumbnails

 

Done. :)

 

 

mysql> desc thumbnail_creation;
+----------------+---------------------------------------------+------+-
----+---------------------+-------+
| Field | Type | Null |
Key | Default | Extra |
+----------------+---------------------------------------------+------+-
----+---------------------+-------+
| hash | char(40) | NO |
PRI | NULL | |
| requests | int(10) unsigned | NO |
MUL | NULL | |
| last_requested | timestamp | YES |
MUL | 2000-01-01 00:00:00 | |
| last_update | timestamp | YES |
| 2000-01-01 00:00:00 | |
| status | enum('REQUESTED','DOWNLOADING','GENERATED') | NO |
| REQUESTED | |
+----------------+---------------------------------------------+------+-
----+---------------------+-------+

 

----------

Dylan Douglas
MediaDefender

 

________________________________

From: Ivan Kwok
Sent: Wed 3/28/2007 11:49 AM
To: Dylan Douglas
Cc: Stefan Kaczmarek; Ty Heath; Ben Ebert; Jay Mairs
Subject: RE: pushnet thumbnails

Thanks Dylan. I'll need another timestamp for the last status update, so
that I can tell how long it's been downloading and timeout those are
taking forever to download.

 

-Ivan

 

From: Dylan Douglas
Sent: Tuesday, March 27, 2007 10:36 PM
To: Ivan Kwok
Cc: Stefan Kaczmarek; Ty Heath; Ben Ebert; Jay Mairs
Subject: RE: pushnet thumbnails

 

Done. Here's the desc:

 

mysql> desc thumbnail_creation;
+----------------+---------------------------------------------+------+-
----+-------------------+-------+
| Field | Type | Null |
Key | Default | Extra |
+----------------+---------------------------------------------+------+-
----+-------------------+-------+
| hash | char(40) | NO |
PRI | NULL | |
| requests | int(10) unsigned | NO |
MUL | NULL | |
| last_requested | timestamp | YES |
MUL | CURRENT_TIMESTAMP | |
| status | enum('REQUESTED','DOWNLOADING','GENERATED') | NO |
| REQUESTED | |
+----------------+---------------------------------------------+------+-
----+-------------------+-------+

-D

 

----------

Dylan Douglas
MediaDefender

 

________________________________

From: Ivan Kwok
Sent: Tue 3/27/2007 2:08 PM
To: Dylan Douglas
Cc: Stefan Kaczmarek; Ty Heath; Ben Ebert; Jay Mairs
Subject: RE: pushnet thumbnails

Dylan, please let me know when you have the the
thumbnails-to-be-generated table ready. We will need hash,
request-count, status(something like non-queued,pending,generated), and
last-status-timestamp.

Thanks,
-Ivan

-----Original Message-----
From: Stefan Kaczmarek [mailto:stefan_at_thezonie.org]
Sent: Monday, March 26, 2007 5:00 PM
To: Ty Heath
Cc: Dylan Douglas; Ben Ebert; Ivan Kwok; Jay Mairs
Subject: Re: pushnet thumbnails

Sweet ... That'd be perfect for the GUID.

SEXYTIME!

- Z

On Mar 26, 2007, at 4:57 PM, Ty Heath wrote:

> Java provides a mechanism for getting the home directory with
> 'System.getProperty("user.home");', which it appears you've
> discovered.
>
> There is also a cool class called java.util.prefs.Preferences. Its
> basically like a system independent registry that you can store
> anything you want in. I would recommend using that for storing
> things like GUIDs or whatever small variables you want to store on
> a users system, without worrying about where they will go. It has
> robust support for default values and other features. You can also
> write any data type to it (ints, byte array, strings,floats, bools
> etc).
>
> Ty
>
> On Mar 26, 2007, at 4:29 PM, Stefan Kaczmarek wrote:
>
>> Okay, just to confirm, we're going to store the files for a user
>> in their user.home folder, right?
>>
>> That would be Users/thezonie for OS X, Documents and Settings/
>> thezonie in Windows XP, etc.
>>
>> I guess make a "PushNET" subdir in that folder then?
>>
>> - Z
>>
>> On Mar 26, 2007, at 12:53 PM, Dylan Douglas wrote:
>>
>>> Z-
>>>
>>> Just got the thumbnail stuff to work correctly. Right now there
>>> are 5
>>> hashes in the database:
>>>
>>> 456789ABCDEF0123456789ABCDEF01234567890A
>>> 23456789ABCDEF0123456789ABCDEF0123456789
>>> 123456789ABCDEF0123456789ABCDEF012345678
>>> 3456789ABCDEF0123456789ABCDEF01234567890
>>> 0123456789ABCDEF0123456789ABCDEF01234567
>>>
>>> that will return images. So, basically, if you do the query:
>>> http://66.180.205.75/thumbnail.php?
>>> hash=23456789ABCDEF0123456789ABCDEF01
>>> 23456789 you get a cute little thumbnail in 130x97 format. The
>>> "0000000000000000000000000000000000000000" hash is the "hash not
>>> found"
>>> image (which would then trigger Ivan's stuff to try to create a
>>> thumbnail for it).
>>>
>>> -D
>>>
>>>> -----Original Message-----
>>>> From: Stefan Kaczmarek [mailto:stefan_at_thezonie.org]
>>>> Sent: Monday, March 26, 2007 6:39 AM
>>>> To: Dylan Douglas
>>>> Cc: Ben Ebert; Ivan Kwok; Jay Mairs; Ty Heath
>>>> Subject: Re: pushnet thumbnails
>>>>
>>>> Well, according to the Nutter layout, the thumbnails are 130x97.
>>>>
>>>> So ... Yeah.
>>>>
>>>> On Mar 20, 2007, at 3:12 PM, Dylan Douglas wrote:
>>>>
>>>>> All-
>>>>>
>>>>> How are we handling the thumbnails:
>>>>>
>>>>> * Are we keeping the original size?
>>>>> * Are we generating a uniform smaller size on the fly using php or
>>>>> before hand?
>>>>> * Are we keeping the data for these in the database or just a url
>>>>> to the thumbnail in the database?
>>>>> * What image format?
>>>>>
>>>>> Right now I have the stub returning a url to a 150x150 jpg that's
>>>>> on the
>>>>> database/web service computer.
>>>>>
>>>>> -D
>>>>> <winmail.dat>
>>>>
>>>>
>>
>
Received on Fri Sep 14 2007 - 10:56:08 BST

This archive was generated by hypermail 2.2.0 : Sun Sep 16 2007 - 22:19:48 BST