Techreport blog

Engineering Insights & Guides

The best problem-solving writing in software engineering — databases, performance, security, frontend and distributed systems, in one feed.

11,777 articles
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 — 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