RYSZARD BIALACH
PUBLIC VIEW
← Back to evidence deck

PYTHON · DJANGO · POSTGRESQL · IDENTITY · TESTING

Secure Application Engineering & Automation

Secure software-engineering case study focused on Django, Python automation, PostgreSQL, identity separation, least privilege, logging, deterministic testing, and governed workflows.

Problem

Automation becomes a security risk when identities, permissions, evidence, and expected system state are unclear. The project explores how application design can make automated work attributable and testable.

Engineering approach

The application patterns emphasize secure defaults, explicit identity boundaries, least privilege, observable changes, and deterministic acceptance tests.

  • Django application architecture
  • PostgreSQL-backed governance data
  • Human and service-account separation
  • Role-based permissions
  • Audit-oriented logging
  • Desired-state and as-built reconciliation

Automation governance

Manager, worker, administrative, and service identities are treated as distinct principals. Automated workflows are designed to operate through explicit permissions rather than broad administrative access.

Security lesson

Secure application engineering is not only input validation and authentication. It is also about constraining who can perform an action, proving what changed, and verifying that the resulting system matches its intended state.