advent-of-code-2022-sqlite

By Mishkun

Advent-of-code-2022-sqlite Alternatives

Similar projects and alternatives to advent-of-code-2022-sqlite

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better advent-of-code-2022-sqlite alternative or higher similarity.

advent-of-code-2022-sqlite reviews and mentions

Posts with mentions or reviews of advent-of-code-2022-sqlite. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-12-06.
  • -🎄- 2022 Day 7 Solutions -🎄-
    248 projects | /r/adventofcode | 6 Dec 2022
    you can find whole code here, I will show you the most interesting bit with traversing the instruction list with current path stored in pth column. parsed as ( select 'root' as t, '/' as nm, null as bytes, json_array('/') as pth, 1 as step union all select preparsed.t, case when preparsed.t = 'dir' or preparsed.t = 'file' then json_insert(pth, '$[#]', preparsed.nm) else preparsed.nm end as nm, preparsed.bytes, case when preparsed.t = 'cd' then json_insert(pth, '$[#]', preparsed.nm) when preparsed.t = 'dc' then json_remove(pth, '$[#-1]') else pth end as pth, step + 1 as step from parsed inner join preparsed on n = step ), only_dirs as ( select json_remove(nm, '$[#-1]') as nm, sum(bytes) as bytes from parsed where t = 'file' group by json_remove(nm, '$[#-1]') ), all_dirs_counted as ( select json_each.value as dirnm, sum(bytes) as bytes from only_dirs, json_each(only_dirs.nm) group by json_extract(nm, printf('$[%s]', iif(json_each.key > 0,json_each.key - 1, 0))) || json_each.value order by nm )
  • -🎄- 2022 Day 5 Solutions -🎄-
    263 projects | /r/adventofcode | 4 Dec 2022
    Source