ttfkam

65 ms·

811.
by ttfkam 4y ago
I'm just going to mention: thank god or the FDIC! In earlier generations, banks just fell over, and your money was gone. Saving money for retirement? Gone. Saving money for college? Gone. Thank god for bank regulation/reporting an
812.
by ttfkam 4y ago
To some extent but not a large extent. SUVs tend to be less safe than their sedan counterparts. Worse on rollovers, worse on emergency handling, and much worse on visibility. You might survive a crash better in an SUV, but you're more
813.
by ttfkam 4y ago
Georgia is subject to hurricanes, which nuclear plants can weather much better than solar panels or wind turbines. And aside from aforementioned hurricanes, wind is simply not plentiful or reliable across the southeastern United States. Jus
814.
by ttfkam 4y ago
LATERAL, VALUES, et al would object to that narrow designation. Tables are just sets of records. Nothing more. Nothing less. SQL references tables as sets of records, but JOINs are referential subsets of tables, not complete tables themse
815.
by ttfkam 4y ago
1999 had many people hitting Ctrl-Alt-Backspace on a semi-regular basis. It was not all puppies and unicorn farts back then.
816.
by ttfkam 4y ago
Oh come on. You are basically arguing that Python is just syntax, not a programming language; it's just the interpreter that parses the text and makes it go. No duh! You've made a distinction without a difference. If an XML dialec
817.
by ttfkam 4y ago
Apparently there's an extension for that! https://github.com/petere/pguint
818.
by ttfkam 4y ago
JSON, and XML are data structures, not programming languages. Can you loop or iterate in JSON or does some other language do the iterating? Can XML execute instructions (without a script tag or processing instruction, which is just punting
819.
by ttfkam 4y ago
S-Expressions are not a set-based construct. Neither is JSON nor XML. Those are all document-oriented and/or hierarchical tree structures. I did not "bless" SQL as a set-based language. It's literally a 4th generation, d
820.
by ttfkam 4y ago
And folks speaking any of the variations of Chinese speech, eg. Cantonese, can still read the ideographs. That's the tradeoff. Whereas in English, a well-educated American can (and does) conceivably encounter words in written English t
821.
by ttfkam 4y ago
Now store a 64-bit unsigned integer in Java. Or TypeScript. Or Lua. Or Python. Now explain why you need an unsigned bigint in this set-oriented language. What's your use case? That said, not a limitation of SQL, just Postgres, who av
822.
by ttfkam 4y ago
As opposed to the US where cops were called on folks BBQing in a public park (where BBQing is allowed)? And the US lacks hate speech regulations. So… no difference? When someone calls with some BS, the police are usually obligated to follow
823.
by ttfkam 4y ago
> I’m not confused as to what that means. …says the guy who fails to recognize that the musician was never taken into custody or charged with a crime. Some folks made an accusation (over a decade ago, by the way). The police followed up
824.
by ttfkam 4y ago
Nope, I'm mostly OLTP. But even mostly OLTP systems need dashboards, even if they're read from periodically refreshed materialized views. I also use things like lateral unnest of arrays for ordering dependent rows. Actually LATERA
825.
by ttfkam 4y ago
A shame Apple silicon isn't in that mix for reference (though I realize how hard apples-to-apples testing would be, no pun intended).
826.
by ttfkam 4y ago
What does a Daily Mail (already suspect source) article about a UK musician in the UK have to do with the statute as written in Germany as it applies to Germans? Right? The previous comment was talking about German law and jurisprudence and
827.
by ttfkam 4y ago
> Disks, especially the cloud SSDs are quite slow defaulting very often to just 3000 write IOPS. And then there's cloud solutions like AWS Aurora that blow those disk IO issues out of the water.
828.
by ttfkam 4y ago
Beware the old man in a young man's game. You will be tempted to underestimate him. As many unremembered before you have done.
829.
by ttfkam 4y ago
Yeah, the "lacks type safety" comment threw me too. SQL has some of the most rigid type safety in my daily interactions in computing. • "Exactly one" • "Optional" • "Text but matching this pa
830.
by ttfkam 4y ago
SQL, as a set-oriented language, composes just fine. • views • CTEs • temporary tables • set-returning functions It will not compose like an OO language or like a functional language because it isn't one of those. It's set-oriente
831.
by ttfkam 4y ago
Here we go… SQL is composable through views, CTEs, temp tables, and set-returning functions. It's a set-oriented language, so its composability is going to be based on sets, not the constructs in your favorite general purpose programmi
832.
by ttfkam 4y ago
CTEs. Views. Set-returning functions. "SQL isn't easily composable" is a pernicious lie. Does it compose like your favorite functional language? No. SQL is not nor has ever been a functional or object-oriented or generic or p
833.
by ttfkam 4y ago
Does GORM allow the use of window functions, pivot tables, recursive queries, filtered aggregates, unnesting arrays, splitting a string into rows, or lateral joins? I mean without an explicit escape valve to write raw SQL queries, which mea
834.
by ttfkam 4y ago
There is an inherent difference between a language where safety is opt-out (safe by default) and opt-in (unsafe by default). Ignorance or forgetfulness leads to safety by default in Rust. A single failure of vigilance in C leads to the stat
835.
by ttfkam 4y ago
https://www.acpjournals.org/doi/10.7326/M20-4186 https://www.reuters.com/article/factcheck-george-floyd-overd... And we'll apparently just skip right over the part where he was cuffed an
836.
by ttfkam 4y ago
> But I am of the opinion that the George Floyd video shows that Chauvin did nothing wrong There is clearly nothing more to say.
837.
by ttfkam 4y ago
Giving the best number available because they can't get that info from police departments. They have to report whenever they discharge their firearm but not necessarily when the bullet hits a person? Does that honestly make sense to yo
838.
by ttfkam 4y ago
FYI: The OP link is cited as a reference to the Wikipedia article you linked. Ask yourself how often you've seen a video where police shoot someone, cuff them, remove all weapons from reach, and then stand by without immediately render
839.
by ttfkam 4y ago
The assertion regarding felonies came from police without much (if any) scrutiny. According to the police report, George Floyd died because of a drug overdose, not because his airway was cut off by a knee to the neck for almost ten minutes.
840.
by ttfkam 4y ago
So perhaps it isn't the verbosity per se of Rust that irks you so. That's fine. No one needs to learn or not learn any given tool.

More ›