Joshua D. Drake (j...@commandprompt.com)

On Wed, 20 Aug 2008 13:04:52 -0500 (CDT)
Gene Selkov <selkovjr@observercentral.net> wrote:

> > Right, that is the constant issue with all the toolkits. My mind is
> > something that provides an introduction to Catalyst (which is good
> > for Catalyst) but also, "Why use Catalyst with PostgreSQL?". What
> > kind of cool features can Catalyst (and is associated libs) expose
> > that developers might be missing.
>
> The coolest feature in postgres is its extensibility. Tsearch2, which
> someone mentioned in an earlier post is based on a user-defined data
> type. I have done some work on the postgres GIST a decade ago, which
> enabled applications like Tseach2, among other things. There is no
> full-text search capability in the postgres engine, but it doesn't
> have to be implemented in the engine.

Well as a note, 8.3.x has Tsearch integrated. It is no longer user
defined. Your point about being user extensible is certainly true.

>
> So if you really want to highlight postgres's advantages, focus on
> its extended behaviors.
>

Agreed.

> But linking that to Catalyst will appear contrived, unless we can

I am not sure about that. The point of the talk would be, using these
features in Catalyst.

Here is an example. I was under (the false) assumption that Hibernate
can't use natural or composite keys. In fact, I thought that
Catalyst/DBIx was the only one that could.

I am going to bet that a lot of developers think that a integer based
key is required (which is really bad), when in fact it isn't. That
would be a perfect thing to show the capabilities of, including why you
would do such a thing.


> Alternatively, I could collaborate with someone to demonstrate the
> use of extended data types in postgres. I myself will not be able to
> attend any conferences outside UK for a year or so.

That was definitely some very cool items.

Joshua D. Drake

On Tue, 19 Aug 2008 16:14:43 -0700
"J. Shirley" <jshirley@gmail.com> wrote:

>
> I'm local, and definitely prefer Pg even though I find myself stuck
> with MySQL rather too frequently. I don't know if I can commit to a
> talk right now, but I can help out getting you a speaker if I can't do
> it myself.

Thanks!

>
> However, one of the problems you may find from the Catalyst side of
> things is that we tend to forget the particulars of various databases
> because DBIx::Class, SQL::Abstract and SQL::Translator take a lot of
> the pain from being cross-database compatible out of the mix.

Right, that is the constant issue with all the toolkits. My mind is
something that provides an introduction to Catalyst (which is good for
Catalyst) but also, "Why use Catalyst with PostgreSQL?". What kind of
cool features can Catalyst (and is associated libs) expose that
developers might be missing.

>
> Happy to give a talk on painless scaffolding using some various CRUD
> and DBIx::Class stuff, that works very well with PostgreSQL (my
> current fascination is REST-based stuff, and am quite fond of
> Catalyst::Controller::DBIC::API)

That would be very cool!

>
> Anybody else have any thoughts?
>

Sincerely,

Joshua D. Drake

Hello,

There is a PostgreSQL Community Conference happening in Portland,
Oregon in a couple of months. It would be great if we could get a
Catalyst developer who preferred PostgreSQL to give a talk... Here is
the announcement of the call for talks:

The second annual PostgreSQL Conference: West is being held on October
10th through October 12th 2008 in the The Native American Student &
Community Center at Portland State University.

We are currently accepting papers and you can submit your talks here:

http://www.postgresqlconference.org/west08/talk_submission/

We have already seen submissions on Tsearch2 as well as pgTap. Do you
have something you would like to share about PostgreSQL? Now is the
time!

This year West will be providing its proceeds to the Postgresql.us.

Sincerely,

Joshua D. Drake

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Online registration ends for PostgreSQL Conference East on March 26th
at 5:00pm PST. PostgreSQL Conference: East is being held at the
Univerisity of Maryland, College Park in the CSIC building.

The conference series is designed to be a geographically strategic
series of conferences that allow contributors, current users and future
users/developers to learn and network.

Each conference is held in an Academic facility, students and educators
are free. Our goal is to establish a series of forums for local
developers, administrators and users to mingle with leading PostgreSQL
contributors. Initially these forums and conferences will be held in
the U.S. but we are also working with our European counterparts.  

For more information on the conference or to register visit:

http://www.postgresqlconference.org/

All registrations and sponsorships are donations to PostgreSQL via
Software in the Public Interest, Inc., a 501(c)3 non-profit
corporation.  


Sincerely,

Joshua D. Drake

- --  
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Online registration ends for PostgreSQL Conference East on March 26th
at 5:00pm PST. PostgreSQL Conference: East is being held at the
Univerisity of Maryland, College Park in the CSIC building.

The conference series is designed to be a geographically strategic
series of conferences that allow contributors, current users and future
users/developers to learn and network.

Each conference is held in an Academic facility, students and educators
are free. Our goal is to establish a series of forums for local
developers, administrators and users to mingle with leading PostgreSQL
contributors. Initially these forums and conferences will be held in
the U.S. but we are also working with our European counterparts.

For more information on the conference or to register visit:

http://www.postgresqlconference.org/

All registrations and sponsorships are donations to PostgreSQL via
Software in the Public Interest, Inc., a 501(c)3 non-profit
corporation.


Sincerely,

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate