ttfkam

32 ms·

391.
by ttfkam 3y ago
> I belive in using the right tool for the job And more of these tools (RDBMSs) are able to perform more jobs. There's definitely use cases for correlating parts of documents with traditional relational data. Quite often there'
392.
by ttfkam 3y ago
Good comparison but seems to be missing how fast they run. If they're about the same, the skill set and expectations of the devs tips the scales. However if one is noticeably faster than the other, especially on a frequently run query,
393.
by ttfkam 3y ago
Suppose the OP wrote the original source code files and recreated them from their own intuition of the problem. Would that be theft?
394.
by ttfkam 3y ago
(I couldn't help but notice you didn't comment on the difference in formatting in the examples.) Do you have examples of PRQL working with jsonpath? Generating JSON? Unnesting arrays? Returning ids from an INSERT or UPDATE without
395.
by ttfkam 3y ago
CTEs and query pipelining are not sufficient?
396.
by ttfkam 3y ago
It's not 1992 anymore. https://youtu.be/8Fb5Qgpr03g?si=Jc7dpuVgws3POiXA It may upset someone's sense of "purity", but the SQL standard and thoughts about the relational model have long since moved on fro
397.
by ttfkam 3y ago
The syntax comparison section will likely sour a lot of viewers who already know SQL. You try too hard to highlight how easy and terse PRQL is by putting comma-separated items on their own lines but in SQL you put each item on separate line
398.
by ttfkam 3y ago
I'm realizing that someone is going to hop in and say, "But that's limited to just a line of text per option with no images or real formatting." And that's true. It's also true that's what most folks actua
399.
by ttfkam 3y ago
I was honestly curious until I hit the listbox comparison. The implementations for competitors look purposefully verbose to make Nue look better. The Svelte one in particular could look substantially similar to Nue, but after adding multipl
400.
by ttfkam 3y ago
> Right, because it's expensive and difficult and would make the train cost more. That you (and others) think network connectivity is anything higher than a rounding error in terms of rail infrastructure costs is likely part of the
401.
by ttfkam 3y ago
I'm not sure how you possibly got that reading from what I wrote. I'm am discussing a solution rather than a series of ephemeral and incomplete fixes. Not that developers can solve public transit issues but that society at large i
402.
by ttfkam 3y ago
As a user, I have very little control over 99.999% of all sites' infrastructures. We were talking about lazy loading on a train. Most users have no control over the HTML attributes they receive. As software developers make up a vanishi
403.
by ttfkam 3y ago
> Similarly, yes, functional indices are quite nice if you know how and when to use them. In fairness to MySQL, you can simulate this surprisingly well by adding indexes to computed columns. > I’d love to see benchmarks comparing the
404.
by ttfkam 3y ago
Wow, so much venom. My point about washing hands was correct. It also applies to quantum physics. And yes, there were old guard geologists that denied it to their death beds just as there were old guard that cling to sublumeniferous aether
405.
by ttfkam 3y ago
AWS RDS and Aurora both support synchronous and asynchronous lambda invocations from the database. Should be used very carefully, but when you want/need a fully event-driven architecture, it's wonderful. https://docs.aw
406.
by ttfkam 3y ago
That isn't my experience at all. MySQL wins at serving a large number of very simple SELECT queries and plain bulk INSERTs. But Postgres wins hands down once the queries get slightly more complex, for larger numbers of concurrent UPDAT
407.
by ttfkam 3y ago
It's curious that some folks hate the side effects of insufficient infrastructure while missing that the lack of modern infrastructure is the root problem. It is entirely possible to get a cell signal on a train, even in tunnels. We as
408.
by ttfkam 3y ago
> I guess refusing to use newer and more accurate SI units isn't nearly as egregious but nonetheless petty. Very very petty.
409.
by ttfkam 3y ago
HBO's "We Own This City" (along with "The Wire") should be required viewing. https://youtu.be/1BgwYXGdHE0?t=1201
410.
by ttfkam 3y ago
Yep, they screwed the pooch with Google Reader and forced Google+ registration. Rather than learn their lessons, they just keep doing the same things over and over, eroding trust, and wondering why they can't get more marketshare in ne
411.
by ttfkam 3y ago
If only there were a way to make consistent structure in an online document (such as hypertext) and separate the styling into distinct files. Even better, what if we could make separate styling for mobile, desktop, and printing, all with th
412.
by ttfkam 3y ago
At least it'll be cheaper than existing offerings… hold on… I'm getting a message from the control booth… gold. It's made with actual gold. Already expensive implants won't be getting any more affordable in the foreseeab
413.
by ttfkam 3y ago
Google Spanner beat the CAP Theorem years ago. It focused on C+P, put in some atomic clocks at every datacenter for synchronization, and then simply accepted the supposition that Google's global network simply never goes down (is alway
414.
by ttfkam 3y ago
Good! Every other device I've bought in the last 3-4 years except for my family's iPhones has had USB-C. Every laptop. Every tablet. Every pair of headphones. Every wireless charging mount. I for one am glad Apple isn't just
415.
by ttfkam 3y ago
I stand corrected: IEC. It's still very petty. And the species isn't doomed. It just has to be patient until the old guard fades away.
416.
by ttfkam 3y ago
> despite all the attacks by gun-control advocates, no one has ever been able to refute Lott’s simple, startling conclusion that more guns mean less crime. Crimes rates vary significantly between the states, with states with such as Alas
417.
by ttfkam 3y ago
By Gen Z, for Gen Z.
418.
by ttfkam 3y ago
Large object (aka BLOBs) and bytea are also both options with Postgres over and above saving base64-encoded text. That said, for email attachment storage, the article is right to consider separate file storage, though you must take take to
419.
by ttfkam 3y ago
That's uncharitable. Google is more likely to return textual and/or scholarly info. TikTok is more likely to produce experiential, opinion, and entertaining content, informational or not. I search YouTube for many of the same reas
420.
by ttfkam 3y ago
> It also deters other potential criminals. [citation needed] The original article would imply this simply ain't so. This follows the same logic that the death penalty acts as a deterrent when no correlation between states with a de

More ›