RE: pushnet thumbnails

From: Dylan Douglas <dylan_at_mediadefender.com>
Date: Mon, 2 Apr 2007 17:57:56 -0700
RE: pushnet thumbnails
Just finished getting the thumbnail.php to add entries to the thumbnail_creation table when it fails to get a thumbnail.  The table should start populating itself as Stefan or anyone else loads the webpage.
 
----------
Dylan Douglas
MediaDefender


From: Ivan Kwok
Sent: Thu 3/29/2007 12:52 PM
To: Dylan Douglas
Cc: Stefan Kaczmarek; Ty Heath; Ben Ebert; Jay Mairs
Subject: RE: pushnet thumbnails

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@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@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:03 BST

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