GitHub - lyxell/aoc2024-sqlite: Advent of Code 2024 in SQLite

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 29 Commits
01_01.sql		01_01.sql
01_02.sql		01_02.sql
01_input.txt		01_input.txt
02_01.sql		02_01.sql
02_02.sql		02_02.sql
02_input.txt		02_input.txt
03_01.sql		03_01.sql
03_02.sql		03_02.sql
03_input.txt		03_input.txt
04_01.sql		04_01.sql
04_02.sql		04_02.sql
04_input.txt		04_input.txt
05_01.sql		05_01.sql
05_02.sql		05_02.sql
05_input.txt		05_input.txt
06_01.sql		06_01.sql
06_02.sql		06_02.sql
06_input.txt		06_input.txt
07_01.sql		07_01.sql
07_02.sql		07_02.sql
07_input.txt		07_input.txt
08_01.sql		08_01.sql
08_02.sql		08_02.sql
08_input.txt		08_input.txt
09_01.sql		09_01.sql
09_02.sql		09_02.sql
09_input.txt		09_input.txt
10_01.sql		10_01.sql
10_02.sql		10_02.sql
10_input.txt		10_input.txt
11_01.sql		11_01.sql
11_02.sql		11_02.sql
11_input.txt		11_input.txt
README		README
regex0.so		regex0.so

Repository files navigation

advent of code 2024 in sqlite

RUNNING

install sqlite3, e.g.
$ sudo apt install -y sqlite3

then pass the sql code into sqlite, e.g.
$ sqlite3 < 01_01.sql

to get regex support in sqlite we load a dll,
the one included is for amd64 linux,
you can find dlls for other operating systems here 
https://github.com/asg017/sqlite-regex/releases/tag/v0.2.3