vrajat / blog

Databases

vrajat

vrajat's personal website

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

Posts

7 entries on databases, systems, and software.

  1. 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

  2. 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

  3. Why your next queue should use PostgreSQL

    Postgres features like FOR UPDATE SKIP LOCKED and UNLOGGED tables make it a strong candidate for queueing. This post explains why and sets up detailed benchmarks.

    • Postgres
    • SQL
    • queue

  4. Use AI Assistants to build pg-logstats

    A series that documents building pg-logstats with AI Code Assistants

    • Postgres
    • AI
    • rust

  5. Triage SafePoint Stalls with Async-Profiler

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

    • java
    • async-profiler
    • jmc

  6. Database Access Stack in Rust

    A primer on accessing databases in Rust

    • Postgres
    • Sqlite
    • Rust

  7. Open Source SQL Parsers

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

    • MySql
    • Postgres
    • Snowflake