Programming the SQL Way with Common Table Expressions

Bruce Momjian (29.Feb.2012 at 13:15)
Talk at ConFoo 2012 (English - UK)

Rating: 5 of 5

SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages. This talk will help developers use implement CTE queries in their applications and allow operations that normally could only be done in application code to be done via SQL queries.

Who are you?

Claim talk

By clicking this button you are declaring that you are the speaker responsible for it and a claim request will be sent to the administrator of the event.

If the claim is approved you will be able to edit the information for this talk.

Are you sure?

Comments closed.


Rating: 4 of 5

29.Feb.2012 at 14:19 by Seth May (26 comments)

I appreciated the first part of your talk. It gave me what I needed. Things got progressively more postgres-y from there. I do have a good enough understanding now to start working with cte in tsql (with minor syntax changes). You certainly had the feel of a university professor giving a lecture (it took me back to my CS days).

Speaker comment:

01.Mar.2012 at 15:03 by Bruce Momjian (6 comments)

The slides are here:

Speaker comment:

01.Mar.2012 at 15:05 by Bruce Momjian (6 comments)

Seth is right that I used more Postgres functions in the second half of the talk.

Rating: 5 of 5

02.Mar.2012 at 23:21 by Olivier Leger (9 comments)

It was one of my top 3 talks at Confoo. Very interesting. Easy to understand. Unhappily for me, doesn't work (yet) for MySQL.

PS : Bruce I asked you if MySQL planned to integrate the CTE. Actually, I've been told it is but no date yet.

Rating: 5 of 5

06.Mar.2012 at 07:43 by Jean-François Côté (14 comments)

Very interesting, but not sure I will use it. Good talk.

© 2015