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