Databases

vrajat

Technical writing on data engineering, analytics, Postgres, and Rust.

13 posts. Monospace editorial. Catppuccin-inspired light and dark.

Posts

13 entries on databases, systems, and software.

  1. DuckDB OOM Kills from Untracked Memory

    duckdb-avro reads whole Avro files outside DuckDB's buffer manager, and jemalloc does not return freed pages to the system immediately. Together they got our container OOM-killed below DuckDB's memory_limit.

    • DuckDB
    • jemalloc
    • Avro
  2. Agents Should Triage Postgres Through Runbooks

    A concrete model for using agents to triage PostgreSQL issues without giving them arbitrary database access.

    • Postgres
    • AI
    • Rust
  3. Observing Claude Code with Hooks and Transcripts

    How to build an observability stack for Claude Code by combining real-time lifecycle hooks with session transcript analysis.

    • claude-code
    • observability
    • clickhouse
  4. Rust Static and Dynamic Dispatch

    A Java developer's guide to Rust compile-time and runtime polymorphism using generics, traits, static dispatch, and dyn Trait.

    • Rust
    • Java
    • Generics
  5. s3q: An S3-Backed Queue Library

    s3q is a queue backed by AWS S3. It is available as a Rust and Python library.

    • S3
    • SQLite
    • queue
  6. Understanding Rust Associated Types

    Compile-time variation, static dispatch, and associated types explained using a SQL dialect use case.

    • Rust
    • Java
    • Traits
  7. A Session-Scoped Test Fixture in Rust

    Rust's test framework lacks pytest-style fixtures. This post shows how to build them using traits, global state, and ctor.

    • Rust
    • Testing
    • Postgres
  8. DO NOT USE LISTEN/NOTIFY for a PostgreSQL Queue

    Consumers of a Postgres Queue can either choose LISTEN/NOTIFY or poll for new items. This post recommends polling for PostgreSQL queues.

    • Postgres
    • SQL
    • queue
  9. Why your next queue should use PostgreSQL

    How PostgreSQL uses SKIP LOCKED and UNLOGGED tables to reduce queue contention, WAL volume, and operational overhead.

    • Postgres
    • SQL
    • queue
  10. Use AI Assistants to build pg-logstats

    An early exploration of coding with agents through building pg-logstats and learning Rust with a real PostgreSQL tool.

    • Postgres
    • AI
    • rust
  11. Triage SafePoint Stalls with Async-Profiler

    A log of triaging a JVM stall due to misconfigured I/O

    • java
    • async-profiler
    • jmc
  12. Database Access Stack in Rust

    A primer on accessing databases in Rust

    • Postgres
    • Sqlite
    • Rust
  13. Open Source SQL Parsers

    A survey of open source SQL parsers to extract information from query history

    • MySql
    • Postgres
    • Snowflake