vrajat / blog

tags

Postgres

7 posts tagged here.

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

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

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

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

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

  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