# Cube Published articles for Cube. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## FOSDEM 2020 and Hardware Announcements DevFeed: [FOSDEM 2020 and Hardware Announcements]() Original publisher: [Read original article]() Published: 2020-02-03T00:00:00Z Content type: news Language: en Sources: [Community blog on PINE64]() Topics: [FOSDEM](), [Pinephone](), [Hardware](), [Mobile]() Tags: [announcements](), [community](), [cube](), [devices](), [fosdem](), [hardrock64](), [hardware](), [mobile](), [pinephone](), [soedge]() ### AI overview PINE64 reports on its community gathering at FOSDEM 2020, including strong attendance at its stall, PinePhone case giveaways, appearances at partner stalls, and Linux phone discussions. The article also introduces hardware announcements limited to plans for the first two quarters of 2020, but the supplied text does not include their details. ### Source excerpt PINE64 get-together with community devs and partner-projects at FOSDEM 2020 Sorry for the delay in delivering FOSDEM news and announcements to you - I was too occupied with great company, splendid beer and shouting at hundreds of people across our stall table. It was awesome to see so many familiar faces, meet new ones and socialise with projects we usually don't get an opportunity to talk with. Some of you may have already seen pictures or videos of our stall at FOSDEM overflowing with people; I am happy to say that we were one of the most - if not the most - besieged stall at FOSDEM this year. There literally was a wall of people at the stall at all times, and if not for our community members and partner-project devs we'd probably not cope. This also had the effect of being as much our booth as that of Manjaro, UBports, Nemo mobile, KDE, postmarketOS, Aurora, Meamo Leste and others :) Crowd at the PINE64 stall FOSDEM 2020 In the January community update we announced that if you are attending FOSDEM, and already had a PinePhone on order or with you, then we'd have a surprise piece of swag for you. As some of you already know, the swag in question was a choice of a hard or soft PinePhone case. Over the course of ~8 hours that we were at the stall we gave well over 100 cases. It was really exciting to see so many PinePhone early adopters at FOSDEM. Soft (silicone) case left, hard case right Apart from our cramp little corner of FOSDEM, you could also check out PINE64 devices at the KDE and OpenHAB stalls. There was also a talk by Merlijn Wajer and Bart Ribbers (youtube video linked) concerning Linux phones as well as a joint BOF with Purism (my thanks go out to Dalton and Bhushan for taking the lead on this), where a significant portion of the time was dedicated to the PinePhone in particular. In other words, there were many PINE64 accents all over FOSDEM, which made me realise how much we've grown in the past two years. KDE stall FOSDEM 2020 However, to us, FOSDEM m ## Postgres 9.5 - The feature rundown DevFeed: [Postgres 9.5 - The feature rundown]() Original publisher: [Read original article]() Author: Map Published: 2015-12-27T20:55:56Z Content type: article Language: en Sources: [Craig Kerstiens]() Topics: [Database](), [Replication](), [import](), [etl]() Tags: [count](), [cube](), [databases](), [etl](), [examples](), [feature](), [import](), [postgres](), [postgresql](), [replication](), [schema]() ### AI overview This article reviews notable features planned for Postgres 9.5, including upsert behavior, grouping sets, cube and rollup, importing foreign schemas, and pg_rewind for PostgreSQL replication management. ### Source excerpt The headline of Postgres 9.5 is undoubtedly: Insert... on conflict do nothing/update or more commonly known as Upsert or Merge. This removes one of the last remaining features which other databases had over Postgres. Sure we'll take a look at it, but first let's browse through some of the other features you can look forward to when Postgres 9.5 lands: Grouping sets, cube, rollup Pivoting in Postgres has sort of been possible as has rolling up data, but it required you to know what those values and what you were projecting to, to be known. With the new functionality to allow you to group various sets together rollups as you'd normally expect to do in something like Excel become trivial. So now instead you simply add the grouping type just as you would on a normal group by: SELECT department, role, gender, count(*) FROM employees GROUP BY your_grouping_type_here; By simply selecting the type of rollup you want to do Postgres will do the hard work for you. Let's take a look at the given example of department, role, gender: grouping sets will project out the count for each specific key. As a result you'd get each department key, with other keys as null, and the count for each that met that department. cube will give you the same values as above, but also the rollups of every individual combination. So in addition to the total for each department, you'd get breakups by the department and gender, and department and role, and department and role and gender. rollup will give you a slightly similar version to cube but only give you the detailed groupings in the order they're presented. So if you specified roll (department, role, gender) you'd have no rollup for department and gender alone. Check the what's new wiki for a bit more clarity on examples and output Import foreign schemas I only use foreign tables about once a month, but when I do use them they've inevitably saved many hours of creating a one off ETL process. Even still the effort to setup new foreign tables has sho