ViennaPHP July Gathering Notes

Organized by Sebastian Göttschkes (@Sgoettschkes) and Stefan Hupe featured by Stockwerk Co-Working Space.

Meetup description:

Let’s talk databases. They are the foundation of many websites and apps and store the precious data we need to make our service valuable. Without data, your app is only a frame without a picture. This meetup is focused on databases and the data ecosystem. We have great talks on this topics, all in relation to PHP development and the PHP ecosystem.

Next, August Gathering: 2014-08-05 18:30, a special meetup outdoor.

Developing Database Driven Webapplications with phpYouDo

by Manuel Hiptmair

• phpYouDo created by Manuel Hiptmair.
• Yet another tool for creating relational database webapplications
• Goals:
  • Less maintenance
  • Separation of PHP and SQL
  • Server relievement
• Source: https://github.com/codeless/phpYouDo
• Demo: http://www.codeless.at/phpyoudo/
• Slideshow: http://www.codeless.at/phpyoudo/doc_intro/
• Codeless Website
• https://www.meetup.com/viennaphp/members/146588332/

MongoDB with PHP

by Daniel Laxar

• Documents are actually JavaScript objects.
• A Table is called Collection.
• Deep level of nesting.
• A PHP ToDo application using Doctrine/ODM with MongoDB
• Slideshow: https://speakerdeck.com/dlaxar/mongodb-with-php
• https://www.meetup.com/viennaphp/members/130664602/

Indexes: The neglected database performance all-rounder

by Markus Winand

• The problem is not the tool itself comic strip.
• ~50% of SQL performance problems are caused by improper index use.
• Indexing is an afterwork done by admins.
• Indexing had to be done by developers. It’s a developers business.
• Slideshow: http://use-the-index-luke.com/blog/2013-07/indexes-the-neglected-performance-all-rounder
• http://use-the-index-luke.com/
• https://www.meetup.com/viennaphp/members/114281162/
• @MarkusWinand

Pictures