Daniel's Tech Blog

Access Path Selection in a Relational Database Management System - Notes Through Chapter 3

2026-04-10
#database  #system r  #storage  #relational database  #management system  #postgresql 

This post is a study dump. I’ve been reading ‘Access Path Selection in a Relational Database Management System’ (Selinger et al., 1979) and stopped at chapter 3 to consolidate what I learned.

[Read more]

tottime = 0 doesn’t mean fast

2026-04-05
#python  #CPython  #cProfile  #pstats  #performance  #internals  #memory 

A new profiling tool pulled a thread. What’s actually in a .pstats file, how cProfile produces it, and why tottime = 0 doesn’t mean fast.

[Read more]

What fork() actually copies and how it impact your celery service

2026-03-28
#python  #celery  #linux  #django  #postgresql  #os  #debugging 

A configuration flag changed. A boolean. The side effect opened a database connection pool before fork() and took down every Celery worker in production. This is an account of the investigation, the OS internals behind it, and a proposed solution still waiting for staging validation.

[Read more]

Teaching AI to teach itself: Why configuration beats correction

2026-03-05
#ai  #workflow  #agents  #configuration  #engineering 

Correcting AI mistakes one prompt at a time is exhausting and doesn’t scale. The better approach: let the agent fix its own mistakes and update its own configuration.

[Read more]

The best code is the one you don’t write

2026-03-04
#ai  #engineering  #documentation  #architecture  #career 

The role of software engineers is shifting from writing code to defining how good code gets built.

[Read more]

Less hands, more brain

2026-02-27
#ai  #engineering  #productivity  #documentation  #workflow 

How leading a greenfield project AI-first. The business rules documents, automated quality gates, and living documentation, changed what it means to add value as an engineer.

[Read more]

Dev x AI: between rejection and excitement

2026-02-26
#ai  #career  #engineering  #mindset 

Two honest feelings most developers have about AI: rejection and excitement. Why only one of them prepares you for what is already happening.

[Read more]
© 2026 Powered by Hugo :: Theme made by panr