
PostgreSQL: GROUP BY expression
GROUP BY is an integral part of SQL and PostgreSQL. You might not know that the GROUP BY expression can handle more than just simple fields.
The best problem-solving writing in software engineering — databases, performance, security, frontend and distributed systems, in one feed.

GROUP BY is an integral part of SQL and PostgreSQL. You might not know that the GROUP BY expression can handle more than just simple fields.

A behind-the-scenes look at how we improved comment performance in the Figma editor

Flask makes it possible for developers to build an API for whatever use case they might have. In this tutorial, Wole Oyekanmi will show you how to set up Google Cloud, Cloud SQL, and App Engine to build a Flask API. (Cloud SQL is a fully managed platform-as-a-service (PaaS) database engine, and App Engine is a fully managed PaaS for hosting applications.)

GitHub’s Professional Services Engineering team has decided to open source another project: Rally + GitHub. You may have seen our most recent open source project, Super Linter. Well, the team has done…

Implementing 'focus and reply' for Fastmail with JMAP

The start of any internship brings a wide range of emotions, from excitement to nervousness. After months of anticipating our first day at Slack, reality sunk in that this summer would be extremely different from any other. Due to the pandemic, our entire experience would be virtual. As the two interns for the Product Security…

After 12 inspiring articles, Andy Clarke draws his Inspired Design Decisions series to a close by explaining how studying the work of Bradbury Thompson — one of the masters of 20th Century graphic — will teach you how to combine graphic and typographical elements with innovative layouts to create stunning designs for the web. In this final article, Andy brings together lessons from all his previou

The creators of two Microsoft phishing campaigns, that Area 1 has dubbed “Summer Bonus”, are attempting to lure unsuspecting employees into divulging their Microsoft credentials.

At Cloudflare, we believe that expanding access to tools that election officials and political candidates need to combat a range of online threats both serves our mission to help build a better Internet and strengthens our democracy.

You know we do video screencasts, right? It's not, like, super regular, but I have done them for a long time, still like doing them, and plan to keep doing

Testing implementation details is a recipe for disaster. Why is that? And what does it even mean?

People use our apps and services every day for a wide spectrum of use cases, including sharing pictures; following the latest news and sports updates; sharing life-changing events, such as the birth of a child; or marking themselves safe via Safety Check. Now, more than ever, people are also using our services to stay connected […]


Props and PropTypes are an important mechanism for passing information between React components, and we’re going to look into them in great detail here. This tutorial will introduce you to the details about props, passing and accessing props, and passing information to any component using props. However, it’s always a good practice to validate the data we are getting through props by using PropTyp


Customer Service. Business. Growth. While these three make up a large portion of what keeps most enterprise companies operating, they are just the beginning at Cloudflare. I am excited to share that I have joined Cloudflare as its Chief Customer Officer.

Hey gang! I've been fortunate enough to be a guest in a variety of different here, so I thought it was time for another Chronicle post. You know, those

I was browsing the Svelte docs on my iPhone and came across a blaring UI bug. The notch in the REPL knob was totally out of whack. I’m always looking to

How do you know a page (or any element on that page) scrolls? Well, if it has a scrollbar, that's a pretty good indication. You might still have to scrapple


Merchants worldwide rely on Shopify's Point Of Sale (POS) app to operate their brick and mortar stores. Unlike many mobile apps, the POS app is mission-critical. Any downtime leads to long lineups, unhappy customers, and lost sales. The POS app must be exceptionally reliable, and any outages resolved quickly. Reliability engineering is a well-solved problem on the server-side. Back-end teams are a

Alongside our guides, printed books, eBooks and printed magazine, we’re thrilled to have yet another addition to our smashingly cherished gems: meet our brand new [Interface Design Patterns Checklists](https://www.smashingmagazine.com/2020/08/checklist-cards-release/). Co-founder of Smashing Magazine, Vitaly Friedman, has been collecting, curating and refining each checklist for years — we’re conv

SEO is an ever-changing world. Blink and you’ll miss the latest best practices, thought leaders, and tools. Feeling out of touch is natural. Every tweak to major search engine algorithms sends shockwaves throughout the web. For those who don’t follow the SEO space it can be easy to lose track of the latest trends, authorities, and resources. That’s what this page is for. It will break down SEO’s h

A framework for project managing in Figma