[Pljava-dev] pljava talk at javaone

Josh Berkus wants to know if anyone is willing to give a talk about
pl/java at JavaOne. Sun would be willing to cover the airfare costs, but
the submission deadline is tomorrow, 11/16. While it's a shot in the
dark, it can't hurt to ask...

Kris Jurka

I just wish I had the time. It would have been great fun. If anyone else
wants to step up, I'd be glad to provide input.

- thomas

Kris Jurka wrote:
> Josh Berkus wants to know if anyone is willing to give a talk about
> pl/java at JavaOne. Sun would be willing to cover the airfare costs, but
> the submission deadline is tomorrow, 11/16. While it's a shot in the
> dark, it can't hurt to ask...
>
> Kris Jurka
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>

> Kris Jurka wrote:
> > Josh Berkus wants to know if anyone is willing to give a talk about
> > pl/java at JavaOne. Sun would be willing to cover the airfare costs, but
> > the submission deadline is tomorrow, 11/16. While it's a shot in the
> > dark, it can't hurt to ask...

On Nov 15, 2007 6:48 PM, Thomas Hallgren <thomas at tada.se> wrote:
> I just wish I had the time. It would have been great fun. If anyone else
> wants to step up, I'd be glad to provide input.

I'm willing, but only questionably qualified. :)

I've been playing with pl/java a bit, and have a list of things that
I'd like to do to it to either add features or make it easier to use,
but due to some lack of time recently, I haven't been able to do as
much as I would have liked.

If there's interest, I'll post my wishlist. Maybe if there's some
interest in my ideas, I could do a talk on a) implementing some of
them, and b) "future directions for pl/java" :)

Having said all that, I probably only fall under "enthusiastic
amateur" rather than "zen guru" as far as pl/java goes. I do have both
extensive java (day job) and some pgsql backend hacking (enums)
experience. So I dunno if I'm qualified to give a talk on pl/java (at
least not today, maybe in May though). It would seem a waste of a good
opportunity to get the word out about both postgresql and pl/java to
the java crowd though, so perhaps a partially qualified candidate
would be better than no talk at all.

Anyway, if no-one who has hacked on it longer than I have been puts
their hand up, I'd love to do it, as long as Josh, as the sponsor, is
willing. :)

Cheers

Tom

On Nov 15, 2007 11:24 PM, Josh Berkus <josh at agliodbs.com> wrote:
> Tom,
>
> > Anyway, if no-one who has hacked on it longer than I have been puts
> > their hand up, I'd love to do it, as long as Josh, as the sponsor, is
> > willing. :)
>
> Sure ... any public speaking experience?

Does high school debating or running political meetings count? :) Not
much really on technical topics (although my team at work might
disagree), but I'm honestly not a bad speaker. After that it's just a
matter of knowing the material. *shrug*

I'm not suicidal: I wouldn't volunteer if I didn't think I'd do a
decent job. Having seen video casts of some of the presentations from
previous years, though, I couldn't be worse than one or two of them
:).

How long a talk would it have to be? Would a running demo of pl/java
on the screen be appropriate? Or are we talking
powerpoint-cognitive-style? :) I can talk to powerpoint, but a demo is
so much cooler, for an audience.

Cheers

Tom

Tom Dunstan wrote:
> How long a talk would it have to be? Would a running demo of pl/java
> on the screen be appropriate? Or are we talking
> powerpoint-cognitive-style? :) I can talk to powerpoint, but a demo is
> so much cooler, for an audience.
>
I think it would be great if you could combine. First some slides where you go over what PL/Java
really is and then round up with a demo.

Regards,
Thomas Hallgren

On Nov 16, 2007 9:12 AM, Thomas Hallgren <thomas at tada.se> wrote:
> I think it would be great if you could combine. First some slides where you go over what PL/Java
> really is and then round up with a demo.

Sorry, I forwarded my kinda rushed abstract / outline through to Josh,
but didn't CC the list. Here it is... anything missing / obviously
stupid?

Thanks

Tom

Title: Knee Deep in the Data: Using PL/Java to Write Custom Functions
for PostgreSQL.

Abstract:
PL/Java is a PostgreSQL procedural language that allows developers to
write functions and triggers for the PostgreSQL open source database
using Java. This allows Java developers to get deeper into the
development stack, without having to leave Java's second-to-none
toolset and huge set of available libraries.

The talk will describe the overall design of PL/Java and under what
circumstances it is a useful tool for Java developers. A demo of how
to use PL/Java to write database functions and triggers will follow,
including a demonstration of using a IDE debugger to step through a
function mid-transaction.

Prerequisite knowledge: general use of SQL and JDBC. Demo may include
use of JPA.

Summary / Outline:

- What's the problem?
- Performance
- Access to libraries

- Introducing PostgreSQL
- Open Source, with support from Sun, Red Hat et al
- Highly flexible
- Other PL's

- PL/Java
- Brief history
- Design - embedded JVM rather than separate process

- Example problem
- Explain why standard JDBC/JPA less than ideal
- If only we could do this...

- Demonstration
- Write database function in IDE
- Show deployment steps
- Drive from JDBC/JPA application

- Another example: a trigger
- Data validation / correction using 3rd party library (e.g. HTML Tidy)
- Show how to write and deploy trigger

- Why not use other, more established PostgreSQL PL's?
- Java devs familiar with Java
- Other imperative PL's can't do this:

- Debugging
- Attach IDE debugger to PostgreSQL backed process
- Set breakpoints, poke around data etc

- Embedded JDBC Driver
- Uses PostgreSQL SPI interface

- Extensible Types
- PostgreSQL's User Defined Types
- Enums
- Completely different
- Can be interacted with using PL/Java
- Could write a UDT using PL/Java!

- Future
- Upcoming / Blue Sky Features

- Q & A

Code Samples: Code from function and trigger demonstrations.

This looks great! I wish I could be there to listen.

- thomas

Tom Dunstan wrote:
> On Nov 16, 2007 9:12 AM, Thomas Hallgren <thomas at tada.se> wrote:
>> I think it would be great if you could combine. First some slides where you go over what PL/Java
>> really is and then round up with a demo.
>
> Sorry, I forwarded my kinda rushed abstract / outline through to Josh,
> but didn't CC the list. Here it is... anything missing / obviously
> stupid?
>
> Thanks
>
> Tom
>
>
>
> Title: Knee Deep in the Data: Using PL/Java to Write Custom Functions
> for PostgreSQL.
>
>
> Abstract:
> PL/Java is a PostgreSQL procedural language that allows developers to
> write functions and triggers for the PostgreSQL open source database
> using Java. This allows Java developers to get deeper into the
> development stack, without having to leave Java's second-to-none
> toolset and huge set of available libraries.
>
> The talk will describe the overall design of PL/Java and under what
> circumstances it is a useful tool for Java developers. A demo of how
> to use PL/Java to write database functions and triggers will follow,
> including a demonstration of using a IDE debugger to step through a
> function mid-transaction.
>
> Prerequisite knowledge: general use of SQL and JDBC. Demo may include
> use of JPA.
>
>
> Summary / Outline:
>
> - What's the problem?
> - Performance
> - Access to libraries
>
> - Introducing PostgreSQL
> - Open Source, with support from Sun, Red Hat et al
> - Highly flexible
> - Other PL's
>
> - PL/Java
> - Brief history
> - Design - embedded JVM rather than separate process
>
> - Example problem
> - Explain why standard JDBC/JPA less than ideal
> - If only we could do this...
>
> - Demonstration
> - Write database function in IDE
> - Show deployment steps
> - Drive from JDBC/JPA application
>
> - Another example: a trigger
> - Data validation / correction using 3rd party library (e.g. HTML Tidy)
> - Show how to write and deploy trigger
>
> - Why not use other, more established PostgreSQL PL's?
> - Java devs familiar with Java
> - Other imperative PL's can't do this:
>
> - Debugging
> - Attach IDE debugger to PostgreSQL backed process
> - Set breakpoints, poke around data etc
>
> - Embedded JDBC Driver
> - Uses PostgreSQL SPI interface
>
> - Extensible Types
> - PostgreSQL's User Defined Types
> - Enums
> - Completely different
> - Can be interacted with using PL/Java
> - Could write a UDT using PL/Java!
>
> - Future
> - Upcoming / Blue Sky Features
>
> - Q & A
>
> Code Samples: Code from function and trigger demonstrations.

On Nov 16, 2007 12:47 PM, Thomas Hallgren <thomas at tada.se> wrote:
> This looks great! I wish I could be there to listen.

Thanks! I thought of another couple of things that I should have slipped in:
- Making a point about the ability to properly unit test stored procs
written in java, as that's often a major weakness of people's
SQL-based solutions.
- Maybe slipping in a demo of a function or trigger written in e.g. Groovy :)

If the talk gets accepted, I'll see if the list has suggestions for
anything else that would be cool to show off.

Cheers

Tom

Josh Berkus wrote:
>
> Sorry for the off-topic post, but I have 3 hours to fill in some details
> about Tom and he's asleep right now.
>
> Does anyone know the name of his employer? Even part of a name would help.
>

Andrew would know best.

Kris Jurka