The Los Angeles PHP Developers Meetup Group

LA MySQL / LAPHP / LA LAMP Joint Session: MySQL Roadmap and SQL Antipatterns

Jul 6 Tue 6:30 PM

Location: This location is shown only to members

Attendance: 30 people attended.
4.505 (5 ratings)
Who organized?
Joe Devon

Joint LAPHP, LA MySQL, LA LAMP Meetup:

6:30 - 7:00 PM

Scott Metcalf (former Oracle-MySQL-Sun-Oracle again employee) will give us an update on MySQL after the Oracle Acquisition. A short presentation and open topic conversation with the group on the MySQL structure within Oracle, MySQL direction, product roadmap, business model etc.

7:00 - 8:30pm

Bill Karwin on Models for Hierarchical Data with SQL and PHP:

Tree-like data relationships are common, but working with trees in SQL usually requires awkward recursive queries. This talk describes alternative solutions in SQL, including:

* Adjacency List
* Path Enumeration
* Nested Sets
* Closure Table

Code examples will show using the Closure Table in PHP, and offer guidelines for choosing one design over another.

About the presenter:
Bill Karwin is an author of "SQL Antipatterns: Avoiding the Pitfalls of Database Programming" from Pragmatic Bookshelf, and a software developer for over 20 years, Bill Karwin specializes in SQL database technology and scripting languages. Previously he led the Zend Framework project through its 1.0 release and wrote the initial Zend_DB component.

8:30 - 9:00 PM
Wrapup and Networking.

About location:
The meeting will be held at the Oracle office in El Segundo. Just go directly to the 10th floor -- there will be a sign. If you come after 7pm you will have to call us at [masked] to be let in since the elevators are locked after 7pm.

Please park in the parking structure for 222 N Sepulveda building. The parking is free after hours.

----
We will take a break for LAPHP group for the rest of the July. The next LAPHP meeting will be in late August.

Photos of this Meetup

No photos yet.

Talk about this Meetup

You must be a member to post a comment. Join or login.
Joe Devon
All attendees are offered a 20% discount on Bill Karwin's book, both hardcopy and ebook: SQL Antipatterns: Avoiding the Pitfalls of Database Programming.

The code is:
20_bksqla_MySQL_LA

You can enter this discount code when purchasing the book at http://www.pragprog.com/titles/bksqla/sql-antipatterns
It's good through July 13.

Posted Jul 5, 2010 6:38 PM

Who attended?

30 attendees
- Howard
  
  “ Good update on what Oracle is doing with MySQL. Very interesting presentation on anit-patterns in SQL. ”
- george girton
  
  “ In the roadmap talk, the circumspection-to-information ratio was quite high; I think roadmap info could have taken five minutes, leaving the rest for details of the 5.2 workbench, which seems promising. The hierarchical modelling in tables talk from the SQL antipatterns book was informative, concise, and obviously appreciated by the audience. The "publisher discount" on the book brought it down to just a few dollars above the Amazon price. So, one wonders. ”
- GregE
  
  “ I am new to these particular meetups but it was a very friendly and seemingly knowledgeable and experienced group. That atmosphere makes for a very productive environment. I wasn't able to make the first topic the SQL Antipatterns presentation by Bill was excellent. My current schedule and work location has made it difficult to make these meeting but I'm hoping that I can attend more of these! Thanks guys! ”
- Neal Koss
  
  “ The MySQL Roadmap was informative and basically reassuring. The lecture was excellent ”
- Rob Dvorak
- Michael Bushey
- xavier
- Jessica Beavers
- Ray Leyva
- Kristjan Siimson
- Joe Devon
- Clinton Paquin
- Richard
- Eric Bollens
- Mike Koh
- Dirk
- Robert Cuadra
- ThatLAGuy
- Cheryl A
- mbannonb
- Herman Radtke
- Karl Zilles
- Jordan Schwartz
- Billy Montgomery
- Z. T. Aquarian (+1 guest)
- Hung Tran
- Dustin Metcalf
- Andy Armstrong
- 1 former member