← Back to context Comment by datadrivenangel 3 months ago The data parsing must have been painful. High wizardry. 4 comments datadrivenangel Reply taberiand 3 months ago I 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 3 months ago Input 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 3 months ago Obviously it's possible, particularly in this context, but generally speaking I'd rather avoid it. fifilura 3 months ago The 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 3 months ago I 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 3 months ago Input 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 3 months ago Obviously it's possible, particularly in this context, but generally speaking I'd rather avoid it.
fifilura 3 months ago Input 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 3 months ago Obviously it's possible, particularly in this context, but generally speaking I'd rather avoid it.
taberiand 3 months ago Obviously it's possible, particularly in this context, but generally speaking I'd rather avoid it.
fifilura 3 months ago The 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.
I 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
Input 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
Obviously it's possible, particularly in this context, but generally speaking I'd rather avoid it.
The 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.