News for hackers. Stuff that matters.

A comment on Advent of Code 2024 in pure SQL. Parent comment

Re:Advent of Code 2024 in pure SQL by dunham on Thursday January 02, 2025 @03:26PM (#42578459)
Speaking of parsing, back around y2k we were building an app that used XML everywhere, which was the style at the time, and our DBA wanted to write an xml parser in SQL (the api would involve sending XML to the database). That got vetoed.

IMO, this kind of thing is what AoC is good for - you get to play with weird/obscure stuff without affecting your day job code.

[ Parent | on HN ]
Re:Advent of Code 2024 in pure SQL by jamie_ca on Thursday January 02, 2025 @03:40PM (#42578603)
I did something with JSON back before there was reasonable native support - it's certainly not robust, but it handled a few syntax variants for a use case where we had an extra attribute column that serialized JSON, and wanted to surface one of the fields as a proper column on the table.

https://blog.tracefunc.com/2011/11/19/parsing-json-in-sql-ht...

[ Parent | on HN ]
Re:Advent of Code 2024 in pure SQL by jmg_ on Thursday January 02, 2025 @07:04PM (#42580498)
Funnily, I’m actively working on rewriting a stored procedure which parses an XML snippet as one of its arguments

Luckily it’s not a handwritten XML parser though: https://learn.microsoft.com/en-us/sql/t-sql/functions/openxm...

[ Parent | on HN ]
Re:Advent of Code 2024 in pure SQL by yazmeya on Friday January 03, 2025 @04:35PM (#42589738)
Just around the same time I was working at a place that used Oracle's web app extension, with CGI endpoints written completely in PL/SQL. I did end up writing an XML parser/serializer for it.
[ Parent | on HN ]