High-performance quantum photonic systems with on-demand single photons