News for hackers. Stuff that matters.
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse by namtab00 on Friday October 27, 2023 @07:08PM (#38045145)
maybe double the underscore on conflict?

some_key =1

some__key = 2

Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse by dicriseg on Friday October 27, 2023 @07:38PM (#38045353)
The convention when flattening is exactly that I thought - an underscore per level of nesting. This is what I would expect to see too.
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse by memset on Friday October 27, 2023 @07:26PM (#38045261)
Agree. (What if the original users key has the double underscore?) maybe this can be defined as a param?
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse by namtab00 on Friday October 27, 2023 @07:53PM (#38045457)
> What if the original users key has the double underscore?

Double it again.

some_key = 1

some__key = 2

some____key = 3

This is analogous to what C#11 does to allow raw string literal quotes containing those same quotes. https://learn.microsoft.com/en-us/dotnet/csharp/language-ref...