Обсуждение: Video available for PGDay SJC '09
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
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
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/
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
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
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
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).
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
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
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
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
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.
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.
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
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
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