Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Johannes Schlüter:
JSON Aggregation functions
Sep 16, 2016 @ 11:53:25

Johannes Schlüter has written up an article covering an interesting feature of the latest MySQL server release related to its JSON column handling: JSON Aggregation functions.

[The JSON datatype, functions and generated columns] combined allow building very powerful applications without committing to a fixed data structure on every part, but I was missing one thing a lot: Aggregation.

A topic I'm thinking a lot about is finding ways to select nested data. In MySQL we typically have two ways for this. Either one sends multiple queries to retrieve different nesting levels or one builds JOINs which tend to deliver repetitive responses.

He points out that one solution is the GROUP_CONCAT function, but the results of this can be difficult to work with and larger data may override the small memory space allowed. Instead he introduces two new functions in v8 to help with this nested data selection: JSON_ARRAYAGG and JSON_OBJECTAGG. He provides a brief example of the use of these two functions together to replace the "concat" handling from before.

tagged: mysql json function v8 release aggregation tutorial

Link: http://schlueters.de/blog/archives/183-MySQL-8.0-JSON-Aggregation-functions.html

Derick Rethans:
MongoDB's aggregation framework
Jan 22, 2013 @ 09:27:18

Derick Rethans has a new post to his site introducing the aggregation framework that's a part of the MonogDB database system. The aggregation framework gives you functionality to access aggregated values from queries without having to map/reduce.

I wanted to find out which cuisines are used in all of the documents of my dataset. Described in a different way: I want all the different cuisine=... tags as used in my dataset. Traditionally you would write a really complex™ Map/Reduce job, but since MongoDB 2.2, there is a new feature called the aggregation framework. The aggregation framework is meant to be an easy way to do fairly complex aggregation jobs.

He talks about the various keywords and features the framework provides like "$match", "$project" and "$unwind". There's also code snippets included that show both the Mongo command line format and the PHP MongoClient format for making the queries. For those more familiar with writing RDBMS SQL, this functionality might help to replace some of the concepts you've been missing.

tagged: mongodb aggregation framework introduction tutorial

Link:

Nick Halstead's Blog:
Three New Programming Tips
Dec 05, 2007 @ 07:53:00

Nick Halstead has posted a few more of his programming tips in the series he's running - three more to be exact dealing with readable code, aggregation, and code structure tips.

You can check out the full list of his programming tips in this list.

tagged: progamming tips readable aggregation inheritance comment divide progamming tips readable aggregation inheritance comment divide

Link:

Nick Halstead's Blog:
Three New Programming Tips
Dec 05, 2007 @ 07:53:00

Nick Halstead has posted a few more of his programming tips in the series he's running - three more to be exact dealing with readable code, aggregation, and code structure tips.

You can check out the full list of his programming tips in this list.

tagged: progamming tips readable aggregation inheritance comment divide progamming tips readable aggregation inheritance comment divide

Link:

Derick Rethans' Blog:
New Planet Discovered
Jan 19, 2006 @ 06:47:47

Derick Rethans has a quick new post today about the "discovery" of a new Planet site focused around the world of eZ Publish.

No, this is not something that New Horizons found as that mission hasn't been launched yet. It's Planet eZ publish, an aggregation of blogs about eZ publish, similar to Planet PHP that aggregates blogs about PHP.

Some of the blogs already included in the list are from people like: Derick himself, Tobias Schlitt, Kristof Coomans, and Paul Borgermans. The RSS feed for the site can be found here...

tagged: planet new ez publish blog aggregation planet new ez publish blog aggregation

Link:

Derick Rethans' Blog:
New Planet Discovered
Jan 19, 2006 @ 06:47:47

Derick Rethans has a quick new post today about the "discovery" of a new Planet site focused around the world of eZ Publish.

No, this is not something that New Horizons found as that mission hasn't been launched yet. It's Planet eZ publish, an aggregation of blogs about eZ publish, similar to Planet PHP that aggregates blogs about PHP.

Some of the blogs already included in the list are from people like: Derick himself, Tobias Schlitt, Kristof Coomans, and Paul Borgermans. The RSS feed for the site can be found here...

tagged: planet new ez publish blog aggregation planet new ez publish blog aggregation

Link: