Đang tải bảng tin…
Brent Ozar0 Hot0 bình luận13 phút đọc
sp_TexasHoldEm: Multi-Player Poker in T-SQL
A stored procedure called sp_TexasHoldEm lets multiple players compete in a live Texas Hold 'Em game entirely within T-SQL, connecting via SSMS to a public Azure SQL DB Serverless instance. The whole project was built almost entirely by AI: Claude Code and ChatGPT Codex were each given the same prompt to write the stored procedure independently, then set loose on adversarial code review against each other with GitHub Copilot also chiming in. The process surfaced real security issues in AI-generated code, including hole cards left exposed in queryable global temp tables, a certificate fix that accidentally checked a password into the GitHub repo, and neither AI initially considering that temp tables could be updated by malicious players to change hands. The final version merges Claude's more interactive gameplay feel with features borrowed from Codex, plus a companion web page (built by Claude and Codex) for spectators to watch games live. Full source code and setup instructions are published on GitHub.
Nguồn: https://www.brentozar.com/archive/2026/08/sp_texasholdem-multi-player-poker-in-t-sql. 8 Sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.
