Thread: ...
Bcc: Subject: Status: Organizing the OSCON presence Reply-To: This is where I think we are so far with regards to OSCON2004. If I've got something wrong or too vague, please contact me. We need more speakers as opposed to tutorial presenters. We need verification on a few of the tutorial subjects and lengths. There are a few subject overlaps and I'm trying to get more details and let the various people work out the overlaps. I will provide updates to this list as new information becomes available. --elein =================================== This information is also on my wiki: http://cookie.varlena.com/BlueSky/OsCon2004 htaccess: (varlena/varlena) wiki user: (varlena) =================================== OSCON 2004 Contacts * PostgreSQL: Elein, Josh Berkus * OReilly Contact: chromatic Off site get together * Joshua Drake @ Command Prompt Swag * T-Shirts For Pg Conference goers: Greg Sabino Mullane * Other Swag TBD Financing Speakers * Josh Berkus -- Might be some money available Booth * Josh Berkus -- possibly money for this * Elein -- scheduling General Speaker * Set up: Josh/Elein * State of PostgreSQL -- Bruce Momjian: Adoptions and Trends BOF * Schedule -- elein Tutorials * Joe Conway -- (?? day) Extending PostgreSQL with C? * Andrew Sullivan -- (1/2 day?) Erserver Replication * Elein -- TBD * Gavin Roy -- (1/2 day) Intro to PostgreSQL * Robert Bernier -- (1/2 day) Datamining email/Perl (and PostgreSQL??) * Greg Sabino Mullane -- (1/2 day) how to use the database to help your DBA and application writers get along with otherby good use of "advanced" database features * George Essig -- (1/2?? day) tsearch2 * Gavin Sherry -- (1/2 day??) Advanced Features and 7.4 Enhancements * Josh Berkus -- (1/2 day??) Php and PostgreSQL Talks * Joe Conway -- 7.4 enhancements Conflict with Gavin Sherry ? * Elein -- ORDBMS Concepts in PostgreSQL * We need more speakers for talks! Topics Looking for Speakers * PostgreSQL on Windows * PostgreSQL Setup/Administration * Performance/Optimization * PostGIS * Datawarehousing * Server Side Programming languages: plpgsql, plpythonu, plperl, pltcl, plphp
On Wed, Jan 21, 2004 at 03:05:31PM -0800, elein wrote: > * PostgreSQL Setup/Administration > * Performance/Optimization > * Datawarehousing I could talk about any of these if it would be helpful. This again depends on whether Jan is going -- I doubt very much that Afilias will send us both. A -- Andrew Sullivan | ajs@crankycanuck.ca It never occurred to them that, if everyone had to think outside the box, maybe it was the box that needed fixing. --Malcom Gladwell
I think it is important for you or Jan to do a replication tutorial. A talk (as opposed to a tutorial) on admin stuff would also be very pertinent since the feedback I am collecting indicates that people do not think that PostgreSQL is as easy to administer as it is. Can you let me know when you know for sure what tutorial and talks you are going to propose? It would be great if we could find a way for both you and Jan could come to oscon. elein On Wed, Jan 21, 2004 at 11:22:11PM -0500, Andrew Sullivan wrote: > On Wed, Jan 21, 2004 at 03:05:31PM -0800, elein wrote: > > * PostgreSQL Setup/Administration > > * Performance/Optimization > > * Datawarehousing > > I could talk about any of these if it would be helpful. This again > depends on whether Jan is going -- I doubt very much that Afilias > will send us both. > > A > > -- > Andrew Sullivan | ajs@crankycanuck.ca > It never occurred to them that, if everyone had to think outside the box, > maybe it was the box that needed fixing. > --Malcom Gladwell > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
On Thu, Jan 22, 2004 at 09:59:44AM -0800, elein wrote: > I think it is important for you or Jan to do > a replication tutorial. I'm not sure that Jan can do a tutorial on the actual replication system -- he's never had to administer it (fortunately for him), just fix some bugs in it (unfortunately for him). I think if he does a talk on this, it'll have to be on his currently-in-progress system instead. (I do think, however, that people at OSCON are way more likely to want to talk to Jan than to talk to me. I'm a miserably bad programmer, so I'm not really in a position to talk about what we're doing next except in the broadest terms.) > A talk (as opposed to a tutorial) on > admin stuff would also be very pertinent > since the feedback I am collecting > indicates that people do not think > that PostgreSQL is as easy to administer > as it is. Yes; I was actually wondering what to talk about for 45 minutes. The wonder about Postgres is that it mostly runs itself when everything is going along nicely. > Can you let me know when you know for > sure what tutorial and talks you are > going to propose? I can propse both of these, then, if you like, assuming someone better isn't volunteering. (There are many better, I'm sure, and I'll happily step out of the way for others.) A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner
When is OSCON? If you can propose the replication one, I *might* be able to get Chris down to do the actual talk, since he has had experience on both sides ... depends on when it is ... On Thu, 22 Jan 2004, Andrew Sullivan wrote: > On Thu, Jan 22, 2004 at 09:59:44AM -0800, elein wrote: > > I think it is important for you or Jan to do > > a replication tutorial. > > I'm not sure that Jan can do a tutorial on the actual replication > system -- he's never had to administer it (fortunately for him), just > fix some bugs in it (unfortunately for him). I think if he does a > talk on this, it'll have to be on his currently-in-progress system > instead. (I do think, however, that people at OSCON are way more > likely to want to talk to Jan than to talk to me. I'm a miserably > bad programmer, so I'm not really in a position to talk about what > we're doing next except in the broadest terms.) > > > A talk (as opposed to a tutorial) on > > admin stuff would also be very pertinent > > since the feedback I am collecting > > indicates that people do not think > > that PostgreSQL is as easy to administer > > as it is. > > Yes; I was actually wondering what to talk about for 45 minutes. The > wonder about Postgres is that it mostly runs itself when everything > is going along nicely. > > > Can you let me know when you know for > > sure what tutorial and talks you are > > going to propose? > > I can propse both of these, then, if you like, assuming someone > better isn't volunteering. (There are many better, I'm sure, and > I'll happily step out of the way for others.) > > A > > -- > Andrew Sullivan | ajs@crankycanuck.ca > The plural of anecdote is not data. > --Roger Brinner > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Elein, > I'm not sure that Jan can do a tutorial on the actual replication > system -- (Jan, please correct me if any of the below is wrong) Jan's not going to do this; I had a talk with him on the phone. He doesn't want to do any presentations on Slony-I until he has a working version, which will probably not be before OSCON. And he doesn't want to commit to doing a presentation on ARC/BGWriter either. Right now, he's not committed to attending. Maybe we'll see him there, maybe not. -- -Josh Berkus Aglio Database Solutions San Francisco
It's a great convention, where mostly the geeks get together and get to know one another and learn. Put on by O'Reilly: http://conferences.oreillynet.com/os2004/ On Thu, 22 Jan 2004, Marc G. Fournier wrote: > > When is OSCON? If you can propose the replication one, I *might* be able > to get Chris down to do the actual talk, since he has had experience on > both sides ... depends on when it is ... > > > On Thu, 22 Jan 2004, Andrew Sullivan wrote: > > > On Thu, Jan 22, 2004 at 09:59:44AM -0800, elein wrote: > > > I think it is important for you or Jan to do > > > a replication tutorial. > > > > I'm not sure that Jan can do a tutorial on the actual replication > > system -- he's never had to administer it (fortunately for him), just > > fix some bugs in it (unfortunately for him). I think if he does a > > talk on this, it'll have to be on his currently-in-progress system > > instead. (I do think, however, that people at OSCON are way more > > likely to want to talk to Jan than to talk to me. I'm a miserably > > bad programmer, so I'm not really in a position to talk about what > > we're doing next except in the broadest terms.) > > > > > A talk (as opposed to a tutorial) on > > > admin stuff would also be very pertinent > > > since the feedback I am collecting > > > indicates that people do not think > > > that PostgreSQL is as easy to administer > > > as it is. > > > > Yes; I was actually wondering what to talk about for 45 minutes. The > > wonder about Postgres is that it mostly runs itself when everything > > is going along nicely. > > > > > Can you let me know when you know for > > > sure what tutorial and talks you are > > > going to propose? > > > > I can propse both of these, then, if you like, assuming someone > > better isn't volunteering. (There are many better, I'm sure, and > > I'll happily step out of the way for others.) > > > > A > > > > -- > > Andrew Sullivan | ajs@crankycanuck.ca > > The plural of anecdote is not data. > > --Roger Brinner > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >
Marc G. Fournier wrote: >When is OSCON? If you can propose the replication one, I *might* be able >to get Chris down to do the actual talk, since he has had experience on >both sides ... depends on when it is ... > > > > July 26-30
On Thu, Jan 22, 2004 at 02:49:28PM -0400, Marc G. Fournier wrote: > > When is OSCON? If you can propose the replication one, I *might* be able > to get Chris down to do the actual talk, since he has had experience on > both sides ... depends on when it is ... The OSCON rules are clear that the person making the proposal needs to be the person who actualy gives the talk. So If he's going to give it, he'll have to propose it. OSCON is 26-30 July. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland
On Thu, 22 Jan 2004, Andrew Sullivan wrote: > On Thu, Jan 22, 2004 at 02:49:28PM -0400, Marc G. Fournier wrote: > > > > When is OSCON? If you can propose the replication one, I *might* be able > > to get Chris down to do the actual talk, since he has had experience on > > both sides ... depends on when it is ... > > The OSCON rules are clear that the person making the proposal needs > to be the person who actualy gives the talk. So If he's going to > give it, he'll have to propose it. Damn, was afraid of that :( I may not know until after the deadline whether I can get him there or not :( ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Andrew Sullivan wrote: > On Thu, Jan 22, 2004 at 09:59:44AM -0800, elein wrote: >> I think it is important for you or Jan to do >> a replication tutorial. > > I'm not sure that Jan can do a tutorial on the actual replication > system -- he's never had to administer it (fortunately for him), just > fix some bugs in it (unfortunately for him). I think if he does a > talk on this, it'll have to be on his currently-in-progress system > instead. (I do think, however, that people at OSCON are way more > likely to want to talk to Jan than to talk to me. I'm a miserably > bad programmer, so I'm not really in a position to talk about what > we're doing next except in the broadest terms.) That's probably true. I'm just back from LinuxWorld and on that BOF the responses to an "extremely brief" intro to what's coming with Slony-I was several "two thumbs up". And there where quite some people who wanted to talk about some of the finer details after the BOF. As Andrew said, I can't say much about living with the stuff I want to replace anyway, so what I would have to talk about is what I'm actually developing. I hope to have something working by the time of the conference, but as of now I am in the early stages of implementing. I am next week in Toronto and will discuss the issue with Andrew and Janusz (the guy I'm reporting to and who in the end would have to nod). Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
Josh Berkus wrote: > Elein, > >> I'm not sure that Jan can do a tutorial on the actual replication >> system -- > > (Jan, please correct me if any of the below is wrong) > > Jan's not going to do this; I had a talk with him on the phone. He doesn't > want to do any presentations on Slony-I until he has a working version, which > will probably not be before OSCON. And he doesn't want to commit to doing > a presentation on ARC/BGWriter either. ARC/BGwriter would be a completely different topic. And on advanced algorithms like this, one can expect the audience to start snoring, evaporating or doing other unpleasant things after about 30 minutes or so. I can for sure "talk" about things like that for days, but the key is to have people who listen! Let's see what comes out of my Toronto trip, okay? Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
Hi all; I am considering doing a talk (not a tutorial) on how the advanced features of PostgreSQL allow for extremely powerful business databases. An abstract follows: Many application developers working with relational database systems are used to using the database as a simple data store. However PostgreSQL allows for far more sophisticated "active," or self-managing databases to be developed. Many business applications can benefit from using an active database. This paper explored how views, rules, triggers, and functions can be used in order to create an active database. The Open Reservation Management System database (http://sourceforge.net/projects/openres, not yet stable) will be used as an example, as will the HERMES CRM database system (http://hermesweb.sourceforge.net). Best Wishes, Chris Travers ----- Original Message ----- From: "Andrew Sullivan" <ajs@crankycanuck.ca> To: <pgsql-advocacy@postgresql.org> Cc: <ajs@crankycanuck.ca>; <janwieck@yahoo.com> Sent: Friday, January 23, 2004 1:43 AM Subject: Re: [pgsql-advocacy] Status: OSCON organization > On Thu, Jan 22, 2004 at 09:59:44AM -0800, elein wrote: > > I think it is important for you or Jan to do > > a replication tutorial. > > I'm not sure that Jan can do a tutorial on the actual replication > system -- he's never had to administer it (fortunately for him), just > fix some bugs in it (unfortunately for him). I think if he does a > talk on this, it'll have to be on his currently-in-progress system > instead. (I do think, however, that people at OSCON are way more > likely to want to talk to Jan than to talk to me. I'm a miserably > bad programmer, so I'm not really in a position to talk about what > we're doing next except in the broadest terms.) > > > A talk (as opposed to a tutorial) on > > admin stuff would also be very pertinent > > since the feedback I am collecting > > indicates that people do not think > > that PostgreSQL is as easy to administer > > as it is. > > Yes; I was actually wondering what to talk about for 45 minutes. The > wonder about Postgres is that it mostly runs itself when everything > is going along nicely. > > > Can you let me know when you know for > > sure what tutorial and talks you are > > going to propose? > > I can propse both of these, then, if you like, assuming someone > better isn't volunteering. (There are many better, I'm sure, and > I'll happily step out of the way for others.) > > A > > -- > Andrew Sullivan | ajs@crankycanuck.ca > The plural of anecdote is not data. > --Roger Brinner > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > >
Sounds interesting.. you might also want to look at the gforge project which uses a lot of those types of features. I was thinking of doing something similar (though probably a tutorial) on using views and pllangs to save your self from excessive recoding of client applications. I planned to base it on some real life examples but not any one specific apps. Incidentally, I don't think it hurts to have multiple people doing submissions on similar topics, since theres no guarantee that any particular talk/tutorial will actually get picked. Robert Treat On Fri, 2004-01-23 at 06:04, Chris Travers wrote: > Hi all; > > I am considering doing a talk (not a tutorial) on how the advanced features > of PostgreSQL allow for extremely powerful business databases. An abstract > follows: > Many application developers working with relational database systems are > used to using the database as a simple data store. However PostgreSQL allows > for far more sophisticated "active," or self-managing databases to be > developed. Many business applications can benefit from using an active > database. This paper explored how views, rules, triggers, and functions can > be used in order to create an active database. The Open Reservation > Management System database (http://sourceforge.net/projects/openres, not yet > stable) will be used as an example, as will the HERMES CRM database system > (http://hermesweb.sourceforge.net). > > Best Wishes, > Chris Travers > ----- Original Message ----- > From: "Andrew Sullivan" <ajs@crankycanuck.ca> > To: <pgsql-advocacy@postgresql.org> > Cc: <ajs@crankycanuck.ca>; <janwieck@yahoo.com> > Sent: Friday, January 23, 2004 1:43 AM > Subject: Re: [pgsql-advocacy] Status: OSCON organization > > > > On Thu, Jan 22, 2004 at 09:59:44AM -0800, elein wrote: > > > I think it is important for you or Jan to do > > > a replication tutorial. > > > > I'm not sure that Jan can do a tutorial on the actual replication > > system -- he's never had to administer it (fortunately for him), just > > fix some bugs in it (unfortunately for him). I think if he does a > > talk on this, it'll have to be on his currently-in-progress system > > instead. (I do think, however, that people at OSCON are way more > > likely to want to talk to Jan than to talk to me. I'm a miserably > > bad programmer, so I'm not really in a position to talk about what > > we're doing next except in the broadest terms.) > > > > > A talk (as opposed to a tutorial) on > > > admin stuff would also be very pertinent > > > since the feedback I am collecting > > > indicates that people do not think > > > that PostgreSQL is as easy to administer > > > as it is. > > > > Yes; I was actually wondering what to talk about for 45 minutes. The > > wonder about Postgres is that it mostly runs itself when everything > > is going along nicely. > > > > > Can you let me know when you know for > > > sure what tutorial and talks you are > > > going to propose? > > > > I can propse both of these, then, if you like, assuming someone > > better isn't volunteering. (There are many better, I'm sure, and > > I'll happily step out of the way for others.) > > > > A > > > > -- > > Andrew Sullivan | ajs@crankycanuck.ca > > The plural of anecdote is not data. > > --Roger Brinner > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Your point is well taken. But it is important to have some semblance of coordination--it will look good if we all are on the same page giving the same messages. elein On Fri, Jan 23, 2004 at 09:42:08AM -0500, Robert Treat wrote: > Sounds interesting.. you might also want to look at the gforge project > which uses a lot of those types of features. I was thinking of doing > something similar (though probably a tutorial) on using views and > pllangs to save your self from excessive recoding of client > applications. I planned to base it on some real life examples but not > any one specific apps. > > Incidentally, I don't think it hurts to have multiple people doing > submissions on similar topics, since theres no guarantee that any > particular talk/tutorial will actually get picked. > > Robert Treat > > On Fri, 2004-01-23 at 06:04, Chris Travers wrote: > > Hi all; > > > > I am considering doing a talk (not a tutorial) on how the advanced features > > of PostgreSQL allow for extremely powerful business databases. An abstract > > follows: > > Many application developers working with relational database systems are > > used to using the database as a simple data store. However PostgreSQL allows > > for far more sophisticated "active," or self-managing databases to be > > developed. Many business applications can benefit from using an active > > database. This paper explored how views, rules, triggers, and functions can > > be used in order to create an active database. The Open Reservation > > Management System database (http://sourceforge.net/projects/openres, not yet > > stable) will be used as an example, as will the HERMES CRM database system > > (http://hermesweb.sourceforge.net). > > > > Best Wishes, > > Chris Travers > > ----- Original Message ----- > > From: "Andrew Sullivan" <ajs@crankycanuck.ca> > > To: <pgsql-advocacy@postgresql.org> > > Cc: <ajs@crankycanuck.ca>; <janwieck@yahoo.com> > > Sent: Friday, January 23, 2004 1:43 AM > > Subject: Re: [pgsql-advocacy] Status: OSCON organization > > > > > > > On Thu, Jan 22, 2004 at 09:59:44AM -0800, elein wrote: > > > > I think it is important for you or Jan to do > > > > a replication tutorial. > > > > > > I'm not sure that Jan can do a tutorial on the actual replication > > > system -- he's never had to administer it (fortunately for him), just > > > fix some bugs in it (unfortunately for him). I think if he does a > > > talk on this, it'll have to be on his currently-in-progress system > > > instead. (I do think, however, that people at OSCON are way more > > > likely to want to talk to Jan than to talk to me. I'm a miserably > > > bad programmer, so I'm not really in a position to talk about what > > > we're doing next except in the broadest terms.) > > > > > > > A talk (as opposed to a tutorial) on > > > > admin stuff would also be very pertinent > > > > since the feedback I am collecting > > > > indicates that people do not think > > > > that PostgreSQL is as easy to administer > > > > as it is. > > > > > > Yes; I was actually wondering what to talk about for 45 minutes. The > > > wonder about Postgres is that it mostly runs itself when everything > > > is going along nicely. > > > > > > > Can you let me know when you know for > > > > sure what tutorial and talks you are > > > > going to propose? > > > > > > I can propse both of these, then, if you like, assuming someone > > > better isn't volunteering. (There are many better, I'm sure, and > > > I'll happily step out of the way for others.) > > > > > > A > > > > > > -- > > > Andrew Sullivan | ajs@crankycanuck.ca > > > The plural of anecdote is not data. > > > --Roger Brinner > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 3: if posting/reading through Usenet, please send an appropriate > > > subscribe-nomail command to majordomo@postgresql.org so that your > > > message can get through to the mailing list cleanly > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings > > -- > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
Tutorials and talks on the same subjects are also good for another reason: Tutorials focus on the actual techniques and how to use the features, while talks can more easily focus on high-level strategy regarding solving a problem. For me it is not an either-or proposition, but rather it is ideal situation is to have both talks and tutorials on similar topics, but coordinate with eachother. My approach was to use two very different systems and show how various problems can be solved using these approaches. HERMES assumes that all information is live and also transactional, while the Open Reservation Management System assumes that information needs to be archived and reconstructed for specific dates for analytical operations (i.e. what was the vacancy rate for January 12, 2003 for all rooms with double beds). Best Wishes, Chris Travers