4 ms·
The data parsing must have been painful. High wizardry.
by datadrivenangel 2y ago
The data parsing must have been painful. High wizardry.
- fifilura 2y agoThe data parsing is just one recursive query to read one line at a time, and it is done pretty much the same way in each problem.
- taberiand 2y agoI feel like it'd be entirely acceptable to load the inputs into tables first and still qualify as pure sql, because string parsing in sql is so blergh
- fifilura 2y agoInput in AoC is always well-formed. And you can always use a regexp? Seems like the smallest problem to me. As soon as you get past that recursive one row per line trick in the posted solutions
- taberiand 2y agoObviously it's possible, particularly in this context, but generally speaking I'd rather avoid it.