Systems | Development | Analytics | API | Testing

%term

Django and the N+1 Queries Problem

The N+1 Queries Problem is a perennial database performance issue. It affects many ORM’s and custom SQL code, and Django’s ORM is not immune either. In this post, we’ll examine what the N+1 Queries Problem looks like in Django, some tools for fixing it, and most importantly some tools for detecting it. Naturally, Scout is one of those tools, with its built-in N+1 Insights tool.

Python Debugging: More Than Just A (Print) Statement

As most developers will agree, writing code is oftentimes, if not always, easier than debugging. As a simple definition, debugging is the process of understanding what is going on in your code. When speaking in terms of Python, it is a relatively simple process. Every developer has their own personal debugging method or tool they swear by. When it comes to Python, most developers use one (or more) of the following: print statements, traditional logging, a pdb debugger, or an IDE debugger.

BigQuery now offers industry-leading uptime SLA of 99.99%

More than ever, businesses are making real-time, data-driven decisions based on information stored in their data warehouses. Today’s data warehouse requires continuous uptime as analytics demands grow and organizations require rapid access to mission-critical insights. Business disruptions from unplanned downtime can severely impact company sales, reputation, and customer relations.

Accelerating Mayo Clinic's data platform with BigQuery and Variant Transforms

Genomic data is some of the most complex and vital data that our customers and strategic partners like Mayo Clinic work with. Many of them want to work with genomic variant data, which is the set of differences between a given sample and a reference genome, in order to diagnose patients and discover new treatments. Each sample’s variants are usually stored as a Variant Call Format file, or VCF, but files aren’t a great way to do analytics and machine learning on these data.

Intelligent Document Processing for Innovation in Life Sciences Regulations

In the wake of the COVID-19 pandemic, many life sciences organizations are seeking efficiency and control over the regulatory process more than ever before. There is an increased urgency for speed, accuracy, and simplified processes in the Regulatory Information Management (RIM) space, and to prioritize projects that will quickly deliver the most patient value.

Data Security and Governance - not the lockdown businesses expect it to be

The current economic climate has meant a sudden and seismic step-change in how many of our customers operate. The recent shift to remote working has seen an increase in conversations around how data is managed, with many businesses needing to achieve democratic data access in order to derive value and improve efficiencies as we navigate the ‘new norm’. Toolsets and strategies have had to shift to ensure controlled access to data.

Top Takeaways From CDO Sessions: Customers and Thought Leaders

We’ve been busy speaking to our customers and thought leaders in the industry and have rounded up the key takeaways from our latest CDO sessions. Here are some of the top takeaways and advice gained from these sessions with big data leaders, Kumar Menon from Equifax, Anheuser-Busch’s Harinder Singh, Sandeep Uttamchandani from Unravel, and DBS Bank’s Matteo Pelati.

Angular: How to Use Virtual Scroll With a Flat Tree?

While developing Kraken’s frontend I quickly stumbled upon performance issues with Angular Material tree when too many nodes where opened. Kraken is an open source load testing IDE. As such, it displays a tree of directories and files used to script the load testing scenarios: You can have a look by creating a free account on the demo or check the source code of the UI on GitHub. It uses the latest version of Angular and components provided by Angular Material such as the tree.