Home/2020
Archive

Year 2020

2,570 articles published in 2020.

Databases — PostgreSQL: GROUP BY expression

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.

HSHans-Jürgen SchönigHans-Jürgen Schönig·August 19, 2020Databases
Databases — Setting Up An API Using Flask, Google’s Cloud SQL And App Engine — Smashing Magazine

Setting Up An API Using Flask, Google’s Cloud SQL And App Engine — Smashing Magazine

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.)

WOWole OyekanmiWole Oyekanmi·August 19, 2020Databases
Career & Teams — Introducing the Rally + GitHub integration

Introducing the Rally + GitHub integration

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…

JMJared MurrellJared Murrell·August 18, 2020Career & Teams
Security — How to Have an Impactful Internship… Virtually

How to Have an Impactful Internship… Virtually

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…

RRoss·August 18, 2020Security
Design & UX — Inspired Design Decisions With Bradbury Thompson: The Art Of Graphic Design — Smashing Magazine

Inspired Design Decisions With Bradbury Thompson: The Art Of Graphic Design — Smashing Magazine

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

ACAndy ClarkeAndy Clarke·August 18, 2020Design & UX
Security — July bonus Microsoft spear phishing

July bonus Microsoft spear phishing

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.

EElaineElaine·August 17, 2020Security
Frontend — What Happens When Border Radii Overlap?

What Happens When Border Radii Overlap?

I’d wager that most times we’re rounding box corners in CSS, we’re applying a uniform border-radius value across the border. It’s a nice touch of polish in

JSJay Sitter·August 17, 2020Frontend
Frontend — Mastering Props And PropTypes In React — Smashing Magazine

Mastering Props And PropTypes In React — Smashing Magazine

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

ADAdeneye David AbiodunAdeneye David Abiodun·August 17, 2020Frontend
Engineering — Why I joined Cloudflare

Why I joined Cloudflare

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.

HHarnishHarnish·August 14, 2020Engineering
Frontend — CSS-Tricks Chronicle XXXIX

CSS-Tricks Chronicle XXXIX

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

CCChris Coyier·August 14, 2020Frontend
Engineering — That's Just How I Scroll

That's Just How I Scroll

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

CCChris Coyier·August 14, 2020Engineering
Engineering — Building Reliable Mobile Applications - Shopify

Building Reliable Mobile Applications - Shopify

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

SEShopify Engineering·August 14, 2020Engineering
Design & UX — Community Resources, Weekly Newsletter, And Boosting Skills Online — Smashing Magazine

Community Resources, Weekly Newsletter, And Boosting Skills Online — Smashing Magazine

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

ILIris LjesnjaninIris Ljesnjanin·August 14, 2020Design & UX
Engineering — A Smashing Guide To The World Of Search Engine Optimization — Smashing Magazine

A Smashing Guide To The World Of Search Engine Optimization — Smashing Magazine

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

FOFrederick O BrienFrederick O Brien·August 14, 2020Engineering
Performance — Accessibility In Chrome DevTools — Smashing Magazine

Accessibility In Chrome DevTools — Smashing Magazine

In this article, Umar Hansa will demonstrate some useful features in DevTools which can help you improve the accessibility of your website. For many websites, things like performance and accessibility are an afterthought. But as web developers, it’s best to strive to create the best possible experience we can for our users, regardless of their abilities. This article uses Google Chrome since it’s

UHUmar HansaUmar Hansa·August 13, 2020Performance
Frontend — Chapter 2: Browsers

Chapter 2: Browsers

Sir Tim Berners-Lee creates the technologies behind the web — HTML, HTTP, and the URL which blend hypertext with the Internet — with a small team at CERN. He

JHJay Hoffmann·August 12, 2020Frontend
Security — DELF: Safeguarding deletion correctness in online social networks

DELF: Safeguarding deletion correctness in online social networks

What the research is: DELF is a new framework to help developers implement data deletion in modern applications. Traditional methods for implementing deletion require application developers to write repetitive, error-prone code. DELF’s main novelty lies in enabling developers to implement deletion in every product they build with minimal effort, which takes the form of annotations […]

MEMeta Engineering·August 12, 2020Security
Engineering — 4 Lessons Web App Designers Can Learn From Google — Smashing Magazine

4 Lessons Web App Designers Can Learn From Google — Smashing Magazine

The first place Suzanne Scacca goes to whenever she’s curious about what more could be done to improve our users experiences is the Google Developers site or Think with Google to pull the latest consumer data. There’s a reason why Google dominates market share for things like search engines, web browsers, email clients and cloud storage services. It knows exactly what consumers want and it has des

SSSuzanne ScaccaSuzanne Scacca·August 12, 2020Engineering
Frontend — How To Configure Application Color Schemes With CSS Custom Properties — Smashing Magazine

How To Configure Application Color Schemes With CSS Custom Properties — Smashing Magazine

Splitting colors into three levels (palette, functional, and component) can help you be more adaptive to changes and new requirements while working on a project. In this article, Artur Basak introduces a modern approach on how to set up CSS Custom Properties that respond to the application colors. The idea of dividing colors into three levels can be quite useful: a palette (or scheme), functional

ABArtur BasakArtur Basak·August 11, 2020Frontend
Engineering — zerodivs.com

zerodivs.com

Pretty neat little website from Joan Perals, inspired by stuff like Lynn's A Single Div. With multiple hard-stop background-image gradients, you don't need

CCChris Coyier·August 10, 2020Engineering
Engineering — Don't Wait! Mock the API

Don't Wait! Mock the API

Today we have a loose coupling between the front end and the back end of web applications. They are usually developed by separate teams, and keeping those

MIMarko IlicMarko Ilic·August 10, 2020Engineering
AI & ML — Blocking Slack Invite Spam With Machine Learning

Blocking Slack Invite Spam With Machine Learning

A fact of life for building an internet service is that, sooner or later, bad actors are going to come along and try to abuse the system. Slack is no exception — spammers try to use our invite function as a way to send out spam emails. Having built up the infrastructure to easily deploy…

RRoss·August 10, 2020AI & ML
Frontend — Better Error Handling In NodeJS With Error Classes — Smashing Magazine

Better Error Handling In NodeJS With Error Classes — Smashing Magazine

You can get by in NodeJS without properly handling errors but due to the asynchronous nature of NodeJS, improper handling or errors can cause you pain soon enough. This article is for JavaScript and NodeJS developers who want to improve error-handling in their applications. Kelvin Omereshone explains the `error` class pattern and how to use it for a better, more efficient way of handling errors ac

KOKelvin OmereshoneKelvin Omereshone·August 10, 2020Frontend
Networking — Protecting Remote Desktops at Scale with Cloudflare Access

Protecting Remote Desktops at Scale with Cloudflare Access

Today we are announcing Argo Tunnel RDP Bastion mode, a simpler way to protect RDP connections at scale. By functioning as a jump-host, cloudflared can reside on a single node in your network and proxy requests to any internal server, eliminating deployment headaches.

MBMichael BorkensteinMichael Borkenstein·August 7, 2020Networking
Engineering — Every Website is an Essay

Every Website is an Essay

Every website that’s made me oooo and aaahhh lately has been of a special kind; they’re written and designed like essays. There’s an argument, a playfulness

RRRobin RendleRobin Rendle·August 7, 2020Engineering