Posts tagged "databases"

  1. The case against ORMs
    software databases postgres architecture

    Argues against using ORMs based on accumulated experience, focusing on ORMs that attempt to reimplement SQL rather than lightweight database helper libraries.

  2. Four levels of time handling in a database
    software databases postgres architecture

    Breaks down database time handling into four complexity levels, from basic date storage to advanced temporal data management, based on experience working with PostgreSQL time features.

  3. Debugging complex PostgreSQL queries with pgdebug
    software databases postgres

    Explores debugging techniques for complex PostgreSQL queries, introducing pgdebug as a debugging tool.

  4. Writing readable SQL
    software databases postgres

    Shares techniques for writing readable SQL queries, particularly useful for complex 100+ line queries written without ORMs.