thomasmg

17 ms·

1. 211.▲
   by thomasmg 4y ago

   Yes, it's also used to hide implementation complexity and diversity: the advantage of a standard (even a "weak" one). > SQL is used to reduce network roundtrips. What I mean is: the database has an API that allows the clie
2. 212.▲
   by thomasmg 4y ago

   So that you can generate SQL more easily, and (for hand-written statements) so that you can re-order lines more easily. Many programming languages support trailing commas.
3. 213.▲
   by thomasmg 4y ago

   > How many of those are "innovative"? In programming languages we have imperative and functional languages, type-safe / untyped, memory managed / unmanaged, low-level vs high level, interpreted / JIT / ahead
4. 214.▲
   by thomasmg 4y ago

   > regular programming languages are “lower level” in that regard and require you to do that optimisation yourself. The point of a language like SQL is that you describe the shape and content of what you want and don't have to worry
5. 215.▲
   by thomasmg 4y ago

   Many databases support other languages as well (eg. PostgreSQL supports many including Python, by default). One challenge is lack of standardization. (SQL is a weak standard, but at least a standard). Weak typing: what about TypeScript? Slo
6. 216.▲
   by thomasmg 4y ago

   > prefer writing plain SQL to using ORMs Oh, ORMs are not the solution. I agree, ORMs often bring new issues (like, loading too many entries in memory), and don't solve many problems (encapsulation). > I don't ever want to h
7. 217.▲
   by thomasmg 4y ago

   SQL has many problems: "from" should come first to help auto-complete; null handling is complicated; the syntax in general is weird. Compatibility is a problem (I have implemented some relational databases in Java: Hypersonic SQL,
8. 218.▲
   by thomasmg 4y ago

   So the computer that simulates the universe is likely a 512-bit machine.
9. 219.▲
   by thomasmg 4y ago

   Power outages can happen for various reasons (storm, accident,...). I would expect the equipment has batteries, no?
10. 220.▲
    by thomasmg 4y ago

    Or chess (including computer opponent): https://js1k.com/2010-first/demo/750
11. 221.▲
    by thomasmg 4y ago

    Yes, using OFFSET for pagination is often problematic. The best alternative IMHO is "keyset pagination", but it requires a bit of work. See https://use-the-index-luke.com/no-offset
12. 222.▲
    by thomasmg 4y ago

    The problem isn't the amount of usage of electricity, the problem is CO2.
13. 223.▲
    by thomasmg 4y ago

    While running, there is no additional "waste" heat: Without solar panels, 100% of the sun rays heats the earth; with solar panels, 20% is converted to electricity, and then converted to heat again.
14. 224.▲
    by thomasmg 4y ago

    I do the same. The problem is at step 5: some faucets (at hotels and so on) are automatic (no touch, due to pandemic maybe). I don't have a solution for this yet.
15. 225.▲
    by thomasmg 4y ago

    > All power generation is subsidized My point is, the combination of wind, solar, storage is orders of magnitude less subsidized. If you account for risks (nuclear) and externalities (fossil fuel). This is not propaganda. But your claims
16. 226.▲
    by thomasmg 4y ago

    Solar + wind are actually fixing problems. They are not perfect, but as you said, perfect is the enemy of improvement. Solar + wind are cheaper than almost anything else, specially nuclear. They have much less detrimental effects to the loc
17. 227.▲
    by thomasmg 5y ago

    Interesting idea! The sun would have to be about 6'000 km away I think. The full moon / new moon / solar eclipse proves that the moon is much closer than the sun. The moon would have to be dangerously close. Then, we know th
18. 228.▲
    by thomasmg 5y ago

    You are right, the internals are important. When I tested this, a long time ago [1] [2], I found that randomly distributed keys on PostgreSQL were indeed faster than e.g. on MySQL. Which surprised me! I still don't quite understand why
19. 229.▲
    by thomasmg 5y ago

    (You are right of course. With the data we have now, we are quite certain that Omicron is much milder. Hopefully no lockdown is needed.) But, personally, I would like to avoid getting Omicron, as long term effects are still unclear: does &q
20. 230.▲
    by thomasmg 5y ago

    Yes. Worst case, lithium can be extracted from seawater: https://electrek.co/2021/06/04/scientists-have-cost-effectiv... - but it's currently cheaper to get it from somewhere else. And lithium can be rec
21. 231.▲
    by thomasmg 5y ago

    There is an analogy with data compression: if you remove a byte, in for example a zip file, and then try to expand it, it might work and give you a different result (it likely doesn't due to a checksum error). I think something similar
22. 232.▲
    by thomasmg 5y ago

    > not the death rate I reported the death rate. It didn't increase dramatically yet; only from 12 per day to 30 per day; and that in theory could also be "patient died with Covid" and not "because of Covid". Yes,
23. 233.▲
    by thomasmg 5y ago

    > the website you linked is falling over I'm sorry about that... It works for me still. You might want to use https://web.archive.org/ > I haven’t seen anything indicating the death rate is increasing I made a st
24. 234.▲
    by thomasmg 5y ago

    Hospitalization, and death rate, are both growing in South Africa. The case rate isn't decreasing either. Test positivity rate was 60% in the last 24 hours, according to https://www.nicd.ac.za/diseases-a-z-index/di
25. 235.▲
    by thomasmg 5y ago

    Well, there is not enough data for _simple_ answers yet (and people like simple, so the media likes simple; scientists also like simple). But there is a lot of data, it is just hard to interpret, even for experts (which I'm not): It is
26. 236.▲
    by thomasmg 5y ago

    I bought one for my wife's wedding ring as well. The local jeweller (who made the rings) tested it with his diamond tester device -- and the led light said 'diamond'. He was a bit surprised :-)
27. 237.▲
    by thomasmg 5y ago

    The capital can come from elsewhere. If the location of the cafe/restaurant is good enough, it is likely cheaper to add a charger + small convenience store to an existing cafe/restaurant, than to build a new restaurant when buildi
28. 238.▲
    by thomasmg 5y ago

    I only read about the german minister of transport, Andreas Scheuer, was in talks to Tesla to open up the charging network. The source I have is here: https://ecomento.de/2021/06/16/tesla-soll-supercharger-fue
29. 239.▲
    by thomasmg 5y ago

    This seem similar to "Penney's game" and the "Humble-Nishiyama Randomness Game" ( https://en.wikipedia.org/wiki/Penney%27s_game ) - betting on which coin-toss sequence appears first. For the 3-bi
30. 240.▲
    by thomasmg 5y ago

    Yes, so you get the top 10'000 using e.g. an IVF+PQ index, then from those get the top 10 using brute-force.