July, 2020

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Scalegrid

In our previous posts in this series, we spoke at length about using PgBouncer and Pgpool-II , the connection pool architecture and pros and cons of leveraging one for your PostgreSQL deployment.

Dynatrace Managed now available on all major cloud platforms

Dynatrace

Dynatrace news. Cloud-based solutions typically aren’t a viable option or enterprises that have strict security or privacy policies that require their data to be maintained on-premise.

Cloud 218

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Protractor Tutorial: Handling Timeouts With Selenium

DZone

A lot of times while performing Selenium test automation, you’ll come across certain scenarios when your test fails because the webpage or the web element takes some time to load completely.

Stuff The Internet Says On Scalability For July 31st, 2020

High Scalability

Hey, it's HighScalability time! Serverless is really complex. Or is it? paulbiggar sparked a thoughtful Twitter thread. Do you like this sort of Stuff? Without your support on Patreon this kind of Stuff won't happen.

Machine Learning for a Better Developer Experience

The Netflix TechBlog

Stanislav Kirdey , William High Imagine having to go through 2.5GB of log entries from a failed software build?—?3 3 million lines?—?to to search for a bug or a regression that happened on line 1M. It’s probably not even doable manually!

Infinite Scroll without Layout Shifts

Addy Osmani

Learn how to implement infinite scrolling for long lists without causing surprising layout shifts

114
114

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Scalegrid

JSON stands for JavaScript Object Notation. It is an open standard format which organizes data into key/value pairs and arrays detailed in RFC 7159. JSON is the most common format used by web services to exchange data, store documents, unstructured data, etc. In this post, we are going to show you tips and techniques on how to effectively store and index JSON data in PostgreSQL.

More Trending

Property-Based Testing for JavaScript Developers

DZone

All experienced frontend developers know one thing to be true: Users are unpredictable. No matter how much user research you conduct or how thick the font-weight is on your input label, you can never be certain how users will interact with your product.

Add a new node into existing SQL Server Always On Availability Groups

SQL Shack

This is the 5th article in the series of a comprehensive guide to SQL Server Always On Availability Groups. Introduction In the previous articles (see TOC at the bottom), we configured a two-node SQL Server Always On Availability Group. We performed the following steps at a high level.

Empowering the Visual Effects Community with the NetFX Platform

The Netflix TechBlog

The cloud-based platform allows vendors, artists and creators to connect and collaborate on visual effects (VFX) from anywhere in the… Continue reading on Netflix TechBlog ». visual-effects

Cloud 159

Native lazy-loading for iframes is here!

Addy Osmani

Native lazy-loading for iframes is now supported in Chrome and Chromium browsers

90

Redis Transactions & Long-Running Lua Scripts

Scalegrid

Redis offers two mechanisms for handling transactions – MULTI/EXEC based transactions and Lua scripts evaluation. Redis Lua scripting is the recommended approach and is fairly popular in usage. Our Redis™ customers who have Lua scripts deployed often report this error – “ BUSY Redis is busy running a script. You can only call SCRIPT KILL or SHUTDOWN NOSAVE ”.

Address Kubernetes-observability configuration chaos with unparalleled automation

Dynatrace

Dynatrace news. Kubernetes can be a confounding platform for system architects. Microservice design principles force people to think along a spectrum of loose coupling. Configuration headaches for Kubernetes observability are no different.

How to Write Test Cases?

DZone

Test case writing is one of the very important activities in software development to validate the functionality of the software. Also, these are the standards through which various teams such as the testing team, development team, and management team follow for developing and testing the software.

Database-level health detection in SQL Server Always On Availability Groups

SQL Shack

This is the 8th article in the series for SQL Server Always On Availability Groups. Introduction SQL Server Always On Availability Groups create a group of databases that fails over together in case the primary replica is unavailable.

Unbundling Data Science Workflows with Metaflow and AWS Step Functions

The Netflix TechBlog

by David Berg, Ravi Kiran Chirravuri, Romain Cledat, Jason Ge, Savin Goyal, Ferras Hamad, Ville Tuulos Continue reading on Netflix TechBlog ». infrastructure aws machine-learning

AWS 148

Introducing Domain-Oriented Microservice Architecture

Uber Engineering

Introduction. Recently there has been substantial discussion around the downsides of service oriented architectures and microservice architectures in particular.

Sponsored Post: StackHawk, InterviewCamp.io, Educative, Triplebyte, Stream, Fauna

High Scalability

Who's Hiring? InterviewCamp.io has hours of system design content. They also do live system design discussions every week. They break down interview prep into fundamental building blocks. Try out their platform. T riplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. Make your job search O (1), not O ( n ). Apply here. Need excellent people? Advertise your job here! Cool Products and Services.

Five questions about AIOps with Forrester Senior Analyst Rich Lane

Dynatrace

Dynatrace news. Recently, I had the opportunity to moderate a webinar, Using AIOps to focus I&O resources on what really matters , with guest speaker, Forrester Senior Analyst Rich Lane and Dynatrace SVP of product Steve Tack.

51 Best Tools for Small Businesses in 2020 (Free and Inexpensive)

DZone

It is an exciting thing to start your small business or to work for one. However, working without modern tools at your disposal can render your performance to a slow halt. This post will highlight the best tools for small businesses that are free and not so costly.

How to resolve deadlocks in SQL Server

SQL Shack

In this article, we will talk about the deadlocks in SQL Server, and then we will analyze a real deadlock scenario and discover the troubleshooting steps. In general, we can find out various theoretical advice and examples about the deadlock problems on the web but, in this article, we will tackle a true deadlock story […]. Deadlocks Performance

Byte Down: Making Netflix’s Data Infrastructure Cost-Effective

The Netflix TechBlog

By Torio Risianto, Bhargavi Reddy, Tanvi Sahni, Andrew Park Continue reading on Netflix TechBlog ». cloud-storage data data-infrastructure aws netflix

Infinite Scroll without Layout Shifts

Addy Osmani

Learn how to implement infinite scrolling for lists without impacting Cumulative Layout Shift

70

Sponsored Post: ipdata, StackHawk, InterviewCamp.io, Educative, Triplebyte, Stream, Fauna

High Scalability

Who's Hiring? InterviewCamp.io has hours of system design content. They also do live system design discussions every week. They break down interview prep into fundamental building blocks. Try out their platform. T riplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. Make your job search O (1), not O ( n ). Apply here. Need excellent people? Advertise your job here! Cool Products and Services.

Digital Business Analytics: Accelerating your dashboard journey

Dynatrace

Dynatrace news. We introduced Dynatrace’s Digital Business Analytics in part one , as a way for our customers to tie business metrics to application performance and user experience, delivering unified insights into how these metrics influence business milestones and KPIs.

PyTest Tutorial — Parallel Testing With Selenium Grid

DZone

Selenium is one of the widely used test automation frameworks for automated browser testing. Selenium test automation is really helpful in testing websites or web apps on different combinations of browsers, operating systems, and devices.

Configure Managed Service Accounts for SQL Server Always On Availability Groups

SQL Shack

This article is a 6th article in the series for SQL Server Always On Availability Groups. It covers the configuration of the group managed service account (gMSA) for SQL Services. Introduction DBA uses services accounts to run the various SQL Services.

Desktop Application Testing vs Web Application Testing

Testsigma

There are lots of applications that users use these days. Some are accessed via the internet while some of them are installed on the user’s computer. The former being categorized as the web-based applications while the latter falling into the desktop applications category.

Fundamentals of table expressions, Part 4 – Derived tables, optimization considerations, continued

SQL Performance

This article is the fourth part in a series on table expressions. In Part 1 and Part 2 I covered the conceptual treatment of derived tables. In Part 3 I started covering optimization considerations of derived tables. This month I cover further aspects of optimization of derived tables; specifically, I focus on substitution/unnesting of derived tables. In my examples I’ll use sample databases called TSQLV5 and PerformanceV5.

We've improved image lazy-loading in Chrome!

Addy Osmani

We improved image lazy-loading in Chrome! The new thresholds for when we lazy-load images offer much better data-savings, are closer to JavaScript lazy-loading libraries and are rolling out to Chrome 79

64

Reporting at scale leveraging cross-environment dashboards (General Availability)

Dynatrace

Dynatrace news. We’re happy to announce the General Availability of cross-environment dashboarding capabilities (having released this functionality in an Early Adopter release with Dynatrace version 1.172 back in June 2019).

Testing Iceberg

DZone

Anyone who has done some test automation or has searched for information about the subject will have come across the famous "Testing Pyramid" more than once. This figure represents the "ideal" way to distribute the automatic tests of a system in its different layers. Where the width, indicates the number of tests that should exist about the different levels. performance testing service test automation qa ui unit iceburg

Using Diskspd to test SQL Server Storage Subsystems

SQL Shack

In this article, we will learn how to test our storage subsystems performance using Diskspd. The storage subsystem is one of the key performance factors for SQL Server because SQL Server storage engine stores database objects, tables, and indexes on the physical files.

Gzip vs Brotli – Best Browser Compression

MachMetrics

The web today is bigger than ever before, with average desktop page weight up more than 6% in the last year alone. Thankfully, there are simple measures that web developers can take to ensure that the files being served to their visitors are as small as possible. One such measure is HTTP compression.

AI in testing: 13 essential resources for QA pros

TechBeacon Testing

What if you could make software testing simple? What if it could be done without all the conversations, questions, defect reports, and metrics? App Dev & Testing, Testing, Artificial Intelligence (AI), Test Automation

How Continuous Testing Supercharges Your Automation Testing

Testsigma

Introduction. Continuous Testing is the testing strategy to fast-track the testing required for achieving rapid software development using Agile and DevOps methodologies. What is Continuous Testing?

Managing the Dynatrace API across multiple thousand environments

Dynatrace

Dynatrace news. In part one of this series I’ve covered the automatic roll-out of the OneAgent to thousands of hosts and the autonomous setup of Dynatrace environments in a large global Dynatrace Managed installation. A quick recap: I’ve managed a global Dynatrace Managed installation consisting of several clusters, each hosting up to thousand individual environments.