Question library
Questions from real interviews. Drill any of them by voice in a couple of minutes, with an interviewer, a score and feedback.
In a SQLAlchemy application, a function returns an object from a repository, and accessing one of its related fields throws DetachedInstanceError. Why does this happen, and how should you organize session handling properly?Mid-levelDesign how a high-load Python service using SQLAlchemy works with PostgreSQL: dozens of instances, each with several workers. How would you organize the connection pools and the session lifecycle?Senior