02-AREAS

Data pipelines built (and added on to) without a solid foundation will suffer from poor efficiency, slow development speed, long times to triage production issues, and hard testability. What if your data pipelines are elegant and enable you to deliver features quickly? An easy-to-maintain and extendable data pipeline significantly increase developer morale, stakeholder trust, and the business bottom line! Using the correct design pattern will increase feature delivery speed and developer value (allowing devs to do more in less time), decrease toil during pipeline failures, and build trust with stakeholders. This post goes over the most commonly used data flow design patterns, what they do, when to use them, and, more importantly, when not to use them. By the end of this post, you will have an overview of the typical data flow patterns and be able to choose the right one for your use case.

With the Python compiler Nuitka, you create protected binaries from your Python source code.

A catalog of patterns to better understand, communicate, and teach the design of distributed systems

ISE Engineering Fundamentals Engineering Playbook

ISE Engineering Fundamentals Engineering Playbook

ISE Engineering Fundamentals Engineering Playbook

ISE Engineering Fundamentals Engineering Playbook

An object that carries data between processes in order to reduce the number of method calls.

If you want to split address in Excel, this comprehensive guide is your ticket to mastering it as You’ll explore through different functions.

Use piped workflows for efficient data cleaning and visualization.

Best practices with R around select topics.

Editor's Note: This post was written by Chris Pappalardo, a Senior Director at Alvarez & Marsal, a leading global professional services firm. The standard processes for building with LLM work well for documents that contain mostly text, but do not work as well for documents that contain tabular data (like spreadsheets). We wrote about our latest thinking on Q&A over csvs on the blog a couple weeks ago, and we loved reading Chris's exploration of working with csvs and LangChain using agents, chai

Use LLMs in Excel formulas

LLMs are great at generating text, but how do you get them to generate structured output?

A package written for R focused on baseball analysis. Currently in development. - BillPetti/baseballr

Create custom Streamlit and Shiny R apps effortlessly with AI assistance. Design, code, and deploy data apps in minutes.

Learn how to implement strong authentication and SSO in Shiny apps with Descope. This guide integrates both OIDC and SAML with Posit Connect for seamless login.

In order to facilitate parsing of http requests and creating appropriate responses this package provides two classes to handle a lot of the housekeeping involved in working with http exchanges. The infrastructure builds upon the rook specification and is thus well suited to be combined with httpuv based web servers.

Send error reports to the Google Error Reporting service and view errors and assign error status in the Google Error Reporting user interface.

Seamless SSO for R applications

The rcrd class extends vctr. A rcrd is composed of 1 or more fields, which must be vectors of the same length. Is designed specifically for classes that can naturally be decomposed into multiple vectors of the same length, like POSIXlt, but where the organisation should be considered an implementation detail invisible to the user (unlike a data.frame).

How to extract data from a REST API using dlt's REST API source

Reproducibility is a huge challenge in science, especially as datasets grow larger and workflows become more complex. Enter targets — an R package that helps

This tutorial shows you how to create PostgreSQL user-defined data type using CREATE DOMAIN and CREATE TYPE statements.

In this tutorial, you will learn about PostgreSQL foreign key and how to add foreign keys to tables using foreign key constraints.

In this tutorial, you will learn how to copy an existing table to a new one using various PostgreSQL copy table statements.

You will learn about the PostgreSQL temporary table and how to manage it using the CREATE TEMP TABLE and DROP TABLE statements.