fifilura

26 ms·

1. 481.▲
   by fifilura 2y ago

   Maybe I misunderstood, and if I did it makes for an interesting discussion, but your explanation is mainly about what CTEs can be used for not what they can not be used for. In my experience, normalizing tables is mostly for simplifying ins
2. 482.▲
   by fifilura 2y ago

   You are rightfully proud of your skills!
3. 483.▲
   by fifilura 2y ago

   Of course there are optimizations to be made, such as not joining on the raw data or saving the order by to last. And avoid outer joins between two large sized partitioned tables. But to me those optimizations are not imperative in nature.
4. 484.▲
   by fifilura 2y ago

   Input in AoC is always well-formed. And you can always use a regexp? Seems like the smallest problem to me. As soon as you get past that recursive one row per line trick in the posted solutions
5. 485.▲
   by fifilura 2y ago

   It may be true, until you do your ETL in an index-less database such as BigQuery or Trino. Postgres will always be faster for optimized, end user serving, queries. But BigQuery allows you to scale it to 100s of CPUs without having to worry
6. 486.▲
   by fifilura 2y ago

   > Consider that one wouldn't complain as much about a super fucked up nested query (and resulting SQL syntax woes) if it wasn't necessary to write such a query in the first place. And in "modern" SQL this is solved wi
7. 487.▲
   by fifilura 2y ago

   The data parsing is just one recursive query to read one line at a time, and it is done pretty much the same way in each problem.
8. 488.▲
   by fifilura 2y ago

   I second all of that! I wish more people would see the beauty. After a session of SQL, when I take a step back and think. "Hold on. What I have been doing lately is just pure logic. No library dependency resolution, no concurrency prob
9. 489.▲
   by fifilura 2y ago

   Could be extended to: If money means something to you don't ask a human or AI for help spending it.
10. 490.▲
    by fifilura 2y ago

    I don't consider it cheating, I bet most of these rules have an internal relation.
11. 491.▲
    by fifilura 2y ago

    https://en.wikipedia.org/wiki/The_Way_Things_Work
12. 492.▲
    by fifilura 2y ago

    Yeah, summarizing electricity cost with one number is not doable in countries where seasons vary as much as in Finland. Electricity cost will always be higher during winter where it is needed for heating. And this is where households will a
13. 493.▲
    by fifilura 2y ago

    It is also a Swedish diaper brand. I wouldn't yield the fascists a trademark on that name. FWIW they could call their paper Coca Cola and still be irrelevant.
14. 494.▲
    by fifilura 2y ago

    Tangential, after reading the description of the archipelago. Sweden is the country with most islands in the world, followed by Norway and Finland. https://www.worldatlas.com/articles/which-countries-have-the...
15. 495.▲
    by fifilura 2y ago

    Better than an average human then.
16. 496.▲
    by fifilura 2y ago

    Having worked a lot with columnar data, I often have to tell the object oriented crowd that "It's the rows and columns, stupid!". (And that last sentence was a paraphrase. They are far from stupid, just differently wired). I
17. 497.▲
    by fifilura 2y ago

    I don't know? I guess I don't worry about that. Maybe I am Borg.
18. 498.▲
    by fifilura 2y ago

    I am sorry you are so bitter. My reply did contain some ambivalence.
19. 499.▲
    by fifilura 2y ago

    > If 2/3 of your value comes from LLMs I would put that phrase the other way around. The time freed here gives me more time to spend on what actually brings value. My primary job is not to write applications. And if it was, I would
20. 500.▲
    by fifilura 2y ago

    Thank you for your reply. I am currently having a ride with chatgpt allowing me to write applications at 3 times the speed compared to before (where before may be "never" for some technologies) and I am happy for everyone contrib
21. 501.▲
    by fifilura 2y ago

    > I don't want to support AI or have my code trained on AI. What are your arguments for this?
22. 502.▲
    by fifilura 2y ago

    From the top of my head. * Microsoft Windows * Microsoft Excel * Python/Pandas * Web browsers They all do great things and deserve all the praise for maintaining backwards compatibility, havoc would have ensued otherwise. Does not mean
23. 503.▲
    by fifilura 2y ago

    I don't know how exactly you define reproductive rights, but there are plenty of examples where politicians have tried to force women into giving birth to more children. * Nazi Germany https://en.wikipedia.org/wiki&#x2F
24. 504.▲
    by fifilura 2y ago

    Reproductive rights and high fertility.
25. 505.▲
    by fifilura 2y ago

    There are countries where both can coexist. The childless will have to contribute more to daycare subsidies and parental leaves through taxes though.
26. 506.▲
    by fifilura 2y ago

    And if you extend it even further back in time, you'd have https://en.wikipedia.org/wiki/Doggerland there in the middle. Which means that - Congratulations! This is only the beginning! There is so much to add, bot
27. 507.▲
    by fifilura 2y ago

    There are packages for those things in npm, but they you'll have to start using javascript... https://www.npmjs.com/package/@samuelmarina/is-even The javascript crowd. They are always one step ahead!
28. 508.▲
    by fifilura 2y ago

    > Good API design dictates that you should be flexible as to what you accept and strict about what you serve. Being flexible doesn't really break anything. Do you have a source on that? I am not sure I agree. My gripe is with HOCON
29. 509.▲
    by fifilura 2y ago

    I am the opposite :) I run every day. I prefer long stretches of asphalt without any bends Job. But also, running in forests messes with my pace and focus somehow.
30. 510.▲
    by fifilura 2y ago

    Hm, that is interesting. Penguins tend to live on solid ground though AFAIK.