t06: Database migration -- GPT-6.1 Sol vs Claude Opus 5.5
Split one name column into first and last name in a Python and SQLite app, and move the old data over.
Opus: 147.8 s. Sol: 272.9 s. Sol took 1.8 times as long.
Opus (s)Sol (s)
Hidden tests: Opus 11 of 11, Sol 11 of 11.
Blind judge pick: Tie.
"Both solutions are exceptionally well-crafted, correctly implementing the atomic migration, schema updates, and backward compatibility. Solution A [Sol] stands out for its memory-efficient streaming during the data copy and its use of `PRAGMA foreign_key_check`, while Solution B [Opus] excels in its dynamic handling of arbitrary indexes/triggers and robust connection state management."
"An exceptionally robust and complete solution that handles SQLite migrations flawlessly, including edge cases like foreign keys and sequence restoration."
"An excellent, robust solution that perfectly handles the schema migration, preserves all constraints and sequences, and maintains full backward compatibility."