Amp Sql Profiler Bundle Laravel Package

Product Decisions This Supports

• Adoption of Amp for High-Performance Symfony Apps: Justifies integrating Amp (Async PHP) into the tech stack by providing critical observability tools (SQL profiling) that were previously missing for Doctrine-less workflows.
• Performance Debugging for Async Workloads: Enables deep SQL query analysis in async environments (e.g., high-traffic APIs, real-time systems), reducing blind spots in profiling.
• Dev vs. Prod Trade-offs: Supports a "dev-only" profiling layer to avoid runtime overhead in production while maintaining observability during development.
• Roadmap for Async Database Layers: Validates the need for async database tooling (e.g., Amp/Postgres) by offering a foundational profiler for future optimizations (e.g., connection pooling, query tuning).
• Build vs. Buy: Avoids reinventing SQL profiling for Amp by leveraging this lightweight, Symfony-native solution instead of custom tools.

When to Consider This Package

• Use Amp + Symfony Without Doctrine: If your app relies on Amp’s async SQL (e.g., Amp\Postgres) but lacks Doctrine’s built-in profiler, this fills the gap.
• Need Query-Level Observability in Async Code: Critical for debugging slow queries in event-driven or concurrent workflows (e.g., WebSockets, background jobs).
• Symfony Profiler Dependency: Only viable if you’re already using Symfony’s WebProfilerBundle (or can adopt it).
• PostgreSQL Focus: Primarily designed for Amp/Postgres; other databases (MySQL, SQLite) may require workarounds or aren’t supported.
• Not for Production: Explicitly a dev tool—avoid if you need runtime profiling in production (consider XHProf or custom logging instead).
• Look Elsewhere If:
  • You’re not using Amp/Symfony.
  • You need prepared statement support or transaction save points.
  • Your team lacks Symfony Profiler familiarity (steepness of integration).
  • You prioritize mature, battle-tested tools (this package has 0 stars/dependents).

How to Pitch It (Stakeholders)

For Executives: "This package lets us profile SQL queries in our async Symfony apps—critical for debugging performance bottlenecks in high-concurrency workloads (e.g., APIs, real-time features). Without it, we’d lack visibility into slow queries when using Amp/Postgres, forcing us to build custom tools or accept slower debugging. It’s a lightweight, dev-only solution that integrates with our existing Symfony Profiler, reducing risk while enabling faster optimizations."

For Engineering: *"If we’re using Amp for async database access (e.g., Amp\Postgres) but ditching Doctrine, this bundle gives us back SQL profiling via Symfony’s Profiler toolbar. Key trade-offs:

• Pros: Zero reinvention, works with our existing stack, supports transactions/backtraces.
• Cons: No prepared statements, requires DI tweaks, and is dev-only. Recommend adopting it if we’re committed to Amp + Symfony, as it’s the only game in town for this use case. If we’re unsure about Amp, this is a low-risk way to test it with observability built in."