Thread: Video available for PGDay SJC '09

Video available for PGDay SJC '09

From
Christophe Pettus
Date:
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
  xof@thebuild.com

Re: Video available for PGDay SJC '09

From
Andreas Wenk
Date:
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
>  xof@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

Re: Video available for PGDay SJC '09

From
Bill Moran
Date:
In response to Andreas Wenk <a.wenk@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/

Re: Video available for PGDay SJC '09

From
Andreas Wenk
Date:
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

Re: Video available for PGDay SJC '09

From
Greg Stark
Date:
On Tue, Jul 28, 2009 at 1:41 PM, Andreas
Wenk<a.wenk@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

Re: Video available for PGDay SJC '09

From
Andreas Wenk
Date:
Greg Stark schrieb:
> On Tue, Jul 28, 2009 at 1:41 PM, Andreas
> Wenk<a.wenk@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


Re: Video available for PGDay SJC '09

From
Christophe Pettus
Date:
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).

Re: Video available for PGDay SJC '09

From
Andreas Wenk
Date:
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 soooo
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

Re: Video available for PGDay SJC '09

From
Christophe Pettus
Date:
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
    xof@thebuild.com

Re: Video available for PGDay SJC '09

From
Andreas Wenk
Date:
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


Re: Video available for PGDay SJC '09

From
Greg Stark
Date:
On Tue, Jul 28, 2009 at 3:38 PM, Christophe Pettus<xof@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

Re: Video available for PGDay SJC '09

From
Christophe Pettus
Date:
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.

Re: Video available for PGDay SJC '09

From
John R Pierce
Date:
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.



Re: Video available for PGDay SJC '09

From
Greg Stark
Date:
On Wed, Jul 29, 2009 at 12:10 AM, John R Pierce<pierce@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

Re: Video available for PGDay SJC '09

From
David Fetter
Date:
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
>>  xof@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 <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

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

Re: Video available for PGDay SJC '09

From
Andreas Wenk
Date:
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