Skip to content

Instantly share code, notes, and snippets.

eRPC PostgreSQL Performance Analysis Report

Date: 2025-12-03 Database: erpc-db (PostgreSQL 18.0) Issue: 100% CPU utilization, write-heavy workload performance degradation


Executive Summary

Technical Case Study: Stripe Payment Distribution System

Background

You are tasked with building a backend system for a marketplace platform that allows creators to sell digital products. The platform needs to handle payments from customers and distribute the earnings among multiple connected accounts (e.g., the creator, the platform, and potentially other stakeholders).

Requirements

  1. Create a GraphQL API using TypeScript that integrates with Stripe.
  2. Implement the following functionalities: a. Create Stripe Connect accounts for creators. b. Accept payments from customers.
@0x666c6f
0x666c6f / readme.md
Last active December 14, 2023 19:13
How to mint multiple items in a single transaction
@0x666c6f
0x666c6f / assignments-generator.js
Last active April 27, 2023 15:12
OD Committee scripts
const Airtable = require('airtable');
// Configure the Airtable base
const apiKey = '<API_KEY>';
const baseId = '<BASE_ID>';
const committeeId = '<COMMITTEE_ID>';
const base = new Airtable({ apiKey: apiKey }).base(baseId);
// Define the tables
@0x666c6f
0x666c6f / dipdup-beta-feedback.md
Last active September 28, 2022 20:15
Feedback on new Dipdup installer and project generator

Install

❯ python -c \
    "$(curl -sSL https://raw.githubusercontent.com/dipdup-net/dipdup/aux/more-pipx/src/dipdup/install.py)" \
    --ref aux/more-pipx
=> Welcome to DipDup installer
=> Installing pipx
  WARNING: The script userpath is installed in '/XXXX/.local/bin' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
  NOTE: The current PATH contains path(s) starting with `~`, which may not be expanded by all applications.
I am attesting that this GitHub handle 0xflo-tez is linked to the Tezos account tz2L6ikhCEHz9rZnZWobd7jFSJ6KfkESSP88 for tzprofiles
sig:spsig1bpbVUY9UP4eWSo9NZqoi9CrimdveZ3aM9cjcLiF5PYoNQK14PzxwFvynj2zhVgCEjZNSfQtaAUJeLAQYHQxcrb8ZgFSkM