addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

ViennaPHP July Gathering

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.

The meetup will take place on Wednesday, July 2nd, 2014. The location is our beloved Stockwerk Co-Working. We'll start at 18:30. 


AGENDA

• "Welcome" by Sebastian Göttschkes

• "MongoDB with PHP" by Daniel Laxar

• "Indexes: The neglected database performance all-rounder" by Markus Winand

• Mini-Talk: "Developing Database Driven Webapplications with phpYouDo" by Manuel Hiptmair

• "After-Gathering-Party" featured by StockWerk


ABSTRACTS

"MongoDB with PHP" by Daniel Laxar

While NoSQL has become very popular in other programming languages (like node.js or ruby), many PHP programmers still prefer RDBM systems. We’ll have a look into NoSQL and how it is different to RDBMS. We’ll compare MongoDB to MySQL or postgres and examine when to use the one or the other. Finally I’m giving an in-depth introduction into how to get started with MongoDB together with PHP using plain queries or a high-level ODM like Doctrine.

"Indexes: The neglected database performance all-rounder" by Markus Winand

Proper indexing is a very time and cost-effective way to improve performance. Yet it is often done in a very sloppy way. This talk explains the organizational misconceptions that lead to sloppy indexing and gives advice how to change it. Finally we will show the results of a short online quiz that reveals the state of indexing know-how in the field.

"Developing Database Driven Webapplications with phpYouDo" by Manuel Hiptmair

Database Driven Webapplications in general consist of these parts: HTML-Templates, PHP-Scripts and JavaScripts. Most often, these parts are tightly woven into each other, which makes it tricky for the designer to edit the HTML. Additionally, the PHP-Programmer has a hard time extracting SQL-queries for specific inspections. 

phpYouDo tries to solve these problems by separating the PHP-Scripts from the SQL-Queries and the HTML-Templates. SQL-Queries are outsourced to configuration files and HTML-Templates are combined with JavaScript to display the selected records. 

Join or login to comment.

  • D

    Lastly, as for Michael's particular use scenario, I could not find any reports of a document-based NoSQL inventoring solution in the wild, whereas this is precisely the scenario used as an example in Codd's seminal paper¹. It should also be noted that PostgreSQL could represent a good compromise for use cases with a *limited* need for non-relational storage, via its key-value store and JSON data types². This is the solution I went for in my prototype, largely because Postgres already falls within my field of incompetence.

    Again, I'm not trying to knock down MongoDB or NoSQL, but rather hypothesising that its field of application may have less of an overlap with RDBMS than it appears at first sight.

    And apologies for the multiple posts.


    ¹ http://www.iai.uni-bonn.de/III/lehre/vorlesungen/Informationssysteme/WS05/materialien/p377-codd.pdf
    ² http://www.postgresql.org/docs/9.4/static/datatype-json.html

    July 7, 2014

  • D

    Furthermore, if we are doing anything other than "normal design" (in Vincenti's sense¹) then we should take a critical look at our implementation at an early enough stage that we can back off without compromising the project in case we made the wrong choices. Vincenti gives elsewhere² a captivating account of the transition from radical to normal design in the context of aircraft landing gear development.

    I have given MongoDB a quick spin while prototyping for a project, and quickly realised that a document-based datastore would spell trouble in my particular situation (cf. Markus' talk) and I didn't fancy sailing into the largely uncharted NoSQL waters, or face the prospect of becoming a MongoDB tester / debugger rather than concentrate on my problem³.


    ¹ http://www.jstor.org/discover/10.2307/285347 (paywall)
    ² http://sjbae.pbworks.com/w/file/fetch/45731613/Vincenti(1994)_Longer%20Version(For%20Reference).pdf
    ³ https://blog.serverdensity.com/does-everyone-hate-mongodb/

    July 7, 2014

  • D

    Hello. I promised Michael that I would pass on a link incidental to Daniel's great presentation on MongoDB: http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/

    That's a sort of post-mortem on why they chose a document-based NoSQL (that it was MongoDB rather than Couch or whatever is not all that relevant) for a project, and why that was the wrong decision in their case. Personally, I'm not suggesting that NoSQL is a Bad Idea™, but pointing out that the database is often a core component of our products, and the decision as to which one DBMS to use should be taken carefully and objectively based on the project's actual goals, requirements, and constraints. Let someone else be the first to experiment! :)

    July 7, 2014

  • codeless

    Thanks for the input on my presentation yesterday. I've updated the docs and presentation slides at https://github.com/codeless/phpYouDo

    5 · July 3, 2014

  • Markus W.

    Hi!

    Thanks everybody for your great involvement yesterday.

    Here are the slides for my talk:
    http://use-the-index-luke.com/blog/2013-07/indexes-the-neglected-performance-all-rounder

    I've used a different opening slide, the comic, which you find here:
    http://www.commitstrip.com/en/2014/06/03/the-problem-is-not-the-tool-itself/

    5 · July 3, 2014

  • Martin

    Great meetup! :)
    Now I know that I didn't miss anything not to familiar with NoSQL. But good that I've heard what it is. :D
    Special thanks to Markus for the interactive talk. Very interesting and informative. May you can bring the slides online?

    July 2, 2014

  • A former member
    A former member

    Excellent Meetup! Thanks to the awesome talkers! Thanks to Sebastian and Stefan for the great organisation! Thanks to Stockwerk for the wonderful enviroment!!!

    2 · July 2, 2014

  • George S.

    did not make it to meetup :(
    Could presenters post their presentations somewhere so I can check what was it all about please?

    July 2, 2014

  • Martin

    Is there anyone who has already extracted a complete addresslist (postcode, street, housenumbers, lat/lon) of Vienna from OpenStreetMap or any other Open Data Project? I need this data as base for a project.
    Would be great if you can help me. :)

    June 30, 2014

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy