Re: [GENERAL] Video available for PGDay SJC '09

2009-07-29 Thread Andreas Wenk

David Fetter schrieb:
Just a quick question. Wouldn't it be better to provide the videos in flv 
format in a player in this page. Since I have a MAC, I have no problems 
viewing the videos. But with my Linux box and FF 3.5 I can't.


You can use xine on your Linux box :)

Cheers,
David.


David, thanks for the tip ;-)

CHeers

Andy

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Andreas Wenk

Christophe Pettus schrieb:

Greetings,

The video recordings of the sessions for PG Day SJC '09 are now available:


[snip]

Many thanks to Steve Crawford for the audio system and assistance with 
setup, tear-down, and coordination during the event.


--
-- Christophe Pettus
 x...@thebuild.com


Hi Christophe,

thanks - that's awesome!

Just a quick question. Wouldn't it be better to provide the videos in flv format in a 
player in this page. Since I have a MAC, I have no problems viewing the videos. But with 
my Linux box and FF 3.5 I can't.


I can imagine that some people have problems with .mov files and (more importantly), mov 
files are really big - so a lot of traffic is going over the wire.


I could assist creating a page with a player (OS stuff) and converting the files to flv if 
this is a desired way to provide the videos.


Cheers

Andy

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Bill Moran
In response to Andreas Wenk a.w...@netzmeister-st-pauli.de:

 Christophe Pettus schrieb:
  Greetings,
  
  The video recordings of the sessions for PG Day SJC '09 are now available:
 
 [snip]
 
 Just a quick question. Wouldn't it be better to provide the videos in flv 
 format in a 
 player in this page. Since I have a MAC, I have no problems viewing the 
 videos. But with 
 my Linux box and FF 3.5 I can't.

While I've no objection to someone helping out by converting files, I
find it odd that flv is suggested.  I've yet to find anything that can
play flv files on my FreeBSD desktop machine.  I'm pretty sure mplayer
can play mov files ... I guess I'll find out this evening when I take
time to watch them.

In any event, thanks for making the caps.  I'm looking forward to watching
them.

-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Andreas Wenk

Bill Moran schrieb:
  While I've no objection to someone helping out by converting files, I

find it odd that flv is suggested.  I've yet to find anything that can
play flv files on my FreeBSD desktop machine.  I'm pretty sure mplayer
can play mov files ... I guess I'll find out this evening when I take
time to watch them.


You will not need to watch them on your desktop. If your browser supports flash, then you 
simply watch them with your browser. I think flash (flv, swf) is more supported by the 
browser than mov - as long as you don't download the videos. For sure mplayer can play 
them. But why download them at all? ;-)


Cheers

Andy

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Greg Stark
On Tue, Jul 28, 2009 at 1:41 PM, Andreas
Wenka.w...@netzmeister-st-pauli.de wrote:
 Bill Moran schrieb:
   While I've no objection to someone helping out by converting files, I

 find it odd that flv is suggested.  I've yet to find anything that can
 play flv files on my FreeBSD desktop machine.  I'm pretty sure mplayer
 can play mov files ... I guess I'll find out this evening when I take
 time to watch them.

 You will not need to watch them on your desktop. If your browser supports
 flash, then you simply watch them with your browser. I think flash (flv,
 swf) is more supported by the browser than mov - as long as you don't
 download the videos. For sure mplayer can play them. But why download them
 at all? ;-)

Why not use a standardized openly documented container format like
mpeg4 with mpeg4 part 2 compression instead of one controlled by a
single company like flv or quicktime? That would let people play it
using any of various open source codecs which can play mpeg4 part 2.

-- 
greg
http://mit.edu/~gsstark/resume.pdf

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Andreas Wenk

Greg Stark schrieb:

On Tue, Jul 28, 2009 at 1:41 PM, Andreas
Wenka.w...@netzmeister-st-pauli.de wrote:
Why not use a standardized openly documented container format like
mpeg4 with mpeg4 part 2 compression instead of one controlled by a
single company like flv or quicktime? That would let people play it
using any of various open source codecs which can play mpeg4 part 2.


another good approach. I understand the point of view. But this menas to download the 
files anyway because playing mpeg files in the browser is the same as with mov files - I 
think.


All in all my suggestion to convert the videos to flv and let people see the videos in a 
flash player was based on the assumption, that


- the files are really smaller so less traffic
- flash video is the most supported format for watching *in the browser*
- it's easy to convert the existing videos to flv
- no need to download the videos

But now I see that there are different opinions if this approach is a good idea. Im a 
still confident, that it's not evil to use the format which is best known for the 
mainstream ... and maybe this point is what I have to see in a different light. Maybe the 
group of people watching the videos are not mainstream ;-)


Cheers

Andy


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Christophe Pettus


On Jul 28, 2009, at 7:17 AM, Andreas Wenk wrote:
another good approach. I understand the point of view. But this  
menas to download the files anyway because playing mpeg files in the  
browser is the same as with mov files - I think.


Historically, MOV has been the least-bad container format; Flash  
support on anything besides Windows has, traditionally, been very  
spotty.  The files themselves are pretty much the same size; FLV is  
(as noted) a container format, not a codec, and the video is H.264  
either way.


And, of course, you do have to download the video either way; it just  
starts playing faster if you are using a Flash viewer.  Requiring a  
download first does have the advantage that it keeps the bandwidth off  
of media.postgresql.org down, since the video only has to be  
downloaded to your desktop once, rather than each time you watch it.   
(I'm not sure how much of a real issue this is, however.)


The right answer is to move to using the video tag, now that more  
browsers are supporting it.  For the next event, I'll encourage  
providing a video-based viewer (since I don't control the HTML on  
postgresql.org, I can't make any grand promises).


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Andreas Wenk

Christophe Pettus schrieb:


Historically, MOV has been the least-bad container format; Flash support 
on anything besides Windows has, traditionally, been very spotty.  The 
files themselves are pretty much the same size; FLV is (as noted) a 
container format, not a codec, and the video is H.264 either way.


I never assumed that flv is a codec ... the size for sure depends on the quality (and 
resolution). So if you want to have the same high quality as having with mov, then I 
believe it's the same size. But that's not the intention of using flv.


And, of course, you do have to download the video either way; it just 
starts playing faster if you are using a Flash viewer.  Requiring a 
download first does have the advantage that it keeps the bandwidth off 
of media.postgresql.org down, since the video only has to be downloaded 
to your desktop once, rather than each time you watch it.  (I'm not sure 
how much of a real issue this is, however.)


agreed. This is the fact, if the video will have the same size in flv also. Then there is 
concerning the bandwith no difference ... but I would definitely size it down in data 
size. But hey - this is just the way I would do it. I am not saying that having mov files 
a bad thing. Really not! ;-)


The right answer is to move to using the video tag, now that more 
browsers are supporting it.  For the next event, I'll encourage 
providing a video-based viewer (since I don't control the HTML on 
postgresql.org, I can't make any grand promises).


uh - HTML 5 is supported by the browser when? Firefox 3.5 does - yeah. But this would be 
no option for me in the next two years or so ... believe it or not - there are still s 
many people using IE6 (what brings a lot of headaches to me for layout and javascript 
coding by the way!)


My recapitulation of this discussion is to leave it like it is because it's best suitable 
in more concerns for most of the people. In the future it is the best idea to use the HTML 
5 video/video tags. Sounds good to me ;-)


Thanks for taking the time to discuss that with me.

Cheers

Andy

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Christophe Pettus


On Jul 28, 2009, at 8:35 AM, Andreas Wenk wrote:

uh - HTML 5 is supported by the browser when?


Currently, the video tag is supported by Firefox 3.5, Safari 3 and  
4, Chrome 3 (in alpha, I believe), iPhone 3.


That being said, we can do a fallback to Quicktime, then to a Flash  
client, all the way back to IE6.  A nice example of fallback code is  
available at:


http://camendesign.com/code/video_for_everybody

Now, Joshua Drake has often uploaded these videos to Vimeo, thus  
giving everyone an in-browser channel as well.


Thanks!
--
-- Christophe Pettus
   x...@thebuild.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Andreas Wenk

Christophe Pettus schrieb:


On Jul 28, 2009, at 8:35 AM, Andreas Wenk wrote:

uh - HTML 5 is supported by the browser when?


Currently, the video tag is supported by Firefox 3.5, Safari 3 and 4, 
Chrome 3 (in alpha, I believe), iPhone 3.


That being said, we can do a fallback to Quicktime, then to a Flash 
client, all the way back to IE6.  A nice example of fallback code is 
available at:


http://camendesign.com/code/video_for_everybody


thanks for the link! I wil check it out asap.


Now, Joshua Drake has often uploaded these videos to Vimeo, thus giving 
everyone an in-browser channel as well.


The fallback idea sounds great ;-) If you need help at any time just get in 
touch with me ...

Cheers

Andy


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Greg Stark
On Tue, Jul 28, 2009 at 3:38 PM, Christophe Pettusx...@thebuild.com wrote:

 Historically, MOV has been the least-bad container format; Flash support on
 anything besides Windows has, traditionally, been very spotty.  The files
 themselves are pretty much the same size; FLV is (as noted) a container
 format, not a codec, and the video is H.264 either way.

(fwiw H.264 isn't a codec either... it's a compression format which
can be generated by various codecs)

I think I'm scarred from Quicktime files because they often were
encoded with codecs like Sorensen which produced proprietary formats.

What does IE or firefox  3.5 really do if you just link to an mpeg
file? Doesn't it run whatever app is set to handle that format? Why is
a flash plugin based page better than that? I have a feeling I'm just
being iconoclastic for the sake of it here.

In reality I would be pretty happy with any page that had a link at
the bottom to download an mpeg format file with H.264 data in it that
mplayer can play.

-- 
greg
http://mit.edu/~gsstark/resume.pdf

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Christophe Pettus


On Jul 28, 2009, at 3:55 PM, Greg Stark wrote:

In reality I would be pretty happy with any page that had a link at
the bottom to download an mpeg format file with H.264 data in it that
mplayer can play.


Well, mplayer claims it can play MOV, and the files are H.264, so  
assuming the mplayer docs aren't lying, you're all set.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread John R Pierce

Greg Stark wrote:

I think I'm scarred from Quicktime files because they often were
encoded with codecs like Sorensen which produced proprietary formats.

  


agreed, and the quicktime installer dragging in itunes if you don't 
remember to uncheck all the right boxes, and quicktime nagging you to 
upgrade to quicktime pro, and the quicktime on windows player having no 
way to easily play full screen, and quicktime 'stealing' every video 
container format on your system unless you carefully dig through its 
configurations



What does IE or firefox  3.5 really do if you just link to an mpeg
file? Doesn't it run whatever app is set to handle that format? Why is
a flash plugin based page better than that? I have a feeling I'm just
being iconoclastic for the sake of it here.
  


it typically doesn't stream.  it downloads the whole file, then launches 
it.flash plays the video embedded in the page in a standardized way, 
and streams it.




but, we're getting -way- off topic here.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread Greg Stark
On Wed, Jul 29, 2009 at 12:10 AM, John R Piercepie...@hogranch.com wrote:
 Greg Stark wrote:

 I think I'm scarred from Quicktime files because they often were
 encoded with codecs like Sorensen which produced proprietary formats.



 agreed, and the quicktime installer dragging in itunes if you don't remember
 to uncheck all the right boxes, and quicktime nagging you to upgrade to
 quicktime pro, and the quicktime on windows player having no way to easily
 play full screen, and quicktime 'stealing' every video container format on
 your system unless you carefully dig through its configurations


Well I was talking about the file format, not the player software.

-- 
greg
http://mit.edu/~gsstark/resume.pdf

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Video available for PGDay SJC '09

2009-07-28 Thread David Fetter
On Tue, Jul 28, 2009 at 11:34:24AM +0200, Andreas Wenk wrote:
 Christophe Pettus schrieb:
 Greetings,

 The video recordings of the sessions for PG Day SJC '09 are now available:

 [snip]

 Many thanks to Steve Crawford for the audio system and assistance with  
 setup, tear-down, and coordination during the event.

 -- 
 -- Christophe Pettus
  x...@thebuild.com

 Hi Christophe,

 thanks - that's awesome!

 Just a quick question. Wouldn't it be better to provide the videos in flv 
 format in a player in this page. Since I have a MAC, I have no problems 
 viewing the videos. But with my Linux box and FF 3.5 I can't.

You can use xine on your Linux box :)

Cheers,
David.
-- 
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter  XMPP: david.fet...@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Video available for PGDay SJC '09

2009-07-27 Thread Christophe Pettus

Greetings,

The video recordings of the sessions for PG Day SJC '09 are now  
available:


Version 8.4: Easier to Administer than Ever / Josh Berkus / PostgreSQL  
Experts

 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-easier.mov

Rapid Upgrades with pg_Migrator / Bruce Momjian / EnterpriseDB
 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-migrator.mov

Check Please! What Your Postgres Databases Wishes You Would Monitor /  
Robert Treat / OmniTI

 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-monitoring.mov

PostgreSQL Pitfalls / Jeff Davis / Truviso
 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-pitfalls.mov

What works with Postgres: The Open Geo Data Interoperabilty Overview /  
Brian Hamlin / OSGeo Foundation

 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-postgis.mov

Very Large Databases and PostgreSQL: Issues and Solutions / John  
Cieslewicz / Aster Data

 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-petabytes.mov

pgGearman: A distributed worker queue for PostgreSQL / Brian Aker,  
Eric Day / Gearman Project

 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-gearman.mov

Lightning Talks
 http://media.postgresql.org/pgday-sjc-09/pgday-sjc-09-lightning.mov


Many thanks to Steve Crawford for the audio system and assistance with  
setup, tear-down, and coordination during the event.


--
-- Christophe Pettus
 x...@thebuild.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general