Advent of Code 2024 in pure SQL

#1

Post by congoe » Sat, Dec 28, 2024, 5:38 PM UTC

Advent of Code 2024 in pure SQL
databasearchitects.blogspot.com

Re: Advent of Code 2024 in pure SQL

#2

Post by marcle » Sun, Dec 29, 2024, 9:02 AM UTC

This is very interesting code that uses Umbra v0.2-957, PostgreSQL 17.2, and DuckDB v1.1.3.

One minor point: some of the problems could not be implemented in DuckDB due to a missing xor operator - but the documentation includes an xor function (https://duckdb.org/docs/sql/functions/numeric.html#xorx-y) for the same version. Is the form of the function not suitable?

Re: Advent of Code 2024 in pure SQL

#3

Post by marcle » Sun, Dec 29, 2024, 4:44 PM UTC

marcle wrote: post #2

This is very interesting code that uses Umbra v0.2-957, PostgreSQL 17.2, and DuckDB v1.1.3. One minor point: some of the problems could not be implemented in DuckDB due to a missing xor operator - but the documentation includes an xor function ( https://duckdb.org/docs/sql/functions/numeric.html#xorx-y ) for the same version. Is the form of the function not suitable?

Answering my own question: Umbra and PostgreSQL include "#" as an operator for bitwise xor, whereas DuckDB does not.