cousett.com

10/03/08

Web Request

• #3918, Update Faculty Advisor Tips website — Completed
• #3919, Update Hours — Completed
• #3920, Correction to Faculty Governance page — Completed
• #3921, more corrections to Faculty Governance — Completed
• #3922, more corrections to Faculty Governance pages — Completed

Other Projects

• Approved Pam’s Timesheet
• Student Organizations Website
  • Updated database on maxie to work on changes — Completed
  • Work on changes to student organization admin tool:
    • change date: Organization Recognition Status 2005-2006 to Organization Recognition Status 2007-2008 — Completed
    • change text: Conference Attendance to Risk Management Training Attendance — Completed
    • take out completely: Membership Rosters — Completed
    • change options in Organization Recognition Status to the following: — Completed
      • inactive
      • officially recognized
      • recognition pending
      • no info on file
    • give student officers access to officer and advisor info for their organization
    • give admin login access named individuals
• Volunteer DB
  • Met with Lou Serna next meeting Thursday October 16th @ 1pm
  • Researching possibility of rebuilding app in Cake
• CTE Drupal Site
  • Added confirmation message to RSVP form
  • Modified user menu for CTE users
  • Edited permissions for authenticated users that are not part of CTE
  • Added / Edited webform and events
• Sponsored Programs Drupal Site
  • Edited permissions for authenticated users that are not part of CTE
  • Fixed issue where editor user was not displaying whole editor menu

Web Requests – Pam

• #3914, new link for BSS site — Completed
• #3925, Oct Career Planning Events — Completed
• #3926, Press Releases — Completed
• #3913, Press Releases — Completed
• #3923, Graduate Fair list — Completed
• #3924, add link to site index – Completed
• #3918, Update Faculty Advisor Tips website – Completed
• #3919, Update Hours — Completed
• #3920, Correction to Faculty Governance page – Completed
• #3921, more corrections to Faculty Governance – Completed
• #3922, more corrections to Faculty Governance pages – Completed

10/02/08

Web Request

• #3915 – update who form is sent to — Completed
• #3917 – add link to Austin Chronicle review of Cloud 9 — Completed

Other Projects

• Student Organizations Website
  • Updated database on maxie to work on changes
  • Work on changes to student organization admin tool:
    • change date: Organization Recognition Status 2005-2006 to Organization Recognition Status 2007-2008
    • change text: Conference Attendance to Risk Management Training Attendance
    • take out completely: Membership Rosters
    • give student officers access to officer and advisor info for their organization
    • change options in Organization Recognition Status to the following:
      • inactive
      • officially recognized
      • recognition pending
      • no info on file
    • give student officers access to officer and advisor info for their organization
    • give admin login access named individuals
• Volunteer DB
  • Met with Lou Serna next meeting Thursday October 16th @ 1pm
  • Researching possibility of rebuilding app in Cake
• CTE Drupal Site
  • Added confirmation message to RSVP form
  • Modified user menu for CTE users
  • Edited permissions for authenticated users that are not part of CTE
  • Added / Edited webform and events
• Sponsored Programs Drupal Site
  • Edited permissions for authenticated users that are not part of CTE
  • Fixed issue where editor user was not displaying whole editor menu

10/01/08

Web Requests

• Business School Updates
  • #3908, remove and replace ACC list — Completed
• #3894, Change a name (Stephanie’s Request) — Completed

Other Projects

• Installed Adobe Creative Suite CS2 on student station
• Student Organizations Website
  • Updated database on maxie to work on changes
  • Work on changes to student organization admin tool:
    • change date: Organization Recognition Status 2005-2006 to Organization Recognition Status 2007-2008
    • change text: Conference Attendance to Risk Management Training Attendance
    • take out completely: Membership Rosters
    • give student officers access to officer and advisor info for their organization
    • change options in Organization Recognition Status to the following:
      • inactive
      • officially recognized
      • recognition pending
      • no info on file
    • give student officers access to officer and advisor info for their organization
    • give admin login access named individuals
• Volunteer DB
  • Prepared for meeting with Lou 10/2/08
  • Working on current updates sent in March
• CTE Drupal Site
  • Researched Login Destination Module for this site so that the Access Denied page would be eliminated
  • Fixed login issue with LDAP
  • Researching ability to send email to user when webform is submitted
• Sponsored Programs Drupal Site
  • Researched Login Destination Module for this site so that the Access Denied page would be eliminated
  • Fixed login issue with LDAP

Web Requests – Pam

• #3911, add link to Statesman review of Cloud 9 — Completed
• #3910, add performance dates/times to Theatre page — Completed
• #3842, October Panoramic 08 — Completed
• Business School Updates

• #3908, remove and replace ACC list — Completed
• #3912: delete page — Completed

9/30/08

Web Requests

• Business School Updates
  • #3891, delete date in text — Completed (10/03/2008)
  • #3892, change title of course and add option — Completed (10/03/2008)
  • #3893, Add stars and note at bottom — Completed
  • #3895, revisions
  • #3896, revisions 2
  • #3897, revisions rest of disciplines
  • #3898, remove semicolons
  • #3899, add course to mktg required courses
  • #3900, revisions to ibus required courses
  • #3901, change blurb
  • #3902, change finc required course list
  • #3903, changes to entp
  • #3904, change minor info
  • #3905, remove degree sheets
  • #3906, remove minor info
  • #3907, change the ethics list
  • #3908, remove and replace ACC list
  • #3909, add list of organizations
• #3889 – APSS Bio addition — Completed (10/03/2008)
• #3890, Koz. Center_Cuba Event Update – Completed (10/02/2008)

Other Projects

• Student Organizations Website
  • Met with Marissa
  • Changes to be made to student organization admin tool:
    • minor date changes
    • drop down option changes
    • edit ability for student org officers to their own organizations
  • Emailed follow up note to Marissa on what changes were agreed upon
• Volunteer DB
  • Working on current updates sent in March
• CTE Drupal Site
  • Updated events in RSVP form
  • Researched Login Destination Module for this site so that the Access Denied page would be eliminated
• Sponsored Programs Drupal Site
  • Researched Login Destination Module for this site so that the Access Denied page would be eliminated

Web Requests – Pam

• #3842, October Panoramic 08 – Awaiting Client Review (09/18/2008)
  • Sent to Client Review 9/15/08 — Awaiting Client Review (09/18/2008)
• Business School Updates

• #3891, delete date in text — Completed (10/03/2008)
• #3892, change title of course and add option — Completed (10/03/2008)
• #3893, Add stars and note at bottom — Completed
• #3895, revisions
• #3896, revisions 2
• #3897, revisions rest of disciplines
• #3898, remove semicolons
• #3899, add course to mktg required courses
• #3900, revisions to ibus required courses
• #3901, change blurb
• #3902, change finc required course list
• #3903, changes to entp
• #3904, change minor info
• #3905, remove degree sheets
• #3906, remove minor info
• #3907, change the ethics list
• #3908, remove and replace ACC list
• #3909, add list of organizations

9/29/08

Web Requests

• #3886: Founder’s Day page update — Completed                

• Sent to Client Review 9/26/08 — Awaiting Client Review (09/26/2008)

• #3888: Update Advisory Board Member’s Info. – Completed
• #3889 – APSS Bio addition — Awaiting Client Review (10/03/2008)
• #3890, Koz. Center_Cuba Event Update – Awaiting Client Review (10/02/2008)

Other Projects

• Student Organizations Website
  • Contacted Marissa 9/26
  • Working on documentation for Marissa
  • Completed documentation for Marissa and Student Officers
  • Evaluate needs of Student Organizations to implement more functionality
• Volunteer DB
  • Called Lou Serna 9/26
  • Set up meeting for Thursday 10/2/08 with Lou to review site and discuss future
  • Working on current updates sent in March
• CTE Drupal Site
  • RSVP function similar to Sponsored Programs
  • Added LDAP functionality
  • Added Users: Julie & Melodee
  • Researched Login Destination Module for this site so that the Access Denied page would be eliminated
• Sponsored Programs Drupal Site
  • Added LDAP functionality
  • Added User Login Module
  • Added Users: Joanne, Allison, & Melodee
  • Researched Login Destination Module for this site so that the Access Denied page would be eliminated

Web Requests – Pam

• #3842, October Panoramic 08 – Awaiting Client Review (09/18/2008)
  • Sent to Client Review 9/15/08 — Awaiting Client Review (09/18/2008)
• #3887, October Events – Completed (09/30/2008)

written by Cousett

written by Cousett

Test Driven Development
Derick Rethans (eZ Systems)
5:15pm Tuesday, 09/16/2008
Best Practices, The Basics Hall B

I will start with introducing what testing is, and which parts of a web application can be tested with different methods. I will continue with introducing the test-driven development model – as counter model against traditional software development models, followed by a summary of how a development team could be organized to produce better quality code. After a very quick introduction into Unit Testing and the benefits and problems it brings I will conclude my session with a number of case studies of major and smaller software development teams regarding Test-Driven Development and what it did to their code quality.
Photo of Derick Rethans
Derick Rethans
eZ Systems

Derick Rethans provides solutions for Internet related problems. He has contributed in a number of ways to the PHP project, including the mcrypt, date and input-filter extensions, bug fixes, additions and leading the QA team. He now works as project leader for the eZ components project for eZ systems A.S.. In his spare time he likes to work on Xdebug, watch movies, travel and practise photography.

webste – http://derickrethans.nl/
talks – http://derickrethans.nl/talks.php

Test drive the development
-test are written before the code
-there is no code without code

tests suites
-contain tests that check whether the code does what it is supposed to do
-also cover things that should fail

Present the Idea
Write the Requirements
Design the Component
Implementation
-write API stubs with parameter documentation and descriptions
-write test cases
-initial implementation
-initial implementation review
-updating implementation according to review
-implementation review

Pre-release Testing

http://www.artima.com/weblogs/viewpost.jsp?thread=203994

PHP Unit
eZComponents

http://www.developertesting.com/archives/month200705/

phpUnderControl
CruiseControl

Introduce TDD concepts gently

written by Cousett

PDO: PHP Data Objects
Wez Furlong (Message Systems, Inc.)
2:45pm Tuesday, 09/16/2008
The Basics Room 209

PHP 5.1 features a new data access layer, PHP Data Objects (PDO), that provides a clear, simple (but powerful), unified API for working with all our favorite databases. Features include prepared statements with bound parameters (for all databases, even those that don’t natively support them), transactions, cursors, LOBs, and flexible error handling. Also examined are the issues of cross-database portability and how best to use PDO to avoid some of the pitfalls associated with that topic. Join Furlong to learn more about the future of database access in PHP.
Photo of Wez Furlong
Wez Furlong
Message Systems, Inc.

Wez Furlong is Director of Engineering at Message Systems where he works on the fastest MTA on Earth.

Wez is a PHP Core developer and active OpenSource contributor. He currently resides in Sykesville, Maryland with his wife, son and loyal pup.

Website – http://netevil.org/

PDO::ERRMODE_SILENT
PDO::ERRMODE_WARNING
PDO::ERRMODE_EXCEPTION

forward-only cursors
-a.k.a. “unbuffered” queries in mysql parlance
-they are the default cursor type
-rowCount() doesn’t have meaning
-FAST
-other queries are likely to block
-you must fetch all remaining data before launching another query
-$stmt->closeCursor();

Fetch modes
-PDO::FETCH_COLUMN

Iterators
        $dbh = new PDO($dsn);
        $stmt = $dbh->query(
                “SELECT name FROM FOO”,
                PDO::FETCH_COLUMN, 0);
        foreach ($stmt

Changing Data
        $deleted = $dbh->exec(
                “DELETE FROM FOO WHERE 1”);
        $changes = $dbh ->exec(
                “UPDATE FOO SET active=1”
                “WHERE NAME LIKE ‘%joe%’”);

Autonumber / sequences
        $dbh->exec(
                “insert into foo values(…)”);
        echo $dbh->lastInsertId();

Prepared Statements
$stmt = $dbh -> prepare(
        “INSERT INTO CREDITS (extension, name)”
        “VALUES(:extension, :name)”);
$stmt -> execute(array(
        ‘extension’ => ‘xdebug’
        ‘name’ => ‘Derick Rethans’
));

written by Cousett \\ tags: php, technology, web development, work, zendcon

PECL Picks – Extensions to make your life better
Elizabeth M Smith (OmniTI)
1:30pm Tuesday, 09/16/2008
Advanced Hall B

PECL is undergoing a transformation, new developers, new tools, and a clearing away of the old cruft. Learn the history and idea behind PECL and where the future is leading, and who is involved in the process.

Then take a walk through PECL and learn about the best and the brightest. PECL extensions fall into three rough categories. Library wrappers take a C library and bring the functionality to PHP, general libraries add new functionality to PHP through internal C code, and engine level extensions allow you to do cool things with PHP.

Each extension will have a brief overview, who maintains it, the requirements and purpose of the extension, and a quick “how to use it”. There are 184 extensions in PECL and more on the way, we’ll see how many useful ones fit into an hour.
Elizabeth M Smith
OmniTI

Elizabeth M. Smith has been using PHP since time immemorial (PHP 4.0beta), but has used PHP 5 for so long now she’s forgotten how she ever got by without SPL and a real object model. Elizabeth is a certifiable (yes, we mean men in white coats coming to put on strait jackets) windows geek, if it can be compiled on windows, she’ll compile it, if not… she’ll fix it so it does. She enjoys doing very perverse things to Windows using PHP as well – all this in between caring for her 4 kids and husband.

* Web site

Text Extensions
        - bbcode
        -colorer
        -doublemetaphone
        -enchant
        -namazu
        -stem
        -xdiff

bbcode
        provides various tag types, high speed tree based parsing

tell it how to parse what to parse

Search
        - clucene
        - mongosearch
        -swish
        -sphinx
                -libsphinx www.sphinxsearch.com
PHP do bad things
        -runkit
        -funcall
        -intercept

        Runkit
        - replace rename remove user defined functions and classes
define customized superglobal variables for general purpose use

        Funcall
        - code.google.com/p/funcall
        - call callbacks before or after specified call

http://elizabethmariesmith.com/slides/pecl-picks.pdf

http://elizabethmariesmith.com/slides/

http://pecl.php.net/

written by Cousett \\ tags: php, technology, web development, work, zendcon

Static and Dynamic Analysis at Ning
David Sklar (Ning, Inc.)
11:15am Tuesday, 09/16/2008
Advanced, Best Practices, Performance Hall B

Ning’s “Your Own Social Network” application is 160,000 lines of PHP that powers hundreds of thousands of social networks, each different than the others. To keep our platform humming along smoothly, as well as to keep our internal development processes sane, we need to know what all that PHP code is doing and how it’s structured.

Documentation is nice (and essential) but there’s no substitute for relying on the code itself as the canonical source for information about, well, the code. That’s where static and dynamic analysis come in.

Static analysis is scanning, parsing, munching, and otherwise processing our PHP source code to answer whatever questions we have about it. Who calls this function? What parts of the code do disk write operations? Are there any untranslated strings in our localization message catalogs?

Dynamic analysis gathers information from running code. How many times is a function called? How long does it take? When does our PHP code access the filesystem?

This talk discusses the static and dynamic analysis techniques that we use at Ning to understand and optimize our platform, including the PHP tokenizer, regular expressions, the vld and xdebug extensions, and the PHP DTrace provider.

David Sklar
Ning, Inc.

David Sklar is a Software Architect at Ning, Inc., and the author of PHP Cookbook (O’Reilly), Learning PHP 5 (O’Reilly), and Essential PHP Tools (Apress). He speaks regularly at many conferences, including the O’Reilly Open Source Convention, the O’Reilly Emerging Technology Conference, USENIX, and various PHP conferences. He keeps a blog at http://www.sklar.com/blog/ and maintaings the PX (http://px.sklar.com/), a PHP code exchange he created in 1996. David has a degree in Computer Science from Yale University and lives in New York City, where he enjoys riding the subway, eating salt-baked scallops, and admiring the 18th- and 19th-century American furniture at the Metropolitan Museum of Art.

written by Cousett \\ tags: php, technology, web development, work, zendcon

Join-fu: MYSQL

written by Cousett

Join-fu: The Art of SQL Tuning for MySQL
Jay Pipes (MySQL)
10:00am Tuesday, 09/16/2008
Advanced, Best Practices, Performance Hall B

Join-fu is the art of performance-tuning your application’s SQL. Join Jay in a fun, irreverent look at the common ways application developers misuse and abuse their database.

We will cover a number of important topics in tuning your SQL application layer. We will not be covering tuning server variables or benchmarking, but instead the slides will be full of SQL and PHP code that the audience can immediately use to dramatically increase the performance of their schemas and applications.

The talk focuses on MySQL, but the tips and techniques used can easily be used to increase performance in a number of RDBMS-driven applications.
Photo of Jay Pipes
Jay Pipes
MySQL

Jay Pipes is the North American Community Relations Manager at MySQL. Co-author of Pro MySQL (Apress, 2005), Jay has also written articles for Linux Magazine and regularly assists software developers in identifying how to make the most effective use of MySQL. He has given sessions on performance tuning at the MySQL Users Conference, RedHat Summit, NY PHP Conference, OSCON, PHP-Quebec, ZendCond and Ohio LinuxFest, amongst others. He lives in Columbus, Ohio, with his wife, Julie, and his four animals. In his abundant free time, when not being pestered by his two needy cats and two noisy dogs, he daydreams in PHP code and ponders the ramifications of __clone().

vertical partitioning – split tables with many columns into multiple tables
horizontal partitioning – split table with many rows into multiple tables

vertical partitioning
- mixing frequently and infrequently accessed attributes in a single table
- space in buffer pool at a premium
        - splitting table allows main records to consume the buffer pages without the extra data taking up space in memory
- need FULLTEXT on your text columns?

create a myisam indexing
        -replication answer master both in db slave … do fulltext indexing on slave

the MYSQL query cache
        - you must understand your application’s read/write patterns
        -internal query cache design is a compromise between CPU usage and read performance
        -stores the MYSQL_RESULT

http://jpipes.com/

written by Cousett \\ tags: php, technology, web development, work, zendcon

written by Cousett

written by Cousett