oleg2025

3 ms·

1. 1.▲
   by oleg2025 2mo ago

   In my experience, good monitoring is a must have from the very beginning. Eyball dashboard from time to time to spot issues, and use during incidents. Things like connections stats, deadlock monitoring, slow queries. All come standard in AW
2. 2.▲
   by oleg2025 2mo ago

   FastAPI pattern works very well with Pgbouncer, when it is in transaction pool mode. Your Python application maintains a connection to Pgbouncer during the lifecycle of the request, but the physical Postgres connection is allocated only dur
3. 3.▲
   by oleg2025 5mo ago

   I've learned that compared to APIs, human interfaces are slow and messy, but there is actually a lot of science behind them. The good apps expose information well, and are optimised for clicks, typing, etc. The best GUIs make great use
4. 4.▲
   by oleg2025 5mo ago

   Couple of months ago I was inspired by kubectl, and built desktopctl CLI to control GUI apps. It uses combination of OCR and Accessibility API on Mac, represents UI as markdown, and exposes actions for mouse and keyboard. My core idea was t